If a query is optimized without providing specific values for its para – McqOptions

MCQOPTIONS

1.	If a query is optimized without providing specific values for its parameters the technique is called __________
A.	Complex query handling
B.	Multi query optimization
C.	Complex query optimization
D.	Parametric query optimization
Answer» E.

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.