If access paths are available on all the conditions of a disjunctive s – McqOptions

MCQOPTIONS

1.	If access paths are available on all the conditions of a disjunctive selection, each index is scanned for pointers to tuples that satisfy the individual condition. This is satisfied by
A.	A10
B.	A7
C.	A9
D.	A6
Answer» B. A7

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.