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_OF_THE_FOLLOWING_PARTITIONED_ATTRIBUTE_CAN_APPEAR_IN_THE_FOLLOWING_PHYSICAL_AND_LOGICAL_OPERATORS_??$

A. Index Seek
B. Drop
C. Alter
D. None of the mentioned
Answer» B. Drop
Discussion
2.

The_query_processor_uses_a____________execution_strategy_for_queries_that_select_from_partitioned_objects.$

A. distributed
B. parallel
C. lock
D. none of the mentioned
Answer» C. lock
Discussion
3.

SQL Server 2008 provides enhanced partitioning information for __________ execution plans?

A. compile-time
B. run time
C. both compile-time and run-time
D. all of the mentioned
Answer» D. all of the mentioned
Discussion
4.

With a larger number of partitions, ______ commands could take longer to execute as the number of partitions increases.

A. DML
B. DDL
C. DBCC
D. TCL
Answer» D. TCL
Discussion
5.

At least _______ of RAM is recommended if a large number of partitions are in use.

A. 16 GB
B. 4 GB
C. 8 GB
D. 2 GB
Answer» B. 4 GB
Discussion
6.

Designing an nonaligned partitioned index can be useful in the following case :

A. The base table has not been partitioned
B. The index key is unique and it does not contain the partitioning column of the table
C. You want the base table to participate in collocated joins with more tables using different join columns
D. All of the mentioned
Answer» E.
Discussion
7.

__________ is a database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column

A. Partition function
B. Partition scheme
C. Partition column
D. All of the mentioned
Answer» B. Partition scheme
Discussion
8.

SQL Server 2014 supports up to ________ partitions by default.

A. 20000
B. 2000
C. 1000
D. 15000
Answer» E.
Discussion