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 SQL statements deletes all rows in table called SalesData?

A. DELETE SalesData

B. DELETE * FROM SalesData

C. DELETE ALL SalesData

D. DELETE FROM SalesData

Correct Answer is : DELETE FROM SalesData

2. Which SQL statement selects all rows from a table called Products and sorts the result set by ProductID column?

A. SELECT * FROM Products WHERE ProductID > 200

B. SELECT ProductID FROM Products

C. SELECT * FROM Products ORDERED BY ProductID

D. SELECT * FROM Products ORDER BY ProductID

Correct Answer is : SELECT ProductID FROM Products

3. RDBMS stands for

A. Real Database Management System

B. Read Database Master System

C. Relational Database Management System

D. Remote DataBase Management System

Correct Answer is : Relational Database Management System

4. Which SQL statement is used to extract data from a database?

A. EXTRACT

B. OPEN

C. GET

D. SELECT

Correct Answer is : SELECT

5. For which of the following can you fire triggers

A. INSERT, UPDATE and DELETE commands

B. SEARCH operation

C. Arrange data in sorted ORDER

D. JOIN two tables to retrieve values

Correct Answer is : INSERT, UPDATE and DELETE commands

SQL 2008 interview questions