1Z0-006 Fundamental Database Concepts Questions and Answers

Question 1

Which of the following BEST describes the primary purpose of the relational model in database design?

Accepted Answer

To define relationships between data points using tables, rows, and columns, ensuring data consistency.

Answer

To store data in a hierarchical structure, similar to a file system.

Answer

To create a flexible schema that allows for storing unstructured data like documents and media files.

Answer

To manage physical data storage directly, optimizing for hardware performance.

Question 2

A database administrator is designing a table to store employee information, including their skills. To avoid data redundancy, they decide to create a separate 'Skills' table and a 'Employee_Skills' table to link employees to their skills. This process is an example of what fundamental database concept?

Accepted Answer

Normalization

Answer

Data Encryption

Answer

Transaction Control

Answer

Data Warehousing

Question 3

In an Oracle database, which of the following are considered schema objects?

Accepted Answer

Tables, Views, Indexes, and Sequences

Answer

Users, Roles, and Profiles

Answer

Tablespaces, Datafiles, and Control Files

Answer

The System Global Area (SGA) and Program Global Area (PGA)

Question 4

What is the key difference between Data Definition Language (DDL) and Data Manipulation Language (DML)?

Accepted Answer

DDL defines and manages the structure of database objects, while DML is used to add, modify, or delete the data within those objects.

Answer

DDL commands are used to query data, while DML commands are used to grant user permissions.

Answer

DDL commands like COMMIT and ROLLBACK manage transactions, while DML commands create tables and indexes.

Answer

DDL is used for creating reports, while DML is used for database backup and recovery.

Question 5

A developer needs to create a table to store customer orders. Each order must have a unique identifier. Which of the following constraints is MOST appropriate for the 'OrderID' column to ensure each row can be uniquely identified?

Accepted Answer

PRIMARY KEY

Answer

FOREIGN KEY

Answer

CHECK

Answer

NOT NULL

Question 6

An Entity-Relationship Diagram (ERD) is used during the database design phase. What does a rectangle typically represent in an ERD?

Accepted Answer

An entity, such as a person, place, or object, about which data is stored

Answer

A relationship between two pieces of data

Answer

An attribute or property of an object

Answer

An action or process performed by the database