MCQOPTIONS
Bookmark
Saved Bookmarks
→
Database
→
Managing Databases With Oracle
→
The ___ algorithm scans each index for pointers to...
1.
The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition?
A.
A2
B.
A4
C.
A9
D.
A6
Answer» D. A6
Show Answer
Discussion
No Comment Found
Post Comment
Related MCQs
CONJUNCTIVE_SELECTION_USING_ONE_INDEX._THIS_IS?$
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 b?
The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition?
The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving is$
The strategy can retrieve a single record if the equality condition is on a key; multiple records may be retrieved if the indexing field is not a key is
Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.
Search algorithms that use an index are referred to as
Index structures are referred to as __________ since they provide a path through which data can be located and accessed.
In a ____________ the system scans each file block and tests all records to see whether they satisfy the selection condition.
In query processing, the ___________ is the lowest-level operator to access data.
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies