Data Processing Database Management Systems 2

Question 1

What is a transaction in database processing?

Accepted Answer

A unit of work that is executed completely or not at all

Answer

A database transaction is a sequence of operations treated as a single logical unit of work that must be fully completed or fully rolled back.

Question 2

Which ACID property ensures that a committed transaction remains saved even after a system failure?

Accepted Answer

Durability

Answer

Durability guarantees that once a transaction is committed, the changes are permanently recorded and will survive system crashes or failures.

Question 3

What is a foreign key?

Accepted Answer

A column that references the primary key of another table

Answer

A foreign key is a field in one table that references the primary key in another table, establishing a link between the two tables.

Question 4

What does DDL stand for in database terminology?

Accepted Answer

Data Definition Language

Answer

DDL stands for Data Definition Language, which includes SQL commands like CREATE, ALTER, and DROP that define database structure.

Question 5

Which type of database stores data in tables with rows and columns?

Accepted Answer

Relational database

Answer

A relational database organizes data into structured tables consisting of rows (records) and columns (attributes), linked by relationships.

Data Processing Practice Test