Q. The ________ SQL command generates statistics on a particular relation

View solution

Q. The union of all records satisfying the individual simple conditions Oi is called as ________

View solution

Q. The intersection of all records satisfying the individual simple conditions Oi is called as ________

View solution

Q. State true or false: Estimation of the size of the result of a join is not possible

View solution

Q. Size estimation can be done for which of the following processes?

View solution

Q. The size of a _____ is simply V(A,r) where r is the relation and A is a distinct value

View solution

Q. A ________ explores the space of all query evaluation plans that are equivalent to a given query.

View solution

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