Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the column data that are returned. Both A and B are correct. limits the row data are returned. Neither A nor B are correct. limits the column data that are returned. Both A and B are correct. limits the row data are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER BY SORT ORDER SORT BY ORDER BY SORT ORDER SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: None of these for ranges. as a wildcard. to limit the columns displayed. None of these for ranges. as a wildcard. to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS