Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: None of these as a wildcard. for ranges. to limit the columns displayed. None of these as a wildcard. for ranges. to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the tuples having temperature greater than 'Paris'. SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS