Q. What is the disadvantage of cost based optimizers?

View solution

Q. A particular sort order is said to be _________ sort order if it could be useful for a later operation.

View solution

Q. The rule that allows transformation of a logical operation to a physical operation is called

View solution

Q. State true or false: Making multiple copies of the same sub-expressions must be avoided

View solution

Q. Optimizers use __________ to reduce the cost of optimization.

View solution

Q. The join orders where the right operand of each join is in one of the initial relations are called as ________

View solution

Q. Caching and reuse of query plans is called as ________

View solution

Q. What technique is used for the evaluation of a query with a nested sub query?

View solution

Q. The process of replacing a nested query with a query with a join is known as _________

View solution

Q. A view whose contents are computed and stored is called as _______

View solution

Q. The task of keeping a view up to date with the underlying data is called as ________

View solution

Q. What is incremental materialized view maintenance?

View solution

Q. Which of the following is a type of materialized view management?

View solution

Q. What are differentials in view management?

View solution

Q. The sequence of queries that reflect the typical load on the system are known as ________

View solution

Q. The problem of an update affecting the execution of a query associated with the update is known as the _________

View solution

Q. Reducing the complexity of complex queries by similarly handling sub-queries is known as ______

View solution

Q. Which of the following is a multi-query optimization technique

View solution

Q. If a query is optimized without providing specific values for its parameters the technique is called __________

View solution

Q. A collection of data designed to be used by different people is called a/an

View solution