Database Management Systems MCQs (Set-1)

What is the main role of a DBMS?

A Compile source code
B Route network packets
C Control processor clocks
D Manage and access data

In a relational database, what is a relation?

A Row
B Column
C Table
D Index page

What is a tuple in a relation?

A Column
B Database schema
C Query plan
D Row

What is an attribute in a relation?

A Column
B Row
C Transaction log
D Database user

What does a database schema describe?

A Current row values only
B Structure of the database
C Query execution time
D Backup location only

What is a database instance?

A Table structure definition
B Current stored data
C SQL language standard
D Database engine source

What must a primary key provide?

A Duplicate nullable values
B Sorted insertion order
C A default value always
D Unique nonnull row identity

What is a candidate key?

A Minimal unique attribute set
B Any nonunique column
C A foreign key only
D A table name alias

What is an alternate key?

A Candidate key not selected primary
B Foreign key referencing itself
C A key with duplicate values
D A database backup key

What does a foreign key reference?

A A query parameter
B A database file name
C A nonunique comment
D Referenced table key

What is a composite key?

A Key with duplicate values
B External database key
C Key that cannot identify rows
D Key made from multiple attributes

What does entity integrity require?

A Primary key values are nonnull
B All columns are unique
C Every table has a timestamp
D Foreign keys are sorted

What does referential integrity protect?

A Unique query results
B Valid foreign key references
C Sorted table storage
D Column data types only

What is a domain constraint?

A Allowed values for an attribute
B Schema table count
C Order of rows on disk
D A required index type

What does an ER diagram model?

A Query execution steps
B Disk blocks and indexes
C Program classes only
D Entities and relationships

What does one to many cardinality mean?

A One relates to many
B Every row relates to itself
C Many tables share one schema
D One column, many types

What does relational algebra selection do?

A Chooses columns
B Combines tables by keys
C Filters rows by condition
D Renames a relation

What does relational algebra projection do?

A Filters rows by condition
B Joins two tables
C Chooses columns
D Sorts tuples

What does a Cartesian product form?

A Only matching key rows
B All row pairs across relations
C Unique rows from both tables
D Rows meeting a filter

What does relational algebra rename change?

A Relation or attribute name
B Tuple values
C Column data types
D Database permissions

When can relational UNION combine two relations?

A They share a primary key
B They have compatible attributes
C Same number of rows
D They use identical indexes

What does relational difference return?

A Rows in both relations
B All row pairs
C Rows in first relation only
D Columns from first relation

What does database metadata describe?

A Only end user values
B Only transaction results
C Data structure and definitions
D Network cable status

What does physical data independence allow?

A Table change, same applications
B Storage change, same schema
C Queries without tables
D Users to bypass permissions

What is a database view?

A Physical copy of every database
B A primary key index
C Named query as table
D Transaction lock only