Question 1

An extent is a named portion of secondary memory allocated for the purpose of storing physical records.

Accepted Answer

A) True 
 B)False

Question 2

List the seven factors to consider when choosing a file organization for a particular file in a database.

Accepted Answer

The seven factors are:
1.Fast data retri

Question 3

Distributing the rows of data into separate files is called:

Accepted Answer

A)  normalization. 
B)  horizontal partitioning. 
C)  vertical partitioning. 
D)  file allocation. 
A)  normalization. 
B)  horizontal partitioning. 
C)  vertical partitioning. 
D)  file allocation.

Question 4

Vertical partitioning means distributing the columns of a table into several separate physical records.

Accepted Answer

A) True 
 B)False

Question 5

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

Accepted Answer

A) True 
 B)False

Question 6

A file organization is a named portion of primary memory.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is an objective of selecting a data type?

Accepted Answer

A)  Represent a small number of possible values 
B)  Maximize storage space 
C)  Limit security 
D)  Improve data integrity 
A)  Represent a small number of possible values 
B)  Maximize storage space 
C)  Limit security 
D)  Improve data integrity

Question 8

A ________ is a detailed coding scheme recognized by system software,such as a DBMS,for representing organizational data.

Accepted Answer

The answer of A ________ is a detailed coding scheme...

Question 9

Reduced uptime is a disadvantage of partitioning.

Accepted Answer

A) True 
 B)False

Question 10

In which data model would a code table appear?

Accepted Answer

A)  Conceptual 
B)  Logical 
C)  Physical 
D)  Data layout 
A)  Conceptual 
B)  Logical 
C)  Physical 
D)  Data layout

Question 11

Which type of file is most efficient with storage space?

Accepted Answer

A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered 
A)  Sequential 
B)  Hashed 
C)  Indexed 
D)  Clustered

Question 12

________ distributes the columns of a table into several separate physical records.

Accepted Answer

Vertical p

Question 13

All of the following are valid datatypes in Oracle 11g EXCEPT:

Accepted Answer

A)  varchar2. 
B)  booolean. 
C)  blob. 
D)  number. 
A)  varchar2. 
B)  booolean. 
C)  blob. 
D)  number.

Question 14

Why would you want to override automatic query optimization?

Accepted Answer

Sometimes,the query designer may know in

Question 15

Discuss how data integrity can be controlled.

Accepted Answer

In many database management systems,data

Question 16

One objective of selecting a data type is to minimize storage space.

Accepted Answer

A) True 
 B)False

Question 17

The smallest unit of application data recognized by system software is a:

Accepted Answer

A)  field. 
B)  row. 
C)  data type. 
D)  column. 
A)  field. 
B)  row. 
C)  data type. 
D)  column.

Question 18

Database access frequencies are estimated from:

Accepted Answer

A)  transaction volumes. 
B)  user logins. 
C)  security violations. 
D)  none of the above. 
A)  transaction volumes. 
B)  user logins. 
C)  security violations. 
D)  none of the above.

Question 19

Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands,either to qualify the rows to select or for linking.

Accepted Answer

A) True 
 B)False

Question 20

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

Accepted Answer

A) True 
 B)False

An extent is a named portion of secondary memory allocated for the purpose of storing physical records.

List the seven factors to consider when choosing a file organization for a particular file in a database.

Distributing the rows of data into separate files is called:

Vertical partitioning means distributing the columns of a table into several separate physical records.

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

A file organization is a named portion of primary memory.

Which of the following is an objective of selecting a data type?

A ________ is a detailed coding scheme recognized by system software,such as a DBMS,for representing organizational data.

Reduced uptime is a disadvantage of partitioning.

In which data model would a code table appear?

Which type of file is most efficient with storage space?

________ distributes the columns of a table into several separate physical records.

All of the following are valid datatypes in Oracle 11g EXCEPT:

Why would you want to override automatic query optimization?

Discuss how data integrity can be controlled.

One objective of selecting a data type is to minimize storage space.

The smallest unit of application data recognized by system software is a:

Database access frequencies are estimated from:

Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands,either to qualify the rows to select or for linking.

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

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

An extent is a named portion of secondary memory allocated for the purpose of storing physical records.

List the seven factors to consider when choosing a file organization for a particular file in a database.

Distributing the rows of data into separate files is called:

Vertical partitioning means distributing the columns of a table into several separate physical records.

Using an index for attributes referenced in ORDER BY and GROUP BY clauses has no significant impact upon database performance.

A file organization is a named portion of primary memory.

Which of the following is an objective of selecting a data type?

A ________ is a detailed coding scheme recognized by system software,such as a DBMS,for representing organizational data.

Reduced uptime is a disadvantage of partitioning.

In which data model would a code table appear?

Which type of file is most efficient with storage space?

________ distributes the columns of a table into several separate physical records.

All of the following are valid datatypes in Oracle 11g EXCEPT:

Why would you want to override automatic query optimization?

Discuss how data integrity can be controlled.

One objective of selecting a data type is to minimize storage space.

The smallest unit of application data recognized by system software is a:

Database access frequencies are estimated from:

Indexes are most useful for columns that frequently appear in WHERE clauses of SQL commands,either to qualify the rows to select or for linking.

Fast data retrieval is one factor to consider when choosing a file organization for a particular database file.

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