Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: as a wildcard. to limit the columns displayed. for ranges. None of these as a wildcard. to limit the columns displayed. for ranges. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True 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 'AS' clause is used in SQL for Projection operation. Selection operation. Join operation. Rename operation. Projection operation. Selection operation. Join operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; ANSWER DOWNLOAD EXAMIANS APP