ICT - Information Communication Technology Database Management Concepts Questions and Answers

Question 1

A database administrator is designing a relational database and wants to minimize data redundancy and prevent update anomalies.
The process of organizing columns and tables to achieve this is known as:

Accepted Answer

Normalization

Answer

Indexing

Answer

Query Optimization

Answer

Transaction Management

Question 2

In a relational database, which of the following is used to uniquely identify each record in a table and establish a link to data in another table?

Accepted Answer

Primary Key

Answer

Foreign Key

Answer

Composite Key

Answer

Super Key

Question 3

A financial application requires that database transactions are processed reliably. If a multi-step transaction fails midway, all changes made up to that point must be undone to prevent data inconsistency. Which ACID property ensures this 'all-or-nothing' behavior?

Accepted Answer

Atomicity

Answer

Isolation

Answer

Durability

Answer

Consistency

Question 4

A developer needs to add a new table to an existing database schema. Which subset of SQL (Structured Query Language) commands would they use to accomplish this task?

Accepted Answer

Data Definition Language (DDL)

Answer

Data Manipulation Language (DML)

Answer

Data Control Language (DCL)

Answer

Transaction Control Language (TCL)

Question 5

A company is developing a new social media platform that needs to handle massive amounts of unstructured data, such as user posts, images, and videos. The priority is high availability and horizontal scalability. Which type of database model would be MOST suitable for this scenario?

Accepted Answer

NoSQL

Answer

Relational (SQL)

Answer

Hierarchical

Answer

Object-Oriented

Question 6

To improve the performance of data retrieval operations, a database administrator creates a special lookup table that the database search engine can use to speed up queries. This data structure maps column values to the physical location of the corresponding data rows. What is this structure called?

Accepted Answer

Index

Answer

View

Answer

Trigger

Answer

Stored Procedure