1Z0-006 Database Concepts & Terminology 5

Question 1

Which term describes the process of organizing database tables to reduce data redundancy and improve data integrity?

Accepted Answer

Normalization

Answer

Normalization is the process of structuring a relational database according to normal forms (1NF, 2NF, 3NF, etc.) to eliminate redundancy and dependency anomalies.

Question 2

In Oracle Database, what is a 'tablespace'?

Accepted Answer

A logical storage container that groups related data files

Answer

A tablespace is the logical unit of Oracle database storage that groups one or more physical data files, and all database objects belong to a tablespace.

Question 3

What does 'atomicity' mean in the context of ACID database properties?

Accepted Answer

All operations in a transaction either complete fully or are entirely rolled back

Answer

Atomicity guarantees that a transaction is treated as a single indivisible unit—if any part fails, all changes made by the transaction are rolled back entirely.

Question 4

Which of the following best describes a 'data dictionary' or 'system catalog' in a DBMS?

Accepted Answer

A repository of metadata that describes the structure and organization of the database

Answer

The data dictionary (system catalog) is a set of system tables and views that store metadata about all database objects, such as table definitions, column data types, and constraints.

Question 5

What is a 'surrogate key'?

Accepted Answer

A system-generated unique identifier with no business meaning used as a primary key

Answer

A surrogate key is an artificially created unique identifier (often an auto-incremented number) that has no intrinsic business meaning but serves as the primary key.

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

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

1Z0-006 Database Concepts & Terminology 5