Similar Collections

.

questions

Title
Which of the following is an attribute that can uniquely identify a row in a table
Which of the following terms does refer to the correctness and completeness of the data in a database
The relationship between DEPARTMENT and EMPLOYEE is a
A table can be logically connected to another table by defining a
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
Ensuring isolation property is the responsibility of the
In query processing, the ___________ is the lowest-level operator to access data
In a ____________ the system scans each file block and tests all records to see whether they satisfy the selection condition
Index structures are referred to as __________ since they provide a path through which data can be located and accessed
Search algorithms that use an index are referred to as
Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single record that satisfies the corresponding equality condition
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
The algorithm that uses a secondary ordered index to guide retrieval for comparison conditions involving <,≤,≥, or > is
The ___ algorithm scans each index for pointers to tuples that satisfy an individual condition
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
Conjunctive selection using one index
A_____ is a query that retrieves rows from more than one table or view
A condition is referred to as __________
Which oracle is the join condition is specified using the WHERE clause
Which are the join types in join condition
total questions: 204

Questions

204

Views

2036

Best Answers

299

Points

5