Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
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
EXAMIANS