Explore topic-wise MCQs in SQL Server.

This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following is valid syntax for DRILLTHROUGH statement ?

A. DRILLTHROUGH[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]
B. DRILL[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]
C. DRILLTHROUGH[MAXROWSUnsigned_Integer] <MDX SELECT statement>
D. None of the mentioned
Answer» B. DRILL[MAXROWSUnsigned_Integer] <MDX SELECT statement> [RETURNSet_of_Attributes_and_Measures [,Set_of_Attributes_and_Measures ...] ]
Discussion
2.

_________ statement is used to write back data to any cell in a cube that aggregates to its parent using the SUM aggregation.

A. UPDATE CUBE
B. DELETE CUBE
C. ALTER CUBE
D. None of the mentioned
Answer» B. DELETE CUBE
Discussion
3.

_______ is currency used to store transactions on which measures to be converted are based in SSAS.

A. Local currency
B. Pivot currency
C. Global currency
D. None of the mentioned
Answer» B. Pivot currency
Discussion
4.

__________ is the set of hierarchies from which data is retrieved for a single member.

A. Slicer axis
B. Query axes
C. Dice axis
D. All of the mentioned
Answer» B. Query axes
Discussion
5.

____________ distinguishes between a single-byte character and the same character when represented as a double-byte character.

A. Accent-insensitive (_AI)
B. Kana-sensitive (_KS)
C. Accent-sensitive (_AS)
D. Width-sensitive (_WS)
Answer» E.
Discussion
6.

_________ is a category of applications and technologies for presenting and analyzing corporate and external data

A. Data warehouse
B. MIS
C. EIS
D. All of the mentioned
Answer» D. All of the mentioned
Discussion