Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.

The _________ database stores basic configuration information for the server.(a) Master(b) Msdb(c) Tempdb(d) ModelThis question was posed to me in examination.Question is taken from System Databases in chapter System and Sample Databases of SQL Server

Answer»

The correct ANSWER is (a) Master

The explanation: Master database includes information about the file locations of the USER databases, as well as logon accounts, server configuration SETTINGS, and a NUMBER of other items such as linked servers and STARTUP stored procedures.
Discussion
2.

Which of the following system database occupies more space and memory?(a) Master(b) Msdb(c) Tempdb(d) ModelThis question was posed to me by my school teacher while I was bunking the class.I need to ask this question from System Databases topic in section System and Sample Databases of SQL Server

Answer»

The CORRECT CHOICE is (a) Master

To elaborate: The master database RECORDS all of the system LEVEL information for a SQL Server system.
Discussion
3.

How many types of system databases are present in SQL Server 2008?(a) 3(b) 4(c) 5(d) 6This question was addressed to me in an internship interview.The origin of the question is System Databases topic in portion System and Sample Databases of SQL Server

Answer» CORRECT option is (b) 4

The BEST EXPLANATION: Microsoft SQL Server 2008 have four SYSTEM databases.
Discussion
4.

Which of the following database is used by SQL Server Agent?(a) Pubs(b) Msdb(c) Tempdb(d) ModelThis question was posed to me during an online interview.My question is taken from System Databases topic in section System and Sample Databases of SQL Server

Answer»

The correct answer is (b) MSDB

To explain: The msdb database is used by SQL Server AGENT for SCHEDULING alerts and jobs, and RECORDING operators.
Discussion
5.

Which database is used as template for all databases?(a) Northwind(b) Master(c) Tempdb(d) ModelThe question was posed to me by my college professor while I was bunking the class.The origin of the question is System Databases topic in division System and Sample Databases of SQL Server

Answer»

Correct choice is (d) Model

Explanation: When a CREATE DATABASE STATEMENT is ISSUED, the first part of the database is created by copying in the contents of the model database.
Discussion
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 mentionedI had been asked this question in an online interview.This interesting question is from System Databases in chapter System and Sample Databases of SQL Server

Answer»

The correct choice is (b) MASTER records the information for SQL SERVER temporarily

The best I can EXPLAIN: Master is the database that records the existence of all other databases.
Discussion
7.

Which is the most important system database?(a) Northwind(b) Master(c) Tempdb(d) All of the mentionedThe question was asked in examination.My question is from System Databases topic in portion System and Sample Databases of SQL Server

Answer» CORRECT answer is (b) Master

To explain: The master DATABASE RECORDS all of the system LEVEL information for a SQL SERVER system.
Discussion
8.

Point out the correct statement.(a) By default, tempdb auto grows as needed while SQL Server is running(b) By default, master auto grows as needed while SQL Server is running(c) By default, pubs auto grows as needed while SQL Server is running(d) By default, msdb auto grows as needed while SQL Server is runningI had been asked this question in an online quiz.I want to ask this question from System Databases in division System and Sample Databases of SQL Server

Answer»

Correct choice is (a) By default, tempdb AUTO GROWS as needed while SQL Server is running

The best EXPLANATION: Tempdb HOLDS all temporary tables and temporary stored procedures.
Discussion
9.

Which of the following holds temporary data?(a) Northwind(b) Master(c) Tempdb(d) MsdbI got this question in an interview for job.This key question is from System Databases topic in section System and Sample Databases of SQL Server

Answer» CORRECT choice is (c) TEMPDB

Explanation: Tempdb is a GLOBAL resource; the temporary tables and stored procedures for all users connected to the system are stored there.
Discussion
10.

Which of the following is not a system database?(a) Northwind(b) Master(c) Tempdb(d) All of the mentionedThis question was addressed to me during an online interview.The query is from System Databases topic in section System and Sample Databases of SQL Server

Answer» CORRECT choice is (a) Northwind

For EXPLANATION I would say: Northwind is a SAMPLE database.
Discussion