Q. In a ____________ the system scans each file block and tests all records to see whether they satisfy the selection condition.

View solution

Q. Index structures are referred to as __________ since they provide a path through which data can be located and accessed.

View solution

Q. Search algorithms that use an index are referred to as

View solution

Q. Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition.

View solution

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

View solution

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