Which of the following is the first step of query processing at the DBMS server end?
- a. Parsing
- b. Delivering
- c. Executing
- d. Fetching
Parsing
Which of the following is the first step of query processing at the DBMS server end?
- a. Parsing
- b. Delivering
- c. Executing
- d. Fetching
Parsing
What type of index guarantee(s) that the number of index block accesses is equal to the level of the index structures? a. Bitmap. b. B-tree. c. Hash. d. Data
B-tree
In standard SQL, the optimizer hint ALL_ROWS is generally used for _____ mode processes.
a. real-time
b. transaction
c. interactive
d. batch
batch
A(n) _____ is good for simple and fast lookup operations based on equality conditions.
a. B-tree index
b. hash index.
c. reverse index
d. sparse index
hash index
If you are taking an SQL statement and transforming it, what type of plan will the DBMS create? a. fetching b. parsing c. data d. execution
execution
When a server doesn't have internal statistics supporting the
objects referenced by the statement, what type of optimizer
gets preference?
a. Rule-base
b. data-base.
c. Cost- base
d. Product-base
Rule-base
A conditional expression is normally expressed within the _____ or HAVING clauses of an SQL statement.
a. ORDER BY. b. GROUP BY. c. WHERE. d. UPDATE
WHERE
During the ____ phase, the DBMS retrieves the data and sends
the result set back to the client.
a. execute
b. parse
c. fetch
d. process
fetch
If you want the optimized query results always the same as the original query. What type of SQL code is being used?
a. Fully equivalent
b. Less efficient.
c. Most efficient
d. Unfully equivalent.
a. Fully equivalent
The data cache is where the data, read from the database data files, are stored _____ the data have been read or _____ the data are written to the database data files.
- a. after; before
- b. before; after
- c. after; after
- d. before; before
a. after; before
When there is an abundance of the internal statistics, what type of optimizer gets preference?
- a. Cost-base
- b. Rule-base
- c. Product-base
- d. data-base.
Cost-base
If there is no index, the DBMS will perform a _____ scan.
- a. loop
- b. full table
- c. range
- d. row ID table access
b. full table
_____ helps provide a balance between performance and fault tolerance.
- a. RAID
- b. I/O accelerators
- c. clustered index
- d. DBMS
RAID
How can you write this phrase NOT (C_COST > 20.00) without using NOT?
- a. C_COST < = 20.00.
- b. C_COST > 20.00
- c. C_COST => 20.00
- d. C_COST = 20.00
a. C_COST < = 20.00.
A(n)_____ is an index based on a specific SQL function or expression.
- a. index selectivity
- b. function-based index
- c. performance tuning
- d. table attributes
b. function-based index
