Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 39
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
Correct Answer:
C
Chapter: 39
Q642:
Which SQL command is used to create a new view?
A. CREATE TABLE
B. CREATE VIEW
C. CREATE INDEX
D. CREATE FUNCTION
Correct Answer:
B
Chapter: 39
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
Correct Answer:
C
Chapter: 40
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
Correct Answer:
B
Chapter: 40
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
Correct Answer:
B
Chapter: 40
Q646:
Which SQL command is used to drop a view?
A. DROP TABLE
B. DROP INDEX
C. DROP VIEW
D. DROP FUNCTION
Correct Answer:
C
Chapter: 40
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
Correct Answer:
D
Chapter: 40
Q648:
Views can be created using _______.
A. Functions and other views
B. Only tables
C. Only indexes
D. Only one type of SQL command
Correct Answer:
A
Chapter: 40
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
Correct Answer:
B
Chapter: 40
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
Correct Answer:
C
Chapter: 40
Q651:
To create a view that filters records from a table, you use _______. The ORDER BY clause
A. Aggregation functions
B. The WHERE clause
C. A JOIN operation
Correct Answer:
C
Chapter: 40
Q652:
A materialized view is updated through _______.
A. Batch updates from multiple master sites
B. Continuous updates from other master sites
C. Real-time updates only
D. Manual refresh only
Correct Answer:
A
Chapter: 40
Q653:
In the context of views, the term "nesting" refers to _______.
A. Creating a view within another view
B. Updating a view on a periodic basis
C. Creating multiple views at once
D. Deleting a view
Correct Answer:
A
Chapter: 41
Q654:
What is a materialized view primarily used for?
A. To summarize, compute, replicate, and distribute data
B. To replace indexes
C. To create new tables
D. To update data in real-time
Correct Answer:
A
Chapter: 41
Q655:
Which SQL command is used to create a materialized view?
A. CREATE MATERIALIZED VIEW
B. CREATE VIEW
C. CREATE TABLE
D. CREATE INDEX
Correct Answer:
A
Chapter: 41
Q656:
A transaction in a database must ensure _______.
A. Atomicity, Consistency, Isolation, Durability
B. Speed, Efficiency, Scalability, Simplicity
C. Availability, Redundancy, Integrity, Security
D. Complexity, Flexibility, Performance, Scalability
Correct Answer:
A
Chapter: 41
Q657:
In which scenario are materialized views especially useful?
A. For complex queries with large joins and aggregates
B. For simple data retrieval operations
C. For quick updates to a base table
D. For dynamic view generation
Correct Answer:
A
Chapter: 41
Q658:
The property of a transaction that ensures all steps are completed or none at all is known as _______.
A. Consistency
B. Isolation
C. Atomicity
D. Durability
Correct Answer:
C
Chapter: 41
Q659:
Which of the following is NOT a characteristic of a materialized view?
A. It improves SQL execution performance
B. It is updated when the master table changes
C. It is transparent to SQL applications
D. It can be used to create indexes
Correct Answer:
D
Chapter: 41
Q660:
In the context of transactions, "atomicity" refers to _______.
A. The indivisibility of operations within a transaction
B. The ability to handle multiple transactions simultaneously
C. The ability to restore data to its original state
D. The ability to update data without locking
Correct Answer:
A