SQL Server MCQ Questions and Answers-

1.Which SQL function is used to count the number of rows in a SQL query ?
COUNT(*)

2. Which SQL keyword is used to retrieve a maximum value ?

3.Which of the following SQL clauses is used to DELETE tuples from a database table ?

4.___________removes all rows from a table without logging the individual row deletions.
Veiw Answer
TRUNCATE

5.Which of the following is not a DDL command ?

6. Which of the following are TCL commands ?
Veiw Answer
ROLLBACK and SAVEPOINT

7.________________ is not a category of SQL command.