Which statement is true regarding virtual private catalogs? A. The virtual private catalog owner cannot create and modify the stored scripts. B. A virtual private catalog owner can create a local stored script, and have read/write access to a global…

Which three statements correctly describe the features of the I/O calibration process? (Choose three.) A. Only one I/O calibration process can run at a time. B. It automates the resource allocation for the Automated Maintenance Tasks. C. It improves the…

Which two statements are true regarding hot patching? (Choose two.) A. It requires relinking of the Oracle binary. B. It does not require database instance shutdown. C. It can detect conflicts between two online patches. D. It is available for…

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL>…

You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above? A. Set a threshold…

You create a new Automatic Database Diagnostic Monitor (ADDM) task: my_instance_analysis_mode_task. To view the ADDM report, you use the following command: SQL> SELECT dbms_addm.get_report(‘my_instance_analysis_mode_task’) FROM dual; You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s…

Identify three key features of ASM. (Choose three.) A. file striping B. allocation unit mirroring C. automatic disk rebalancing D. automatic file size increment E. automatic undo management

Which statement about the enabling of table compression in Oracle Database 11g is true? A. Compression can be enabled at the table, tablespace, or partition level for direct loads only. B. Compression can be enabled only at the table level…

You executed the following PL/SQL block successfully: VARIABLE tname VARCHAR2(20) BEGIN dbms_addm.insert_finding_directive (NULL, DIR_NAME=>’Detail CPU Usage’, FINDING_NAME=>’CPU Usage’, MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90); :tname := ‘database ADDM task4’; dbms_addm.analyze_db(:tname, 150, 162); END; / Then you executed the following command: SQL> SELECT dbms_addm.get_report(:tname) FROM…

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…