CCP Relational & NoSQL Database Design 2

Question 1

Which normal form eliminates transitive dependencies among non-key attributes?

Accepted Answer

Third Normal Form (3NF)

Answer

3NF removes transitive dependencies where a non-key column depends on another non-key column rather than directly on the primary key.

Question 2

In a relational schema, a foreign key constraint ensures which property?

Accepted Answer

Referential integrity

Answer

A foreign key constraint enforces referential integrity by ensuring that a value in one table corresponds to an existing value in the referenced table.

Question 3

Which NoSQL data model stores data as key-value pairs with no fixed schema?

Accepted Answer

Key-value store

Answer

Key-value stores use a simple hash-map structure where each unique key maps to a value, requiring no predefined schema.

Question 4

What does the CAP theorem state about distributed databases?

Accepted Answer

A system can guarantee at most two of Consistency, Availability, and Partition tolerance

Answer

The CAP theorem states that a distributed system can only guarantee two of the three properties: Consistency, Availability, and Partition tolerance.

Question 5

Which join type returns all rows from both tables, filling NULL where no match exists?

Accepted Answer

FULL OUTER JOIN

Answer

A FULL OUTER JOIN returns all rows from both tables, placing NULL in columns where a matching row from the other table does not exist.

(CCP) Certified Computing Professional Practice Test

(CCP) Certified Computing Professional Practice Test

CCP Relational & NoSQL Database Design 2