Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX SUM COUNT All of these MAX SUM COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER DELETE COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) asterisk (*); percent sign (%) percent sign (%); underscore (_) question mark (?); asterisk (*) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS