Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: for ranges. to limit the columns displayed. as a wildcard. None of these for ranges. to limit the columns displayed. as a wildcard. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . READ SELECT QUERY None of these READ SELECT QUERY None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: modify database data only. create database structures only. All of these query database data only. modify database data only. create database structures only. All of these query database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of cities with all entries whose temperature is in the range of 71 and 89 SELECT * FROM weather WHERE temperature NOT IN (71 and 89); SELECT * FROM weather WHERE temperature NOT IN (71 to 89); SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; SELECT * FROM weather WHERE temperature NOT IN (71 and 89); SELECT * FROM weather WHERE temperature NOT IN (71 to 89); SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS