Q. Which of the following operations are associative

View solution

Q. Which of the following set operations is not commutative?

View solution

Q. State true or false: The projection operation does not distribute over the union operation

View solution

Q. If no rule can be derived from any combination of others then the set of rules is said to be ________

View solution

Q. Theta join operations are

View solution

Q. Which of the following operations is associative

View solution

Q. Which of the following set operations does the selection operation distribute over?

View solution

Q. State true or false: Multiple equivalence rules can be used one after the other on a query

View solution

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