Database Management Systems MCQs (Set-4)

What is a database index?

A A duplicate table copy always
B A transaction rollback log
C A foreign key constraint
D Structure that speeds data lookup

What structure commonly supports ordered range lookup?

A Hash bucket
B B tree
C Stack
D Bloom filter only

What is a common B plus tree property?

A All values stored at root
B No internal index keys
C Leaves have no ordering
D Records referenced at linked leaves

What does a clustered index influence?

A Physical row organization
B SQL language syntax
C Transaction isolation level
D User permissions

What does a nonclustered index store?

A Search keys with row references
B Only complete database backups
C Query text and results
D Transaction locks only

What can a composite index accelerate?

A Any query on any column
B Only table creation
C Queries on indexed column sequence
D Every full table scan

Why does composite index column order matter?

A Column names must be unique
B Leading columns guide lookup
C The index stores no values
D Rows cannot contain nulls

What is a hash index best suited for?

A Ordered range scans
B Equality lookup
C Sorting entire tables
D Prefix matching on all keys

What does index selectivity describe?

A Index file name
B Number of table columns
C Query output order
D Distinctness of indexed values

What is a query execution plan?

A Database user list
B Table definition only
C Chosen operations to run query
D A backup schedule

What does a query optimizer choose?

A Efficient execution plan
B Database password
C Table schema name
D Transaction commit value

What does EXPLAIN commonly show?

A Query plan information
B All database passwords
C Only table contents
D Committed transaction log

What is a covering index?

A Index stores no key
B Index covers every table
C Index contains query's needed data
D Index prevents all table updates

What is a tradeoff of adding indexes?

A Slower every read
B More storage and write work
C No additional storage
D Automatic schema normalization

What is a materialized view?

A Virtual query with no storage
B Stored result of a query
C An ordinary index only
D A table with no columns

What is a database trigger?

A A query execution plan
B Code activated by database event
C An index key
D A primary key alias

What is a stored procedure?

A A physical table copy
B A query result cache only
C Saved executable database routine
D A foreign key constraint

What is a transaction log used for?

A Record changes for recovery
B Store only user passwords
C Sort query outputs
D Define a database schema

What does write ahead logging require?

A Write pages before logging
B Delete logs after every query
C Keep no recovery information
D Log changes before data pages

What does a checkpoint help recovery do?

A Remove every index
B Prevent transactions
C Limit log replay work
D Reorder all tables

What do undo and redo support?

A Transaction recovery
B Query parsing
C Index selection
D Schema normalization

What is database replication?

A Partition by row range
B Convert SQL to files
C Maintain copies across nodes
D Sort all records

What is sharding?

A Create multiple indexes only
B Full copy on every node
C Merge tables into a view
D Distribute data across partitions

What is a key value database?

A Store key associated with value
B Store only graph edges
C Store tables with fixed joins
D Store documents as XML only

What is a document database?

A Store only fixed width rows
B Store only graph paths
C Store processor instructions
D Store semi structured documents