MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
IN_________________INDEX_INSTEAD_OF_STORING_ALL_THE_COLUMNS_FOR_A_RECORD_TOGETHER,_EACH_COLUMN_IS_STORED_SEPARATELY_WITH_ALL_OTHER_ROWS_IN_AN_INDEX.?$ |
| A. | Clustered |
| B. | Column store |
| C. | Non clustered |
| D. | Row store |
| Answer» C. Non clustered | |
| 2. |
A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.$ |
| A. | Clustered |
| B. | Non Clustered |
| C. | Covering |
| D. | B-Tree |
| Answer» D. B-Tree | |
| 3. |
If an index is _________________ the metadata and statistics continue to exist? |
| A. | Disabling |
| B. | Dropping |
| C. | Altering |
| D. | Both Disabling and Dropping |
| Answer» B. Dropping | |
| 4. |
What are composite indexes? |
| A. | Are those which are composed by database for its internal use |
| B. | A composite index is a combination of index on 2 or more columns |
| C. | Composite index can never be created |
| D. | None of the mentioned |
| Answer» C. Composite index can never be created | |
| 5. |
Does index take space in the disk? |
| A. | It stores memory as and when required |
| B. | Yes, Indexes are stored on disk |
| C. | Indexes are never stored on disk |
| D. | Indexes take no space |
| Answer» C. Indexes are never stored on disk | |
| 6. |
What is true about indexes? |
| A. | Indexes enhance the performance even if the table is updated frequently |
| B. | It makes harder for sql server engines to work to work on index which have large keys |
| C. | It doesn’t make harder for sql server engines to work to work on index which have large keys |
| D. | None of the mentioned |
| Answer» C. It doesn‚Äö√Ñ√∂‚àö√ë‚àö¬•t make harder for sql server engines to work to work on index which have large keys | |
| 7. |
Which one is true about clustered index? |
| A. | Clustered index is not associated with table |
| B. | Clustered index is built by default on unique key columns |
| C. | Clustered index is not built on unique key columns |
| D. | None of the mentioned |
| Answer» C. Clustered index is not built on unique key columns | |
| 8. |
How non clustered index point to the data? |
| A. | It never points to anything |
| B. | It points to a data row |
| C. | It is used for pointing data rows containing key values |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 9. |
How many types of indexes are there in sql server? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» C. 3 | |
| 10. |
What is the purpose of the index in sql server? |
| A. | To enhance the query performance |
| B. | To provide an index to a record |
| C. | To perform fast searches |
| D. | All of the mentioned |
| Answer» E. | |