Database Keys MCQs with Answers

Past Paper MCQ

A numeric key is typically considered as which type of key in database management?

• A.Candidate key
• B.Foreign key
• C.Composite key
• D.Primary key

In database management, what defines a composite key?

• A.A key that uniquely identifies a record and is chosen as the primary key
• B.A candidate key that consists of two or more attributes
• C.A foreign key that references multiple tables
• D.A key that contains only one attribute but has unique values

Which type of key in a relational database is not required to be unique for each record?

• A.Primary key
• B.Candidate key
• C.Foreign key
• D.Alternate key

How do tables in a relational database relate to each other?

• A.Through row numbers
• B.Through table names
• C.Through special key fields
• D.Through column headers

Past Paper MCQ

Foreign key:

• A.Column that uniquely identifies each row in its own table
• B.Column linking primary key of another table
• C.Column that can contain only numeric values
• D.Column that must be indexed automatically

Past Paper MCQ

Primary key:

• A.Can be null
• B.Cannot be duplicated
• C.Uniquely identifies a record
• D.All of these

Past Paper MCQ

Foreign key is?

• A.A field in one table that refers to the primary key of another table
• B.A unique identifier for each record in a table
• C.A key that can contain duplicate values
• D.A combination of multiple columns to uniquely identify a record

Past Paper MCQ

MS Access has primary _ keys

• A.1
• B.2
• C.3
• D.None of these

Past Paper MCQ

Functional dependencies in databases are constraints based on what element?

• A.Key
• B.Tuple
• C.Attribute
• D.Relation

Which key is used to uniquely identify each record in a database table?

• A.Foreign key
• B.Candidate key
• C.Primary key
• D.Composite key