You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish…
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.) A. Health Monitor checks are always initiated manually when there is some critical error. B. Health Monitor checks can be used to scan the contents…
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition? A. It remains valid. B. It becomes invalid for all…
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this?…
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…
View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error? A. The DISK_ASYNCH_IO parameter is set to TRUE. B. The FILESYSTEMIO_OPTIONS parameter…
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this?…
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…
Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.) A. You can add SQL test cases to the incident package. B. You can add or remove the…
You issued the following RMAN command to back up the database: RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4;} Which two statements are true regarding the backup performed? (Choose two.) A.…