Related InterviewSolutions

• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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