Introduction to SQL Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only NOT IN only IN and NOT IN IN only LIKE only NOT IN only IN and NOT IN IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file form table report file form table report ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. SQL DBase Microsoft Access Oracle SQL DBase Microsoft Access Oracle ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP