单项选择题
Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?（）
A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor
相关考题
-
单项选择题
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?（）
A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR)
B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR)
C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed -
多项选择题
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? （）
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system. -
单项选择题
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
