Introduction to SQL Which SQL keyword is used to sort the result-set? SORT BY ORDER SORT ORDER BY SORT BY ORDER SORT ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN NON-EQUIJOIN EQUIJOIN OUTER JOIN NATURAL JOIN NON-EQUIJOIN EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT humidity = 89 FROM weather; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP