System Databases MCQ

Test your knowledge with important System Databases MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more System Databases MCQs at Bissoy

• The _________ database stores basic configuration information for the server.
  ক

  Master

  খ

  Msdb

  গ

  Tempdb

  ঘ

  Model
• Which of the following system database occupies more space and memory?
  ক

  Master

  খ

  Msdb

  গ

  Tempdb

  ঘ

  Model
• How many types of system databases are present in SQL Server 2008?
  ক

  3

  খ

  4

  গ

  5

  ঘ

  6
• Which of the following database is used by SQL Server Agent?
  ক

  Pubs

  খ

  Msdb

  গ

  Tempdb

  ঘ

  Model
• Which database is used as template for all databases?
  ক

  Northwind

  খ

  Master

  গ

  Tempdb

  ঘ

  Model
• Point out the wrong statement related to master database.
  ক

  They are used to provide details of an backup plans

  খ

  Master records the information for SQL Server temporarily

  গ

  Master records the initialization information for SQL Server

  ঘ

  None of the mentioned
• Which is the most important system database?
  ক

  Northwind

  খ

  Master

  গ

  Tempdb

  ঘ

  All of the mentioned
• Which of the following holds temporary data?
  ক

  Northwind

  খ

  Master

  গ

  Tempdb

  ঘ

  Msdb
• Which of the following is not a system database?
  ক

  Northwind

  খ

  Master

  গ

  Tempdb

  ঘ

  All of the mentioned