SQL 2008 Interview Questions | Snaprecruit.com
SQL 2008 Interview Questions | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
SQL 2008 interview questions
SQL 2008 interview questions
Back
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
INSERT, UPDATE and DELETE commands
Similar Interview Questions
Search for latest jobs
Find Jobs