Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN NOT IN only LIKE only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM FROM, WHERE, SELECT SELECT, FROM, WHERE WHERE, FROM,SELECT SELECT,WHERE,FROM FROM, WHERE, SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): IN only. LIKE only. NOT IN only. Both IN and NOT IN. IN only. LIKE only. NOT IN only. Both IN and NOT IN. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCT DISTINCTIVE UNIQUE DIFFERENT DISTINCT DISTINCTIVE UNIQUE DIFFERENT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character the same as 0 for integer the same as 0 for integer and blank for character not a value the same as blank for character the same as 0 for integer the same as 0 for integer and blank for character not a value ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP