Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

WHICH_IS_MINIMUM_PROCESSOR_SPEED_FOR_SQL_SERVER_2008_??$

A. 1.4 GHz
B. 2.4 GHz
C. 3.4 GHz
D. 4.4 GHz
Answer» B. 2.4 GHz
Discussion
2.

The main memory requirements for SQL Server 2008 includes :$

A. Minimum:512 MB
B. Minimum:1 GB
C. Maximum:252 MB
D. Maximum:512 MB
Answer» B. Minimum:1 GB
Discussion
3.

What does the SQL Server setup program requires ?

A. Named Pipes
B. Shared Memory
C. Microsoft Windows Installer 4.5
D. All of the mentioned
Answer» C. Microsoft Windows Installer 4.5
Discussion
4.

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 Standard
Answer» B. Windows Server 2003 SP2 64-bit x64 Datacenter
Discussion
5.

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 database
Answer» E.
Discussion
6.

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 mentioned
Answer» C. Support for up to 256 logical CPUs
Discussion
7.

Which are the SQL Server 2008 R2 components require space more than 1.5 Gb ?

A. SSIS
B. SSAS
C. Client components
D. SSRS
Answer» D. SSRS
Discussion
8.

What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine ?

A. 811 Mb
B. 711 Mb
C. 611 Mb
D. 511 Mb
Answer» C. 611 Mb
Discussion