The process of replacing a nested query with a query with a join is kn – McqOptions

MCQOPTIONS

1.	The process of replacing a nested query with a query with a join is known as _________
A.	Correlation
B.	Decorrelation
C.	Cache handling
D.	Join replacement
Answer» C. Cache handling

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.