Discussion
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data
Answer: A
Correct answer: Nonclustered
A nonclustered index holds only the key values and pointers to the rows, which live elsewhere in whatever order the clustered index or the heap imposes. A table may have many of them, and each costs storage and maintenance on every write, so they are added where a query needs one rather than as a matter of course.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development