DBMS - SQL MCQ

Database

Title
Which of the following command makes the updates performed by the transaction permanent in the database?
Which command undo all the updates performed by the SQL in the transaction?
Find all the cities whose humidity is 89
Find the temperature in increasing order of all cities
What is the meaning of LIKE \'%0%0%\'
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70F
Find all the tuples having temperature greater than \'Paris\'
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
Find the names of the countries whose condition is sunny
Find the name of all cities with their temperature, humidity and countries
Find the name of cities with all entries whose temperature is in the range of 71 and 89
Which of the following query finds the names of the sailors who have reserved at least one boat?
Which of the following query finds colors of boats reserved by \"Dustin\"?
What does the following query find?
Which of the following query finds the name of the sailors who have reserved at least two boats?
Which of the following query finds the total rating of the sailors who have reserved boat \"103\"?
The SELECT statement SELECT \'Hi\' FROM DUAL WHERE NULL = NULL; Outputs
If a query involves NOT, AND, OR with no parenthesis
Let the statement

Questions

Views

Best Answers

Points