1Z0-006 Database Concepts & Terminology 2

Question 1

Which term describes the complete set of data values that an attribute can legally hold?

Accepted Answer

Domain

Answer

A domain defines the set of permissible values for an attribute, such as integers between 1 and 100 or valid date values.

Question 2

In relational database terminology, a row in a table is also called a:

Accepted Answer

Tuple

Answer

A tuple is the formal relational term for a single row or record within a relation (table).

Question 3

What is a 'schema' in the context of a relational database?

Accepted Answer

The structural definition of the database including tables and relationships

Answer

A schema is the logical structure or blueprint of the database, defining tables, columns, data types, and constraints without reference to actual data values.

Question 4

Which concept ensures that every row in a table can be uniquely identified?

Accepted Answer

Primary key

Answer

A primary key is a column or combination of columns whose values uniquely identify each row in a table and cannot be NULL.

Question 5

A foreign key in a relational database is used to:

Accepted Answer

Establish a link between data in two tables

Answer

A foreign key creates a referential link between a column in one table and the primary key of another table, enforcing referential integrity.

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

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

1Z0-006 Database Concepts & Terminology 2