Introduction to SQL Which of the following group functions ignore NULL values? SUM COUNT All of these MAX SUM COUNT All of these MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . table report form file table report form file ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows less than 10 rows more than 10 rows None of these exactly 10 rows less than 10 rows more than 10 rows None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE MODIFY UPDATE SAVE AS SAVE MODIFY UPDATE SAVE AS ANSWER DOWNLOAD EXAMIANS APP