Related InterviewSolutions

• Which is the minimum processor speed for SQL Server 2012?(a) 1.4 GHz(b) 2.4 GHz(c) 3.4 GHz(d) 4.4 GHzThe question was asked during an internship interview.The origin of the question is Specifications in section SQL Server Specifications of SQL Server
• The supported storage types for data files are ___________(a) RAM(b) Hard Storage(c) SMB File Share(d) None of the mentionedI had been asked this question during an online interview.Enquiry is from Specifications in division SQL Server Specifications of SQL Server
• Which of the following component is not installed by SQL Server setup 2012 required by the product?(a) .NET Framework 3.5 SP11(b) Named Pipes(c) SQL Server Setup support files(d) All of the mentionedThe question was posed to me in homework.My question is based upon Specifications topic in portion SQL Server Specifications of SQL Server
• Which of the following is a feature of SQL Server 2012 R2 Enterprise?(a) In memory database(b) Hot-add RAM(c) Database partitioning(d) All of the mentionedThis question was addressed to me in exam.This interesting question is from Specifications topic in division SQL Server Specifications of SQL Server
• Which of the following operating system is supported by SQL Server 2014?(a) Windows Server 2012(b) Windows 8 RTM(c) Windows Vista SP2(d) All of the mentionedThis question was posed to me during an online exam.My enquiry is from Specifications topic in chapter SQL Server Specifications of SQL Server
• Point out the wrong statement related to SQL Server 2014.(a) SQL Server 2014 CTP 1 is pre-release software and should be installed only on a clean machine(b) SQL Server 2014 CTP 1 is a non-production release and should be installed and used in production environments(c) SQL Server 2014 CTP 1 is only available in the English language(d) None of the mentionedI have been asked this question in class test.This question is from Specifications in chapter SQL Server Specifications of SQL Server
• Which of the following is a feature of SQL Server 2014?(a) Column oriented database(b) Support for 32-bit and 64-bit processors(c) In memory database(d) All of the mentionedThis question was posed to me at a job interview.I need to ask this question from Specifications topic in division SQL Server Specifications of SQL Server
• Which components of SQL Server 2014 require 1182 Mb?(a) SSIS(b) SSAS(c) Client components(d) SSRSThe question was posed to me in a national level competition.My question is from Specifications topic in chapter SQL Server Specifications of SQL Server
• What is SQL Server 2012 R2 Hard Disk Space Requirement for database engine?(a) 811 Mb(b) 711 Mb(c) 611 Mb(d) 511 MbThe question was posed to me in a job interview.My doubt stems from Specifications in portion SQL Server Specifications of SQL Server
• Point out the correct statement.(a) SQL Server books online is part of Microsoft SQL Server 2012(b) SQL Server books online is not a part of Microsoft SQL Server 2008(c) Resource database is part of System database(d) None of the mentionedI had been asked this question in class test.This interesting question is from Specifications in chapter SQL Server Specifications of SQL Server