Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q611: Which type of index involves ordering records based on non-key attributes?
- A: Primary index
- B: Composite index
- C: Secondary index
- D: Hash index
View Answer
C
Q612: Fill in the blank: An index in a database helps to find data quickly by _______ the entire table.
- A: scanning
- B: reading
- C: skipping
- D: sorting
View Answer
C
Q613: Fill in the blank: A __________ index is used to store records in order of a primary key attribute.
- A: primary
- B: secondary
- C: unique
- D: composite
View Answer
A
Q614: What is a composite index?
- A: A single index on one column
- B: A unique index on a column
- C: A multiple-column index
- D: A hash index
View Answer
C
Q615: Fill in the blank: The SQL command to create an index on a table column is _______.
- A: CREATE INDEX
- B: CREATE TABLE
- C: CREATE VIEW
- D: CREATE FUNCTION
View Answer
A
Q616: Which index classification allows searching on multiple columns?
- A: Single Key Index
- B: Composite Index
- C: Tree-based Index
- D: Secondary Index
View Answer
B
Q617: What are the two major types of indexes in databases?
- A: Primary and Secondary Indexes
- B: Clustered and Un-clustered Indexes
- C: Composite and Single Key Indexes
- D: Tree-based and Hash Indexes
View Answer
B
Q618: Fill in the blank: __________ indexes support equality selections.
- A: Tree
- B: Hash
- C: Composite
- D: Secondary
View Answer
B
Q619: Which indexing technique uses a two-column file to store addresses of tuples?
- A: Primary Index
- B: Secondary Index
- C: B-tree Index
- D: Hash Index
View Answer
B
Q620: Fill in the blank: The SQL command `CREATE UNIQUE INDEX pr_prName ON program(prName)` creates an index on a _______.
- A: single column
- B: multiple columns
- C: primary key
- D: foreign key
View Answer
A