Which of the following is true about the Database Engine Tuning Advisor?

A. the administrator must have detailed knowledge of the database schema to use it
B. performance gains of less than 25% should be discounted
C. it quantifies the expected performance gains for each recommendation
D. it uses a different set of data than the query optimizer


Answer: C

Computer Science & Information Technology

You might also like to view...

The insert and remove operations of a queue are known as_______ and_______ respectively.

a) push, pop. b) enqueue, dequeue. c) insert, remove. d) None of the above.

Computer Science & Information Technology

What does a sizing pointer look like?

A) Small image of a hand B) Four-headed arrow C) Double-headed arrow D) Single-headed arrow

Computer Science & Information Technology

Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document

Indicate whether the statement is true or false

Computer Science & Information Technology

To move a field list in the Relationships window, drag the table's primary key field. _________________________

Answer the following statement true (T) or false (F)

Computer Science & Information Technology