Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND UPDATE INSERT ADD APPEND UPDATE INSERT ADD 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 ORDER BY can be combined with the SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. can only be used with two tables. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s): NOT IN only. IN only. LIKE only. Both IN and NOT IN. NOT IN only. IN only. LIKE only. Both IN and NOT IN. ANSWER DOWNLOAD EXAMIANS APP