Similar Collections

.

questions

Title
A particular sort order is said to be _________ sort order if it could be useful for a later operation
The rule that allows transformation of a logical operation to a physical operation is called
State true or false: Making multiple copies of the same sub-expressions must be avoided
Optimizers use __________ to reduce the cost of optimization
The join orders where the right operand of each join is in one of the initial relations are called as ________
Caching and reuse of query plans is called as ________
What technique is used for the evaluation of a query with a nested sub query?
The process of replacing a nested query with a query with a join is known as _________
A view whose contents are computed and stored is called as _______
The task of keeping a view up to date with the underlying data is called as ________
What is incremental materialized view maintenance?
Which of the following is a type of materialized view management?
What are differentials in view management?
The sequence of queries that reflect the typical load on the system are known as ________
The problem of an update affecting the execution of a query associated with the update is known as the _________
Reducing the complexity of complex queries by similarly handling sub-queries is known as ______
Which of the following is a multi-query optimization technique
If a query is optimized without providing specific values for its parameters the technique is called __________
A collection of data designed to be used by different people is called a/an
Which of the following schemas does define a view or views of the database for particular users?
total questions: 204

Questions

204

Views

1529

Best Answers

299

Points

5