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 report generated from query results

Answer

A type of database index

Answer

A method for importing CSV files

Question 2

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

Accepted Answer

Durability

Answer

Atomicity

Answer

Consistency

Answer

Isolation

Question 3

What is a foreign key?

Accepted Answer

A column that references the primary key of another table

Answer

A secondary backup of the primary key

Answer

An encrypted field used for authentication

Answer

The first non-null column in a table

Question 4

What does DDL stand for in database terminology?

Accepted Answer

Data Definition Language

Answer

Data Distribution Logic

Answer

Dynamic Data Loading

Answer

Distributed Database Layer

Question 5

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

Accepted Answer

Relational database

Answer

Graph database

Answer

Document database

Answer

Key-value store

Question 6

What is a stored procedure in a DBMS?

Accepted Answer

A precompiled set of SQL statements stored and executed on the database server

Answer

A method to compress database backups

Answer

A tool for importing external data files

Answer

A type of database user account