Q. The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving <,≤,≥, or > is

View solution

Q. The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition.

View solution

Q. 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

View solution

Q. Conjunctive selection using one index. This is

View solution

Q. A_____ is a query that retrieves rows from more than one table or view:

View solution

Q. A condition is referred to as __________

View solution

Q. Which oracle is the join condition is specified using the WHERE clause:

View solution

Q. Which are the join types in join condition:

View solution

Q. Which product is returned in a join query have no join condition:

View solution

Q. Which is a join condition contains an equality operator:

View solution

Q. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

View solution

Q. Which operation are allowed in a join view:

View solution

Q. Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

View solution

Q. Pictorial representation of an expression is called

View solution

Q. The results of each intermediate operation are created and then are used for evaluation of the next-level operations. This is called

View solution

Q. ______________ allows the algorithm to execute more quickly by performing CPU activity in parallel with I/O activity.

View solution

Q. Pipelines can be executed in

View solution

Q. In a _________ the system makes repeated requests for tuples from the operation at the top of the pipeline.

View solution

Q. In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.

View solution

Q. Each operation in a demand-driven pipeline can be implemented as an ____ that provides the following functions: open(), next(), and close().

View solution