Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q621: What does a clustered index determine in a database table?
- A: The physical storage order of data
- B: The logical order of data
- C: The index key value for data
- D: The total number of records
View Answer
A
Q622: A secondary index must contain pointers to:
- A: Only the first record with each search-key value
- B: All records with the same search-key value
- C: Records with unique search-key values
- D: Records with non-unique search-key values
View Answer
B
Q623: What is true about non-clustered indexes compared to clustered indexes?
- A: Non-clustered indexes store the data rows in order based on their key values
- B: Non-clustered indexes do not affect the physical storage order of data
- C: Non-clustered indexes are automatically created by PRIMARY KEY constraints
- D: Non-clustered indexes are created to speed up sequential scans
View Answer
B
Q624: Dense indices generally:
- A: Require less space and maintenance than sparse indices
- B: Contain an index record for every search key value in the file
- C: Are faster in general than sparse indices
- D: Are used only for non-primary key attributes
View Answer
B
Q625: A composite index:
- A: Can only be created on a single field
- B: Uses multiple fields as the search key
- C: Can only be used for range queries
- D: Stores data entries based on a single field
View Answer
B
Q626: Which of the following is NOT a property of indexes?
- A: Indexes can be created without data in the table
- B: Indexes support equality selections
- C: Indexes are always ordered by the search key value
- D: Indexes cannot be updated without affecting the base tables
View Answer
C
Q627: The purpose of a primary index is to:
- A: Provide a sorted order based on a secondary attribute
- B: Store data in random order for faster access
- C: Organize data in the table based on the primary key attribute
- D: Allow fast access to data based on a non-primary key attribute
View Answer
C
Q628: Sparse indices:
- A: Have an index record for every search key value
- B: Require more space than dense indices
- C: Are typically used to save space and reduce maintenance
- D: Provide faster access than dense indices in all cases
View Answer
C
Q629: What must be updated whenever a record is inserted or deleted from a file?
- A: The index associated with the file
- B: Only the file itself
- C: Only the data records
- D: No updates are necessary
View Answer
A
Q630: A clustered index can be created on:
- A: Only one column
- B: Multiple columns
- C: A combination of columns or a single column
- D: Only columns that are part of the PRIMARY KEY
View Answer
C