MODERN DATABASE MANAGEMENT EXAM
SCRIPT 2026 EXAMPREP TESTED QUESTIONS
ANSWERS FULL SOLUTION GRADED A+
◉ An integrity control supported by a DBMS is:
Answer: range control.
◉ The value a field will assume unless the user enters an explicit
value for an instance of that field is called a(n):
Answer: default value.
◉ A method for handling missing data is to:
Answer: substitute and estimate for the missing data.
track missing data with special reports.
perform sensitivity testing.
◉ Sensitivity testing involves:
Answer: checking to see if missing data will greatly impact results.
◉ Common denormalization opportunities
Answer: two entities with a one-to-one relationship.
, a many-to-many relationship with nonkey attributes.
reference data.
◉ In most cases the goal of ________ dominates the design process.
Answer: efficient data processing
◉ Distributing the rows of data into separate files is called:
Answer: horizontal partitioning.
◉ Horizontal partitioning makes sense:
Answer: when different categories of a table's rows are processed
separately.
◉ An advantage of partitioning is:
Answer: efficiency.
◉ A disadvantage of partitioning is:
Answer: extra space and update time.
◉ Horizontal partitioning methods in Oracle
Answer: Key range partitioning
Hash partitioning
SCRIPT 2026 EXAMPREP TESTED QUESTIONS
ANSWERS FULL SOLUTION GRADED A+
◉ An integrity control supported by a DBMS is:
Answer: range control.
◉ The value a field will assume unless the user enters an explicit
value for an instance of that field is called a(n):
Answer: default value.
◉ A method for handling missing data is to:
Answer: substitute and estimate for the missing data.
track missing data with special reports.
perform sensitivity testing.
◉ Sensitivity testing involves:
Answer: checking to see if missing data will greatly impact results.
◉ Common denormalization opportunities
Answer: two entities with a one-to-one relationship.
, a many-to-many relationship with nonkey attributes.
reference data.
◉ In most cases the goal of ________ dominates the design process.
Answer: efficient data processing
◉ Distributing the rows of data into separate files is called:
Answer: horizontal partitioning.
◉ Horizontal partitioning makes sense:
Answer: when different categories of a table's rows are processed
separately.
◉ An advantage of partitioning is:
Answer: efficiency.
◉ A disadvantage of partitioning is:
Answer: extra space and update time.
◉ Horizontal partitioning methods in Oracle
Answer: Key range partitioning
Hash partitioning
