InterviewSolution
Saved Bookmarks
InterviewSolution
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. |
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 |
|
Answer» The CORRECT option is (a) 1.4 GHz |
|
| 2. |
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 |
|
Answer» RIGHT ANSWER is (c) SMB File Share Easy explanation: SMB STORAGE can be hosted by a Windows File Server or a third PARTY SMB storage device. |
|
| 3. |
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 |
|
Answer» Correct ANSWER is (b) Named Pipes |
|
| 4. |
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 |
|
Answer» The CORRECT ANSWER is (d) All of the mentioned |
|
| 5. |
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 |
|
Answer» Correct option is (d) All of the mentioned |
|
| 6. |
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 |
|
Answer» Right OPTION is (b) SQL Server 2014 CTP 1 is a non-production release and should be installed and USED in production environments |
|
| 7. |
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 |
|
Answer» CORRECT ANSWER is (d) All of the mentioned For explanation: SQL SERVER 2014 CTP 1 may contain branding from MICROSOFT SQL Server 2012 and is versioned as 11.0. |
|
| 8. |
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 |
|
Answer» Correct answer is (C) Client components |
|
| 9. |
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 |
|
Answer» Correct answer is (a) 811 Mb |
|
| 10. |
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 |
|
Answer» The correct choice is (c) RESOURCE database is PART of System database |
|
| 11. |
The main memory requirements for SQL Server 2008 includes ___________(a) Minimum:512 MB(b) Minimum:1 GB(c) Maximum:252 MB(d) Maximum:512 MBI got this question in an international level competition.I'm obligated to ask this question of Specifications topic in chapter SQL Server Specifications of SQL Server |
|
Answer» RIGHT CHOICE is (a) Minimum:512 MB For explanation: Recommended RAM is 2.048 GB or more for SQL Server 2008. |
|
| 12. |
Point out the correct statement.(a) SQL Server books online is part of Microsoft SQL Server(b) SQL Server books online is not a part of Microsoft SQL Server(c) SQL Server books online needs to be downloaded separately(d) None of the mentionedThe question was posed to me in semester exam.Origin of the question is Specifications topic in section SQL Server Specifications of SQL Server |
|
Answer» The correct CHOICE is (C) SQL Server BOOKS ONLINE needs to be downloaded separately |
|
| 13. |
Which of the following operating system is Supported by IA-64 Edition?(a) Windows Server 2003 R2 SP2 64-bit Itanium Datacenter(b) Windows Server 2003 SP2 64-bit x64 Datacenter(c) Windows Server 2003 SP2 64-bit x64 Enterprise(d) Windows Server 2003 SP2 64-bit x64 StandardThe question was asked during an interview.My question is taken from Specifications in section SQL Server Specifications of SQL Server |
|
Answer» Correct ANSWER is (a) Windows Server 2003 R2 SP2 64-bit Itanium Datacenter |
|
| 14. |
Which is the minimum processor speed for SQL Server 2008?(a) 1.4 GHz(b) 2.4 GHz(c) 3.4 GHz(d) 4.4 GHzThe question was posed to me at a job interview.I'd like to ask this question from Specifications in section SQL Server Specifications of SQL Server |
|
Answer» CORRECT answer is (a) 1.4 GHZ For explanation: Recommended SPEED is 2.0 GHz or FASTER. |
|
| 15. |
What does the SQL Server setup program require?(a) Named Pipes(b) Shared Memory(c) Microsoft Windows Installer 4.5(d) All of the mentionedI had been asked this question in a national level competition.My doubt stems from Specifications topic in division SQL Server Specifications of SQL Server |
|
Answer» Right option is (b) Shared Memory |
|
| 16. |
Which of the following is not a feature of SQL Server 2008 R2 Enterprise?(a) Hot-add CPU(b) Hot-add RAM(c) Database partitioning(d) In memory databaseThe question was asked during an interview.My doubt stems from Specifications topic in chapter SQL Server Specifications of SQL Server |
|
Answer» RIGHT ANSWER is (d) In memory database Best explanation: In-memory database capability is PROVIDED by 2012. |
|
| 17. |
Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?(a) SSIS(b) SSAS(c) Client components(d) SSRSI have been asked this question during a job interview.I'm obligated to ask this question of Specifications in chapter SQL Server Specifications of SQL Server |
|
Answer» The correct answer is (c) Client COMPONENTS |
|
| 18. |
Which of the following is a feature of SQL Server 2008 R2 Datacenter?(a) StreamInsight Premium real-time event processing(b) Support for 32-bit and 64-bit processors(c) Support for up to 256 logical CPUs(d) All of the mentionedThis question was posed to me in an online quiz.My question is from Specifications topic in portion SQL Server Specifications of SQL Server |
|
Answer» Right choice is (B) Support for 32-bit and 64-bit processors |
|
| 19. |
Point out the wrong statement.(a) The Datacenter edition provides the maximum scalability of the different SQL Server 2008 R2 editions(b) The Datacenter edition is priced at $11,990 per processor(c) There are several different editions of SQL Server(d) None of the mentionedThe question was asked in examination.I want to ask this question from Specifications in division SQL Server Specifications of SQL Server |
|
Answer» Correct ANSWER is (B) The Datacenter edition is priced at $11,990 per processor |
|
| 20. |
What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?(a) 811 Mb(b) 711 Mb(c) 611 Mb(d) 511 MbI got this question during an online interview.My doubt is from Specifications topic in portion SQL Server Specifications of SQL Server |
|
Answer» Right choice is (B) 711 Mb |
|