MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WHICH_OF_THE_FOLLOWING_SYSTEM_DATABASE_OCCUPIES_MORE_SPACE_AND_MEMORY??$ |
| A. | Master |
| B. | Msdb |
| C. | Tempdb |
| D. | Model |
| Answer» B. Msdb | |
| 2. |
The___________database_stores_basic_configuration_information_for_the_server.$ |
| A. | Master |
| B. | Msdb |
| C. | Tempdb |
| D. | Model |
| Answer» B. Msdb | |
| 3. |
How many types of system databases are present in SQL Server 2008? |
| A. | 3 |
| B. | 4 |
| C. | 5 |
| D. | 6 |
| Answer» C. 5 | |
| 4. |
Which of the following database is used by SQL Server Agent? |
| A. | Pubs |
| B. | Msdb |
| C. | Tempdb |
| D. | Model |
| Answer» C. Tempdb | |
| 5. |
Which database is used as template for all databases? |
| A. | Northwind |
| B. | Master |
| C. | Tempdb |
| D. | Model |
| Answer» E. | |
| 6. |
Point out the wrong statement related to master database : |
| A. | They are used to provide details of an backup plans |
| B. | master records the information for SQL Server temporarily |
| C. | master records the initialization information for SQL Server |
| D. | None of the mentioned |
| Answer» C. master records the initialization information for SQL Server | |
| 7. |
Which is the most important system database? |
| A. | Northwind |
| B. | Master |
| C. | Tempdb |
| D. | All of the mentioned |
| Answer» C. Tempdb | |
| 8. |
Which of the following holds temporary data? |
| A. | Northwind |
| B. | Master |
| C. | Tempdb |
| D. | Msdb |
| Answer» D. Msdb | |
| 9. |
Which of the following is not a system database? |
| A. | Northwind |
| B. | Master |
| C. | Tempdb |
| D. | All of the mentioned |
| Answer» B. Master | |