MCQ King
16 – Create Database MCQ
Best of luck!
1 / 25
1. What is the first step in creating a new database in SQL Server Management Studio (SSMS)?
2 / 25
2. In SQL Server, what is the maximum number of characters allowed for a database name?
3 / 25
3. Which SQL Server command is used to create a new database?
4 / 25
4. When creating a new database, which option allows you to specify the initial size of the database files?
5 / 25
5. In SQL Server, what is the purpose of the “Collation” option when creating a database?
6 / 25
6. Which SQL Server option allows you to specify the default schema for a user within the newly created database?
7 / 25
7. What is the purpose of the “Recovery model” option when creating a new database in SQL Server?
8 / 25
8. In SQL Server, which option allows you to specify the filegroup where the primary data file will be stored?
9 / 25
9. When creating a new database, which option is used to set the owner of the database?
10 / 25
10. Which of the following is a valid SQL Server database file extension?
11 / 25
11. What is the purpose of the “Compatibility level” option when creating a new database in SQL Server?
12 / 25
12. In SQL Server, what is the purpose of the “File Type” option when creating a new database?
13 / 25
13. Which statement is true regarding the “Default schema” option when creating a new database in SQL Server?
14 / 25
14. When creating a new database in SQL Server, which option allows you to specify the initial data file size?
15 / 25
15. In SQL Server, what is the primary purpose of the “Model” database?
16 / 25
16. In SQL Server, what is the maximum number of data files that can be added to a single filegroup?
17 / 25
17. Which SQL Server option allows you to specify the default collation for the new database?
18 / 25
18. What is the purpose of the “Owner” option when creating a new database in SQL Server?
19 / 25
19. In SQL Server, what is the maximum number of secondary data files that can be added to a single filegroup?
20 / 25
20. When creating a new database, which option is used to specify the collation for the database?
21 / 25
21. Which SQL Server option allows you to specify the initial size of the transaction log file when creating a new database?
22 / 25
22. In SQL Server, what is the maximum number of filegroups that can be created within a single database?
23 / 25
23. Which option allows you to specify the recovery model for the new database when creating it in SQL Server?
24 / 25
24. In SQL Server, what is the maximum number of databases that can be created on a single instance?
25 / 25
25. What is the default recovery model for new databases in SQL Server?
Your score is
Restart quiz