Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEFT AVG LEN JOIN LEFT AVG LEN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Increased dependence on a single vendor All of these Applications are not needed Reduced training costs Increased dependence on a single vendor All of these Applications are not needed Reduced training costs ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of distinct values. columns. values. groups. distinct values. columns. values. groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify range for search condition None of these specify search condition specify what table we are selecting or deleting data FROM specify range for search condition None of these specify search condition specify what table we are selecting or deleting data FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN NOT IN only IN only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS