Introduction to SQL SQL can be used to: modify database data only. create database structures only. query database data only. All of these modify database data only. create database structures only. query database data only. All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE ALTER REMOVE COLLAPSE DELETE ALTER REMOVE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. 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 ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT,WHERE,FROM SELECT, FROM, WHERE FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE FROM, WHERE, SELECT WHERE, FROM,SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79 SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity IN (63 to 79) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS