DBMS Quiz – Questions With Accurate Answers (Pass!)
A requirement to begin designing physical files and databases is:
A) normalized relations.
B) definitions of each attribute.
C) technology descriptions.
D) all of the above. Right Ans - D
A key decision in the physical design process is:
A) knowing the user base.
B) selecting structures.
C) deciding on the monitor.
D) all of the above. Right Ans - B
Designing physical files requires ________ of where and when data are used in
various ways.
A) maps
B) descriptions
C) keys
D) hints Right Ans - B
The storage format for each attribute from the logical data model is chosen to
maximize ________ and minimize storage space.
A) query design
B) programmer productivity
C) data integrity
D) data integration Right Ans - C
Database access frequencies are estimated from:
A) transaction volumes.
B) user logins.
C) security violations.
D) none of the above Right Ans - A
A detailed coding scheme recognized by system software for representing
organizational data is called a(n):
A) DBMS code.
B) data type.
C) SQL.
, D) DB layouts. Right Ans - B
All of the following are valid datatypes in Oracle 11g EXCEPT:
A) varchar2.
B) booolean.
C) blob.
D) number. Right Ans - B
The smallest unit of application data recognized by system software is a:
A) field.
B) row.
C) data type.
D) column. Right Ans - A
Which of the following is an objective of selecting a data type?
A) Represent a small number of possible values
B) Maximize storage space
C) Limit security
D) Improve data integrity Right Ans - D
In which data model would a code table appear?
A) Conceptual
B) Logical
C) Physical
D) Data layout Right Ans - C
An integrity control supported by a DBMS is:
A) substitute estimates.
B) security.
C) range control.
D) GUI guards. Right Ans - C
A method for handling missing data is to:
A) substitute and estimate for the missing data.
B) track missing data with special reports.
C) perform sensitivity testing.
D) all of the above. Right Ans - D
Sensitivity testing involves:
A requirement to begin designing physical files and databases is:
A) normalized relations.
B) definitions of each attribute.
C) technology descriptions.
D) all of the above. Right Ans - D
A key decision in the physical design process is:
A) knowing the user base.
B) selecting structures.
C) deciding on the monitor.
D) all of the above. Right Ans - B
Designing physical files requires ________ of where and when data are used in
various ways.
A) maps
B) descriptions
C) keys
D) hints Right Ans - B
The storage format for each attribute from the logical data model is chosen to
maximize ________ and minimize storage space.
A) query design
B) programmer productivity
C) data integrity
D) data integration Right Ans - C
Database access frequencies are estimated from:
A) transaction volumes.
B) user logins.
C) security violations.
D) none of the above Right Ans - A
A detailed coding scheme recognized by system software for representing
organizational data is called a(n):
A) DBMS code.
B) data type.
C) SQL.
, D) DB layouts. Right Ans - B
All of the following are valid datatypes in Oracle 11g EXCEPT:
A) varchar2.
B) booolean.
C) blob.
D) number. Right Ans - B
The smallest unit of application data recognized by system software is a:
A) field.
B) row.
C) data type.
D) column. Right Ans - A
Which of the following is an objective of selecting a data type?
A) Represent a small number of possible values
B) Maximize storage space
C) Limit security
D) Improve data integrity Right Ans - D
In which data model would a code table appear?
A) Conceptual
B) Logical
C) Physical
D) Data layout Right Ans - C
An integrity control supported by a DBMS is:
A) substitute estimates.
B) security.
C) range control.
D) GUI guards. Right Ans - C
A method for handling missing data is to:
A) substitute and estimate for the missing data.
B) track missing data with special reports.
C) perform sensitivity testing.
D) all of the above. Right Ans - D
Sensitivity testing involves:
