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

Q. Which of the following schemas does define a view or views of the database for particular users?

View solution

Q. Which of the following is an attribute that can uniquely identify a row in a table?

View solution

Q. Which of the following terms does refer to the correctness and completeness of the data in a database?

View solution

Q. The relationship between DEPARTMENT and EMPLOYEE is a

View solution