Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE SAVE AS MODIFY UPDATE SAVE SAVE AS MODIFY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT ONLY SINGLE UNIQUE DISTINCT ONLY SINGLE UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: CAPITAL LETTERS. brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. braces -- {...}. parenthesis -- (...) . ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS