Multiple Choice
Which of the following is a potential problem caused by adding too many indexes to a relational database?
A) Too many indexes can slow the performance of the database when there is a large amount of direct retrieval activity.
B) Updating the indexes when the data is updated can slow down queries executing at the same time.
C) Maintaining the security of the database can be adversely affected by the presence of a large number of indexes.
D) All of the above.
E) None of the above.
Correct Answer:

Verified
Correct Answer:
Verified
Q3: One of the reasons for having secondary
Q4: Construct a B+-tree index of the type
Q5: Tracks are concentric circles of data on
Q6: Horizontal partitioning _.<br>A) means dividing the rows
Q7: All of the following are factors affecting
Q9: Consider Table A on the "one side"
Q10: In a hashed file, the hashing algorithm
Q11: The creating a new primary key physical
Q12: In the clustering files physical database design
Q13: The movement of a disk drive's access