Introduction to SQL SQL data definition commands make up a(n) ________ . HTML XML DML DDL HTML XML DML DDL ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: SORT BY. GROUP BY. None of these ORDER BY. SORT BY. GROUP BY. None of these ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MOST UPPER MAX TOP MOST UPPER MAX TOP ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the names of the countries whose condition is sunny. SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE condition = 'sunny'; SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE condition = 'sunny'; ANSWER DOWNLOAD EXAMIANS APP