Introduction to SQL The result of every SQL query is a table. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 NOT BETWEEN ('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 IN ('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 BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Equijoin Self-Join None of these Non-Equijoin Equijoin Self-Join None of these Non-Equijoin 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 command undo all the updates performed by the SQL in the transaction? TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS