1Z0-006 Fundamental Database Concepts 2

Question 1

Which type of relationship exists when one record in Table A can relate to many records in Table B, and one record in Table B can relate to many records in Table A?

Accepted Answer

Many-to-Many

Answer

A many-to-many relationship means each row on either side can relate to multiple rows on the other side, typically resolved with a junction (bridge) table.

Question 2

In the context of database transactions, what does the 'I' in ACID stand for?

Accepted Answer

Isolation

Answer

Isolation ensures that concurrent transactions execute as if they were run sequentially, preventing interference between them.

Question 3

Which SQL command is used to permanently save changes made during a transaction?

Accepted Answer

COMMIT

Answer

COMMIT permanently saves all changes made during the current transaction to the database.

Question 4

What is a surrogate key?

Accepted Answer

A system-generated artificial key with no business meaning

Answer

A surrogate key is an artificially generated identifier (often a sequence number) with no inherent business meaning, used purely to uniquely identify rows.

Question 5

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

Accepted Answer

Third Normal Form (3NF)

Answer

Third Normal Form (3NF) requires that no non-key attribute is transitively dependent on the primary key through another non-key attribute.

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

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

1Z0-006 Fundamental Database Concepts 2