Introduction to SQL Which of the following SQL commands can be used to add data to a database table? ADD APPEND UPDATE INSERT ADD APPEND UPDATE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? MAX All of these SUM COUNT MAX All of these SUM COUNT 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 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
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? None of these SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users SELECT Username AND Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users SELECT Username AND Password FROM Users ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS