多项选择题
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
-
单项选择题
YouupgradedOracleDatabase10gtoOracleDatabase11g.Howwouldthisaffecttheexistingusers’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. -
多项选择题
WhichstatementsaretrueregardingSecureFileLOBs？（）
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.
