291、
291.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.
292、
292.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? (Choose two.) 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.
293、
293.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.
294、
294.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
295、
295.Which statement about using RMAN stored scripts is true? A. To create and execute an RMAN stored script, you must use a recovery catalog. B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file. C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog. D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
