BCS Database Management Systems

Question 1

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Accuracy, Completeness, Integrity, Dependability

Answer

Atomicity, Completeness, Isolation, Distribution

Answer

Access, Control, Integrity, Data

Question 2

What is a primary key in a relational database?

Accepted Answer

A unique identifier for each row in a table that cannot be NULL

Answer

The first column in a table

Answer

A foreign key reference to another table

Answer

An index on the most frequently queried column

Question 3

Which SQL command is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 4

What is the purpose of normalization in database design?

Accepted Answer

To reduce data redundancy and improve data integrity

Answer

To increase query execution speed

Answer

To encrypt sensitive data fields

Answer

To partition data across multiple servers

Question 5

What is a foreign key constraint?

Accepted Answer

A column that references the primary key of another table, enforcing referential integrity

Answer

A key that locks a table from modifications

Answer

An index on a non-primary column

Answer

A key used for encryption

Question 6

Which normal form eliminates partial dependencies on composite primary keys?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)