FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Physical Database Design and Performance

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Distributing the rows of data into separate files is called:

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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Vertical p...

View Answer

Show Answer

Question 33

Essay

Review LaterAdd Note

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

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

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

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

Reduced uptime is a disadvantage of partitioning.

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.

Database access frequencies are estimated from:

Which type of file is most efficient with storage space?

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

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

Why would you want to override automatic query optimization?

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

In which data model would a code table appear?

A file organization is a named portion of primary memory.

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

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

Discuss how data integrity can be controlled.

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