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

This section includes 4 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.

BY_DEFAULT,_INDEXES_ARE_STORED_IN_THE________FILEGROUP_AS_THE_BASE_TABLE_ON_WHICH_THE_INDEX_IS_CREATED.?$

A. same
B. different
C. may be same or different
D. none of the mentioned
Answer» B. different
Discussion
2.

Specifying_the_order_in_which_key_values_are_stored_in_an_index_is_useful_when_queries_referencing_the_table_have_:$

A. ORDER BY clauses
B. SORT clauses
C. WHERE clauses
D. None of the mentioned
Answer» C. WHERE clauses
Discussion
3.

Which of the following guideline is considered during column design ?

A. Keep the length of the index key short for non clustered indexes
B. An xml data type can only be a key column only in an XML index
C. Examine column which have composite primary keys
D. None of the mentioned
Answer» B. An xml data type can only be a key column only in an XML index
Discussion
4.

Setting the SORT_IN_TEMPDB option to ON can direct the SQL Server Database Engine to use ________ to store the intermediate sort results.

A. tempdb
B. master
C. msdb
D. model
Answer» B. master
Discussion