Q. If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

View solution

Q. Ensuring isolation property is the responsibility of the

View solution

Q. In query processing, the ___________ is the lowest-level operator to access data.

View solution

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