SQL Server interview questions part 3
SQL Server interview questions part 3
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Backup can occur while the database is in ___________ state.
Correct Answer is : Online
2. Which of the following is not a type of backup ?
Correct Answer is : table backup
3. _________ backups represent the whole database at the time the backup finished.
Correct Answer is : database backup
4. Which of the following backups contain transaction logs ?
Correct Answer is : None of the mentioned
5. ____________ contains data from only some of the filegroups in a database.
Correct Answer is : partial
6. Which SQL function is used to count the number of rows in a SQL query ?
Correct Answer is : COUNT(*)
7. Which SQL keyword is used to retrieve a maximum value ?
Correct Answer is : MAX
8. Which of the following SQL clauses is used to DELETE tuples from a database table ?
Correct Answer is : DELETE
9. ___________removes all rows from a table without logging the individual row deletions.
Correct Answer is : TRUNCATE
10. Which of the following is not a DDL command ?
Correct Answer is : UPDATE
11. Which of the following are TCL commands ?
Correct Answer is : ROLLBACK and SAVEPOINT
12. ________________ is not a category of SQL command.
Correct Answer is : SCL
13. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
Correct Answer is : ASC
14. Which of the following statement is true ?
Correct Answer is : DELETE does not free the space containing the table and TRUNCATE free the space containing the table
15. What is the purpose of the SQL AS clause ?
Correct Answer is : The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column
16. What does DML stand for ?
Correct Answer is : Data Manipulation language
17. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?
Correct Answer is : SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
18. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName” ?
Correct Answer is : SELECT * FROM Persons ORDER BY FirstName DESC
19. With SQL, how can you return the number of not null records in the “Persons” table ?
Correct Answer is : SELECT COUNT() FROM Persons
20. What does the ALTER TABLE clause do ?
Correct Answer is : The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
