Fundamentals of Database

Which of the following is NOT a function of a Database Management System (DBMS)?

• Data storage and retrieval

• Data backup and recovery

• Program compilation and execution

• Access control for users

Which of the following ensures that data in the database remains accurate and consistent?

• Data manipulation

• Data integrity

• Data definition

• Data security

Which of the following is a property of a transaction that ensures the database remains in a consistent state?

• Atomicity

• Scalability

• Concurrency

• Redundancy

What is the primary goal of concurrency control in a DBMS?

• Ensuring data is stored efficiently

• Preventing deadlocks between transactions

• Ensuring data consistency when multiple transactions are executed concurrently

• Managing disk space in the database

The process of organizing data to minimize redundancy and improve efficiency is called:

• Indexing

• Normalization

• Denormalization

• Fragmentation

A foreign key in one table is used to:

• Uniquely identify records within the same table

• Link to the primary key of another table

• Ensure that the table has no null values

• Serve as a primary key for multiple tables

Which of the following best describes a candidate key?

• A key that is always used as a foreign key in another table

• A key that can uniquely identify a record but is not chosen as the primary key

• A key that must consist of only one column

• A key that is shared between two or more tables

What is the primary difference between a candidate key and a primary key?

• Candidate keys can have duplicate values, while primary keys cannot

• A table can have multiple candidate keys, but only one primary key

• Primary keys allow null values, while candidate keys do not

• Candidate keys are used to establish relationships between tables

What does the "ACID" property of a relational database transaction stand for?

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

• Atomicity, Completeness, Integrity, Durability

• Accuracy, Concurrency, Integrity, Durability

What is a functional dependency in a relational database?

• A relationship between two tables based on a foreign key

• A constraint between two attributes such that one uniquely determines the other

• A rule that defines how data is inserted into a table

• A method to optimize database performance