CSE 511 Week 4 UPDATED ACTUAL
Exam Questions and CORRECT Answers
What is a sharded deployment of a database? - CORRECT ANSWER -Each fragment
resides in one site only
What is the main disadvantage of full replication? - CORRECT ANSWER -The process to
perform a single update is slower since it must be updated on different databases to keep the
copies consistent.
What Rule of Thumb do we use to consider Replication? - CORRECT ANSWER -If read-
only queries / update queries >> 1
How does one create a horizontal fragmentation of a database table? - CORRECT
ANSWER -By placing table records into multiple smaller tables.
Which table key should be copied to each of the subtables created in a vertical fragmentation? -
CORRECT ANSWER -Primary key of a table should be copied to each and every subtable
created in a vertical fragmentation.
Which of the following areas is negatively affected when data is replicated across multiple sites?
- CORRECT ANSWER -Data updates
What is the main objective of distributed query processing? - CORRECT ANSWER -Form
a high level query on a distributed database for optimal execution.
What does a query execution plan impact? - CORRECT ANSWER -Query performance
What cannot be a goal in a query processing? - CORRECT ANSWER -The solution space
for a query is a fixed set of equivalent algebraic expressions; it cannot be maximized.
Exam Questions and CORRECT Answers
What is a sharded deployment of a database? - CORRECT ANSWER -Each fragment
resides in one site only
What is the main disadvantage of full replication? - CORRECT ANSWER -The process to
perform a single update is slower since it must be updated on different databases to keep the
copies consistent.
What Rule of Thumb do we use to consider Replication? - CORRECT ANSWER -If read-
only queries / update queries >> 1
How does one create a horizontal fragmentation of a database table? - CORRECT
ANSWER -By placing table records into multiple smaller tables.
Which table key should be copied to each of the subtables created in a vertical fragmentation? -
CORRECT ANSWER -Primary key of a table should be copied to each and every subtable
created in a vertical fragmentation.
Which of the following areas is negatively affected when data is replicated across multiple sites?
- CORRECT ANSWER -Data updates
What is the main objective of distributed query processing? - CORRECT ANSWER -Form
a high level query on a distributed database for optimal execution.
What does a query execution plan impact? - CORRECT ANSWER -Query performance
What cannot be a goal in a query processing? - CORRECT ANSWER -The solution space
for a query is a fixed set of equivalent algebraic expressions; it cannot be maximized.
