Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q631: Fill in the blank: A __________ index is used to store the address of every tuple in the table for non-primary key attributes.
- A: Primary
- B: Sparse
- C: Secondary
- D: Dense
View Answer
C
Q632: The search key of a primary index is:
- A: The only index key used in the file
- B: The key that specifies the sequential order of the file
- C: The key that is used to find non-clustered index rows
- D: The key that points to all records with a specific search key value
View Answer
B
Q633: Fill in the blank: __________ indices are faster in general because they contain an index record for every search key value.
- A: Sparse
- B: Dense
- C: Primary
- D: Secondary
View Answer
B
Q634: Which type of index is automatically created by PRIMARY KEY constraints?
- A: Clustered Index
- B: Non-clustered Index
- C: Sparse Index
- D: Dense Index
View Answer
A
Q635: Fill in the blank: Non-clustered indexes in SQL Server 7.0 use __________ as row locators if the table has a clustered index.
- A: File ID
- B: Page number
- C: Clustered index key
- D: Row ID
View Answer
C
Q636: What is the main purpose of using views in a database?
- A: To increase data redundancy
- B: To simplify data access and security
- C: To replace indexes
- D: To speed up data insertion
View Answer
B
Q637: A view in a database is essentially a _______.
- A: Physical table
- B: A virtual table
- C: Temporary storage
- D: Backup file
View Answer
B
Q638: Which type of view is a replica of a target master from a single point in time?
- A: Complex View
- B: Simple View
- C: Dynamic View
- D: Materialized View
View Answer
D
Q639: Dynamic views in databases are updated _______.
- A: Periodically, not necessarily on access
- B: Only when the database is updated
- C: Every time they are accessed
- D: Once a day
View Answer
C
Q640: A clustered index in a table can be created on _______.
- A: Only one column
- B: A combination of columns
- C: Any column regardless of uniqueness
- D: A view of the table
View Answer
B