Question 1

A(n)________ is a routine that converts a primary key value into a relative record number.

Accepted Answer

A)  record index calculator 
B)  index pointer program 
C)  hashing algorithm 
D)  pointing algorithm 
A)  record index calculator 
B)  index pointer program 
C)  hashing algorithm 
D)  pointing algorithm

Question 2

Within Oracle,the named set of storage elements in which physical files for database tables may be stored is called a(n):

Accepted Answer

A)  extent. 
B)  table. 
C)  tablespace. 
D)  partition. 
A)  extent. 
B)  table. 
C)  tablespace. 
D)  partition.

Question 3

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

Accepted Answer

A) True 
 B)False

Question 4

What is clustering?

Accepted Answer

Clustering is a technique used in some d

Question 5

In a sequential file,the records are stored in sequence according to primary key.

Accepted Answer

A) True 
 B)False

A(n)________ is a routine that converts a primary key value into a relative record number.

Within Oracle,the named set of storage elements in which physical files for database tables may be stored is called a(n):

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

What is clustering?

In a sequential file,the records are stored in sequence according to primary key.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 5: Physical Database Design and Performance

A(n)________ is a routine that converts a primary key value into a relative record number.

Within Oracle,the named set of storage elements in which physical files for database tables may be stored is called a(n):

A key is a data structure used to determine the location of rows in a file that satisfy some condition.

What is clustering?

In a sequential file,the records are stored in sequence according to primary key.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters