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 ?

A. ROLLBACK

B. COMMIT

C. TRUNCATE

D. DELETE

Correct Answer is : COMMIT

2. Which TCL command undo all the updates performed by the SQL in the transaction ?

A. ROLLBACK

B. COMMIT

C. TRUNCATE

D. DELETE

Correct Answer is : COMMIT

3. SQL query to find all the cities whose humidity is 95 .

A. SELECT city WHERE humidity = 95

B. SELECT city FROM weather WHERE humidity = 95

C. SELECT humidity = 89 FROM weather

D. SELECT city FROM weather

Correct Answer is : SELECT city FROM weather WHERE humidity = 95

4. SQL query to find the temperature in increasing order of all cities.

A. SELECT city FROM weather ORDER BY temperature

B. SELECT city, temperature FROM weather

C. SELECT city, temperature FROM weather ORDER BY temperature

D. SELECT city, temperature FROM weather ORDER BY city

Correct Answer is : SELECT city, temperature FROM weather ORDER BY city

5. What is the meaning of LIKE ‘%0%0%’ ?

A. Feature begins with two 0’s

B. Feature ends with two 0’s

C. Feature has more than two 0’s

D. Feature has two 0’s in it, at any position

Correct Answer is : Feature has two 0’s in it, at any position

SQL:2008 interview questions