單項(xiàng)選擇題

Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）

A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above

你可能感興趣的試題

多項(xiàng)選擇題

What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

A. It cannot generate recommendations that support multiple workload queries.
B. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
C. It can recommend partitioning only on tables that have at least 10,000 rows.
D. It can recommend only B-tree indexes and not bitmap or function-based indexes

單項(xiàng)選擇題

Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）
a. restore database
b. recover database
c. shutdown immediate
d. startup
e. restore archivelog all
f. alter database open

A. a， b， c， d， e， f
B. c， b， a， d， e， f
C. c， b， a， d， f
D. c， a， b， d
E. c， a， e， b， d， f

Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）

你可能感興趣的試題

What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（） a. restore database b. recover database c. shutdown immediate d. startup e. restore archivelog all f. alter database open

Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）
a. restore database
b. recover database
c. shutdown immediate
d. startup
e. restore archivelog all
f. alter database open