NEW
Font size
WorksheetsDatabase Concepts Quiz
Total questions: 15
Worksheet time: 5mins
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
Which of the following is NOT a feature of a primary key?
Uniqueness
Allowing null values
Identifying records
Being a candidate key
What is the purpose of the 'Check' constraint?
To enforce a condition on a column's values
To prevent null values
To define a foreign key
None of the above
What is a foreign key?
A unique identifier for a table
A primary key in another table
An attribute that is always null
None of the above
What type of relationship involves three entities?
Binary Relationship
Unary Relationship
Ternary Relationship
None of the above
Which of the following is NOT a relationship type?
One-to-Many
Many-to-One
None-to-Many
Many-to-Many
