MODERN DATABASE MANAGEMENT
COMPREHENSIVE EXAMINATION TEST
VERIFIED QUESTIONS AND CORRECT
ANSWERS PREMIUM REVIEW
●● A key decision in the physical design process is:
Answer: selecting structures.
●● Designing physical files requires ________ of where and when data
are used in various ways.
Answer: descriptions
●● The storage format for each attribute from the logical data model is
chosen to maximize ________ and minimize storage space.
Answer: data integrity
●● Database access frequencies are estimated from:
Answer: transaction volumes.
●● A detailed coding scheme recognized by system software for
representing organizational data is called a(n):
Answer: data type.
, ●● All of the following are objectives when selecting a data type
EXCEPT:
A) represent all possible values.
B) improve data integrity.
C) support all data manipulations.
D) use a lot of storage space
Answer: use a lot of storage space.
●● All of the following are valid datatypes in Oracle 11g EXCEPT:
A) varchar2.
B) boolean.
C) blob.
D) number.
Answer: boolean.
●● The smallest unit of application data recognized by system software
is a:
Answer: field.
●● Which of the following is an objective of selecting a data type?
A) Represent a small number of possible values
B) Maximize storage space
COMPREHENSIVE EXAMINATION TEST
VERIFIED QUESTIONS AND CORRECT
ANSWERS PREMIUM REVIEW
●● A key decision in the physical design process is:
Answer: selecting structures.
●● Designing physical files requires ________ of where and when data
are used in various ways.
Answer: descriptions
●● The storage format for each attribute from the logical data model is
chosen to maximize ________ and minimize storage space.
Answer: data integrity
●● Database access frequencies are estimated from:
Answer: transaction volumes.
●● A detailed coding scheme recognized by system software for
representing organizational data is called a(n):
Answer: data type.
, ●● All of the following are objectives when selecting a data type
EXCEPT:
A) represent all possible values.
B) improve data integrity.
C) support all data manipulations.
D) use a lot of storage space
Answer: use a lot of storage space.
●● All of the following are valid datatypes in Oracle 11g EXCEPT:
A) varchar2.
B) boolean.
C) blob.
D) number.
Answer: boolean.
●● The smallest unit of application data recognized by system software
is a:
Answer: field.
●● Which of the following is an objective of selecting a data type?
A) Represent a small number of possible values
B) Maximize storage space
