7a) A file organization where files are not stored in any particular order is considered a: A) hashed file organization. B) hash key. C) multi-indexed file organization. D) heap file organization. 7b) An index on columns from two or more tables that come from the same domain of values is called a: A) bitmap index. B) multivalued index. C) join index. D) transaction index. 7c) A(n) ________ is a routine that converts a primary key value into a record address. A) record index calculator B) index pointer program C) hashing algorithm D) pointing algorithm 7d) A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called: A) multiple partition queries. B) perpendicular query processing. C) parallel query processing. D) query optimization. 7e) A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the: A) explain plan. B) show optimization. C) explain query. D) analyze query.
7a) A file organization where files are not stored in any particular order is considered a:
A) hashed file organization.
B) hash key.
C) multi-indexed file organization.
D) heap file organization.
7b) An index on columns from two or more tables that come from the same domain of values is called a:
A) bitmap index.
B) multivalued index.
C) join index.
D) transaction index.
7c) A(n) ________ is a routine that converts a primary key value into a record address.
A) record index calculator
B) index pointer program
C) hashing
D) pointing algorithm
7d) A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:
A) multiple partition queries.
B) perpendicular query processing.
C) parallel query processing.
D) query optimization.
7e) A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:
A) explain plan.
B) show optimization.
C) explain query.
D) analyze query.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
