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

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

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

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

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

Database access frequencies are estimated from:

Why would you want to override automatic query optimization?

Which type of file is most efficient with storage space?

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

Reduced uptime is a disadvantage of partitioning.

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

Discuss how data integrity can be controlled.

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

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

Distributing the rows of data into separate files is called:

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

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

In which data model would a code table appear?

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.

A file organization is a named portion of primary memory.