Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q641: Which of the following is NOT a type of view mentioned in the material?
- A: Materialized View
- B: Dynamic View
- C: Static View
- D: Complex View
View Answer
C
Q642: Which SQL command is used to create a new view?
- A: CREATE TABLE
- B: CREATE VIEW
- C: CREATE INDEX
- D: CREATE FUNCTION
View Answer
B
Q643: The leaf layer of a nonclustered index contains _______.
- A: Actual data records
- B: The clustered index key values
- C: Index rows with row locators
- D: Full data blocks
View Answer
C
Q644: In which type of index are index records created only for some of the records?
- A: Dense Index
- B: Sparse Index
- C: Composite Index
- D: Clustered Index
View Answer
B
Q645: Updating a view that contains computed attributes _______.
- A: Is straightforward and always successful
- B: Is restricted and requires additional care
- C: Will always succeed without issues
- D: Is not possible
View Answer
B
Q646: Which SQL command is used to drop a view?
- A: DROP TABLE
- B: DROP INDEX
- C: DROP VIEW
- D: DROP FUNCTION
View Answer
C
Q647: What is a characteristic of a simple view?
- A: It contains computed attributes
- B: It is a replica of a master table
- C: It is created from one or more tables
- D: It is automatically updated
View Answer
D
Q648: Views can be created using _______.
- A: Functions and other views
- B: Only tables
- C: Only indexes
- D: Only one type of SQL command
View Answer
A
Q649: Which type of index is usually used to improve the performance of range queries?
- A: Non-clustered Index
- B: Clustered Index
- C: Sparse Index
- D: Dense Index
View Answer
B
Q650: When creating a view using a function, the function must be _______.
- A: Static and unchangeable
- B: Dynamic and frequently updated
- C: Referenced in the SELECT clause
- D: Defined in a separate view
View Answer
C