多项选择题

What recommendations does the SQL Access Advisor provide for optimizing SQL queries？（）

A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap， function-based，and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh

点击查看答案

上一题目录下一题

相关考题

单项选择题

Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?（）

A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback operation

单项选择题

You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords？（）

A. All passwords automatically become case-sensitive.
B. All passwords remain non-case-sensitive till they are changed.
C. All passwords remain non-case-sensitive and cannot be changed.
D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.

多项选择题

Which statements are true regarding SecureFile LOBs？（）

A. The amount of undo retained is user controlled.
B. SecureFile LOBs can be used only for nonpartitioned tables.
C. Fragmentation is minimized by using variable-sized chunks dynamically.
D. SecureFile encryption allows for random reads and writes of the encrypted data.
E. It automatically detects duplicate LOB data and conserves space by storing only one copy.