Q. Which of the following information does the database system catalog store?

View solution

Q. Most databases store the distribution of values for each attribute as a __________

View solution

Q. What is the function of the equi-width histogram?

View solution

Q. What kind of a sample must be used for statistical analysis?

View solution

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