Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ALTER DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the names of the countries whose condition is 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'; SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE INSERT APPEND ADD UPDATE INSERT APPEND ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True 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): Both IN and NOT IN. LIKE only. IN only. NOT IN only. Both IN and NOT IN. LIKE only. IN only. NOT IN only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Hi Nothing TRUE FLASE Hi Nothing TRUE FLASE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS