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 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 NOT IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition 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 NOT IN ('sunny', 'cloudy'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None ANSWER DOWNLOAD EXAMIANS APP
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 Which SQL keyword is used to retrieve a maximum value? MOST MAX TOP UPPER MOST MAX TOP UPPER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? None of these MODIFY TABLE CHANGE TABLE ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. ANSWER DOWNLOAD EXAMIANS APP