Introduction to SQL Which of the following must be enclosed in double quotes? Dates All of these Strings Column Alias Dates All of these Strings Column Alias ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE ADD INSERT APPEND UPDATE ADD INSERT APPEND ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these SUM COUNT MAX All of these SUM COUNT MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY DISTINCT UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True False True ANSWER DOWNLOAD EXAMIANS APP