ICT Database Management Concepts 4 — Questions and Answers
Question 1: What is the role of a Database Administrator (DBA)?
- Writing front-end user interfaces
- Designing, maintaining, and securing the database system (Correct answer)
- Developing mobile applications
- Managing network hardware infrastructure
Correct answer: Designing, maintaining, and securing the database system
A DBA is responsible for installing, configuring, upgrading, monitoring, and securing database systems.
Question 2: Which type of relationship in an ER diagram means one record in Table A can relate to many records in Table B?
- One-to-one
- Many-to-many
- One-to-many (Correct answer)
- Zero-to-many
Correct answer: One-to-many
A one-to-many relationship means a single record in one table can be associated with multiple records in another table.
Question 3: What is a stored procedure in a database?
- A temporary table created during a query
- A precompiled set of SQL statements stored in the database (Correct answer)
- A log file of executed queries
- A type of database index
Correct answer: A precompiled set of SQL statements stored in the database
A stored procedure is a prepared SQL code saved in the database that can be reused by calling it by name.
Question 4: Which property of a transaction ensures that once committed, changes survive system failures?
- Atomicity
- Consistency
- Isolation
- Durability (Correct answer)
Correct answer: Durability
Durability guarantees that committed transactions are permanently saved even if the system crashes immediately after.
Question 5: What does SQL stand for?
- Structured Query Language (Correct answer)
- Sequential Query Logic
- System Query Layer
- Standard Query Link
Correct answer: Structured Query Language
SQL stands for Structured Query Language, the standard language for managing and querying relational databases.
Question 6: In database design, what is an entity?
- A relationship between two tables
- A real-world object or concept represented in the database (Correct answer)
- A column with a unique constraint
- A type of database index
Correct answer: A real-world object or concept represented in the database
An entity is any real-world object, person, place, or concept about which data is stored in the database.
Question 7: What is the purpose of the ROLLBACK statement in SQL?
- To permanently save all changes made during a transaction
- To undo all changes made during the current transaction (Correct answer)
- To delete a table from the database
- To reset auto-increment counters
Correct answer: To undo all changes made during the current transaction
ROLLBACK reverts all changes made within the current transaction, restoring the database to its previous state.
ICT Database Management Concepts 4
What is the role of a Database Administrator (DBA)?