1Z0-006 Database Concepts & Terminology 3

Question 1

What is a 'view' in a relational database?

Accepted Answer

A virtual table based on the result of a stored query

Answer

A view is a virtual table defined by a SELECT query; it does not store data itself but presents data from one or more underlying tables.

Question 2

In database terminology, 'cardinality' of a relationship refers to:

Accepted Answer

The numerical mapping of how many instances of one entity relate to another

Answer

Cardinality describes the numerical relationship between entity instances, such as one-to-one, one-to-many, or many-to-many.

Question 3

Which normal form eliminates partial dependencies on a composite primary key?

Accepted Answer

Second Normal Form (2NF)

Answer

2NF requires that every non-key attribute is fully functionally dependent on the entire primary key, eliminating partial dependencies.

Question 4

What is a 'transaction' in database terms?

Accepted Answer

A logical unit of work containing one or more SQL operations that must complete as a whole

Answer

A transaction is a unit of work that groups one or more DML operations; it either commits all changes or rolls back all changes to maintain database integrity.

Question 5

The 'C' in ACID properties of a database transaction stands for:

Accepted Answer

Consistency

Answer

Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.

(1Z0-006) Oracle Database Foundations Associate Practice Test

(1Z0-006) Oracle Database Foundations Associate Practice Test

1Z0-006 Database Concepts & Terminology 3