ICT Database Management Concepts 4

Question 1

What is the role of a Database Administrator (DBA)?

Accepted Answer

Designing, maintaining, and securing the database system

Answer

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?

Accepted Answer

One-to-many

Answer

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?

Accepted Answer

A precompiled set of SQL statements stored in the database

Answer

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?

Accepted Answer

Durability

Answer

Durability guarantees that committed transactions are permanently saved even if the system crashes immediately after.

Question 5

What does SQL stand for?

Accepted Answer

Structured Query Language

Answer

SQL stands for Structured Query Language, the standard language for managing and querying relational databases.

ICT - Information Communication Technology Practice Test