Introduction to SQL What operator tests column for the absence of data? None of these NOT operator EXISTS operator IS NULL operator None of these NOT operator EXISTS operator IS NULL operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. False True False True 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. UNIQUE ONLY DISTINCT SINGLE UNIQUE ONLY DISTINCT SINGLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS