Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only IN only NOT IN only IN and NOT IN LIKE only IN only NOT IN only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
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? SUM All of these COUNT MAX SUM All of these COUNT MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? All of these CHANGE TABLE MODIFY TABLE ALTER TABLE All of these CHANGE TABLE MODIFY TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS