Data Processing Database Management Systems 2 — Questions and Answers
Question 1: What is a transaction in database processing?
- A unit of work that is executed completely or not at all (Correct answer)
- A report generated from query results
- A type of database index
- A method for importing CSV files
Correct answer: A unit of work that is executed completely or not at all
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?
- Durability (Correct answer)
- Atomicity
- Consistency
- Isolation
Correct answer: Durability
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?
- A column that references the primary key of another table (Correct answer)
- A secondary backup of the primary key
- An encrypted field used for authentication
- The first non-null column in a table
Correct answer: A column that references the primary key of another table
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?
- Data Definition Language (Correct answer)
- Data Distribution Logic
- Dynamic Data Loading
- Distributed Database Layer
Correct answer: Data Definition Language
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?
- Relational database (Correct answer)
- Graph database
- Document database
- Key-value store
Correct answer: Relational database
A relational database organizes data into structured tables consisting of rows (records) and columns (attributes), linked by relationships.
Question 6: What is a stored procedure in a DBMS?
- A precompiled set of SQL statements stored and executed on the database server (Correct answer)
- A method to compress database backups
- A tool for importing external data files
- A type of database user account
Correct answer: A precompiled set of SQL statements stored and executed on the database server
A stored procedure is a precompiled collection of SQL statements saved in the database that can be executed repeatedly by calling its name.
Data Processing Database Management Systems 2
What is a transaction in database processing?