Introduction to SQL Which of the following group functions ignore NULL values? COUNT SUM MAX All of these COUNT SUM MAX All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... None of these specify range for search condition specify what table we are selecting or deleting data FROM specify search condition None of these specify range for search condition specify what table we are selecting or deleting data FROM specify search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: for ranges. as a wildcard. None of these to limit the columns displayed. for ranges. as a wildcard. None of these to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ALTER ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS