Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MAX UPPER TOP MOST MAX UPPER TOP MOST ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these NOT operator IS NULL operator EXISTS operator None of these NOT operator IS NULL operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; is illegal prints garbage prints 50 prints 045.926 is illegal prints garbage prints 50 prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM MAX All of these COUNT SUM MAX All of these COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ALTER DELETE ANSWER DOWNLOAD EXAMIANS APP