AMCAT - Aspiring Minds Computer Adaptive Computer Science: DBMS Concepts Questions and Answers

Question 1

A database administrator notices that updating a customer's address requires changes in multiple tables, leading to inconsistencies when one of the updates fails.
This is an example of what kind of anomaly?

Accepted Answer

Update Anomaly

Answer

Insertion Anomaly

Answer

Deletion Anomaly

Answer

Selection Anomaly

Question 2

Which of the following SQL JOIN clauses is most appropriate for retrieving all records from the 'Customers' table and only the matching records from the 'Orders' table?

Accepted Answer

LEFT JOIN

Answer

INNER JOIN

Answer

FULL OUTER JOIN

Answer

RIGHT JOIN

Question 3

In the context of the Three-Schema Architecture of a DBMS, which level describes the physical storage structure of the database?

Accepted Answer

Internal Schema

Answer

External Schema

Answer

Conceptual Schema

Answer

Logical Schema

Question 4

Which ACID property ensures that a transaction is either fully completed, or not at all, preventing partial updates to the database?

Accepted Answer

Atomicity

Answer

Durability

Answer

Isolation

Answer

Consistency

Question 5

A table is in First Normal Form (1NF). To achieve Second Normal Form (2NF), what additional condition must be met?

Accepted Answer

It must not have any partial dependencies.

Answer

All attributes must be dependent on the primary key.

Answer

It must not have any transitive dependencies.

Answer

All columns must contain atomic values.

Question 6

Which data structure is most commonly used for database indexing because it stores all data pointers only in leaf nodes, which are linked for efficient sequential access and range queries?

Accepted Answer

B+ Tree

Answer

B-Tree

Answer

AVL Tree

Answer

Red-Black Tree