MCQ King

MS SQL Server – 60 – System Databases MCQ

60 – System Databases MCQ

1 / 25

1. What is the purpose of the “master” database in SQL Server?

2 / 25

2. Which database in SQL Server is used as a template for creating new databases?

3 / 25

3. In SQL Server, what is the primary role of the “tempdb” database?

4 / 25

4. Which database in SQL Server contains system catalogs and metadata information?

5 / 25

5. What is the purpose of the “msdb” database in SQL Server?

6 / 25

6. Which database in SQL Server is used for managing and storing backup and restore history?

7 / 25

7. What happens when you restart SQL Server?

8 / 25

8. Which database in SQL Server is used to store temporary user objects and query results?

9 / 25

9. In SQL Server, which database is typically used to store information related to maintenance plans and SQL Server Agent jobs?

10 / 25

10. What is the primary purpose of the “model” database in SQL Server?

11 / 25

11. Which database in SQL Server serves as a starting point when creating a new user database?

12 / 25

12. In SQL Server, which database stores system catalogs and metadata information used by the entire instance?

13 / 25

13. What is the primary role of the “tempdb” database in SQL Server?

14 / 25

14. Which database in SQL Server is used to store temporary user objects, such as tables and indexes, created during sessions?

15 / 25

15. In SQL Server, which database contains information related to scheduled jobs, alerts, and operators?

16 / 25

16. What happens to the “model” database in SQL Server when you create a new user database?

17 / 25

17. Which database in SQL Server is used to store information related to database backup and restore operations?

18 / 25

18. What is the primary function of the “tempdb” database in SQL Server?

19 / 25

19. In SQL Server, which database is crucial for the proper functioning of temporary tables and stored procedures?

20 / 25

20. Which database in SQL Server is used for storing metadata about the database system?

21 / 25

21. What is the primary function of the “msdb” database in SQL Server?

22 / 25

22. Which database in SQL Server is responsible for storing system-wide configuration settings?

23 / 25

23. In SQL Server, which database is primarily used for temporary storage of query results and intermediate data?

24 / 25

24. What is the primary function of the “model” database in SQL Server?

25 / 25

25. Which database in SQL Server contains information related to database maintenance plans?

Your score is

LinkedIn Facebook Twitter VKontakte
0%