SQL:2008 interview questions
SQL:2008 interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 5
1. Which of the following command makes the updates performed by the transaction permanent in the database ?
Correct Answer is : COMMIT
2. Which TCL command undo all the updates performed by the SQL in the transaction ?
Correct Answer is : COMMIT
3. SQL query to find all the cities whose humidity is 95 .
Correct Answer is : SELECT city FROM weather WHERE humidity = 95
4. SQL query to find the temperature in increasing order of all cities.
Correct Answer is : SELECT city, temperature FROM weather ORDER BY city
5. What is the meaning of LIKE ‘%0%0%’ ?
Correct Answer is : Feature has two 0’s in it, at any position
