Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Hi Nothing FLASE TRUE Hi Nothing FLASE TRUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 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; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the row data are returned. Both A and B are correct. limits the column data that are returned. Neither A nor B are correct. limits the row data are returned. Both A and B are correct. limits the column data that are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: query database data only. All of these modify database data only. create database structures only. query database data only. All of these modify database data only. create database structures only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these IS NULL operator NOT operator EXISTS operator None of these IS NULL operator NOT operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP