Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. NOT IN only LIKE only IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? EXISTS operator IS NULL operator None of these NOT operator EXISTS operator IS NULL operator None of these NOT operator ANSWER DOWNLOAD EXAMIANS APP