Database Concepts Quiz

What is a Database?

• A collection of related data

• A collection of random data

• A hardware component

• None of the above

What does DBMS stand for?

• Database Maintenance Software

• Database Management System

• Data Backup Management Software

• None of the above

Which of the following is NOT a type of database testing?

• Structural Database Testing

• Functional Database Testing

• Non-functional Testing

• Operational Database Testing

What is the purpose of an Entity Relationship Diagram (ERD)?

• To write SQL queries

• To display entities and their relationships

• To manage databases

• None of the above

What is a Candidate Key?

• An attribute that is a foreign key

• A unique identifier for each entity

• An attribute that is always null

• None of the above

Which entity has a unique identifier?

• Weak Entity

• Strong Entity

• Both

• None

What is the cardinality of a relationship?

• The minimum number of relationships

• The maximum number of relationships

• The degree of the relationship

• None of the above

What is the purpose of a primary key in a table?

• To allow null values

• To uniquely identify records

• To store foreign keys

• None of the above

What is the 'Not Null' constraint used for?

• To enforce unique values

• To ensure a field always has a value

• To allow duplicate values

• None of the above

What is a composite attribute?

• An attribute with multiple values

• An attribute that is derived from others

• An attribute composed of multiple sub-parts

• None of the above