Which of the following is a multi-query optimization technique – McqOptions

MCQOPTIONS

1.	Which of the following is a multi-query optimization technique
A.	Shared scan optimization
B.	Parametric query optimization
C.	Index optimization
D.	All of the mentioned
Answer» B. Parametric query optimization

Discussion

No Comment Found

Related MCQs

Consider the following relational schemes for a library database:Assume {Author, Title} is the key for both schemes. Which of the following statements is true?
Which of the following fixed database roles can add or remove user IDs?
A view whose contents are computed and stored is called as _______
The process of replacing a nested query with a query with a join is known as _________
The size of a _____ is simply V(A,r) where r is the relation and A is a distinct value
By default sql server has ___________ isolation level
Which of the following operations is associative
State true or false: Estimation of the size of the result of a join is not possible
Ensuring isolation property is the responsibility of the
_______________ is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.