Home > Information Technology (IT) Support Executive > Quizzes > Database System Assistant Practice Test: SQL Server
Database System Assistant Practice Test: SQL Server
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 60% • Most missed: “Command used to shrink the size of the database is”
Database System Assistant Practice Test: SQL Server
Time left 00:00
25 Questions

1. Which of the following database cannot be dropped?
2. Purpose of GET_TRANSMISSION_STATUS is
3. Which of the following statement modifies view index?
4. Which of the following statement drops the synonym?
5. Purpose of ALTER CERTIFICATE is __________      
6. Which of the following scenario makes use of BEGIN..END keyword redundant?
7. Purpose of CLOSE MASTER KEY is __________    
8. Point out the wrong statement with respect to ALTER INDEX statement.
9. Which of the following language is used for procedural flow in SQL Server?
10. Which of the following components constitutes use CASE expression?
11. Which of the following creates a new Microsoft Windows or SQL Server login account?
12. DDL statements not used for Synonym is
13. Applications that can generate Transact-SQL can be __________ __________
14. The BEGIN and END statements are used when
15. RECEIVE service broker statement applies to which of the versions?
16. Which of the following is a security statement?
17. Which of the following statement decrypts a symmetric key?
18. Which of the following adds MOVE TO clause?
19. The DROP DATABASE statement must run in __________ mode.
20. Which of the following database should be backed up regularly?
21. Point out the correct statement.
22. Which of the following index options are added by the CREATE INDEX statement?
23. Which of the following Statement ends one side of an existing conversation?
24. Which of the following statement is used to create database snapshot?
25. Statement used to remove a user from the current database is __________ __________

⚡ Recently practiced quizzes in this topic
Live quiz activity
Multimedia Animation and Special Effects Practice Test: Basics of 3ds Max Database System Assistant Practice Test: Introduction To Database Assistant Database System Assistant Practice Test: Open Tools in Database Systems Information Technology Support Executive Practice Test: PageMaker & CorelDraw Database System Assistant Practice Test: MySQL Open Source Database Database System Assistant Practice Test: Taking Backup and Restoring Backup
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.