Introduction to SQL Which one of the following sorts rows in SQL? ORDER BY ALIGN BY SORT BY GROUP BY ORDER BY ALIGN BY SORT BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM MAX COUNT All of these SUM MAX COUNT All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER DELETE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN NOT IN only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS