Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE ALTER COLLAPSE DELETE REMOVE ALTER COLLAPSE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? INSERT SELECT JOIN DELETE INSERT SELECT JOIN DELETE 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. ONLY DISTINCT SINGLE UNIQUE ONLY DISTINCT SINGLE UNIQUE 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 Find the names of the countries whose condition is 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 NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city 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 NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS