Oracle 1z1-034 : Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

• A. all disks that are not currently in OFFLINE mode
• B. all disks that are currently in OFFLINE mode
• C. all disks in the disk group only if all of them are ONLINE
• D. all disks in the disk group

You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A. The approximate time and the lowest system change number (SCN) to which you can flash back your database
• B. The time when the first flashback operation in your database was performed
• C. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
• D. The time when the last flashback operation in your database was performed

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?

• A. It is a list of remote database links stored in the XML file that are available to the users of the database.
• B. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such as UTL_TCP.
• C. It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
• D. It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.

You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.
How would you achieve this?

• A. Implement Scheduler windows
• B. Implement the mapping rule for the consumer groups
• C. Implement job classes
• D. Set the SWITCH_TIME resource plan directive for both the resource plans

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform TSPITR andpreserve the object?

• A. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
• B. Perform Export before TSPITR and Import after TSPITR
• C. Move objects to another schema that has the same tablespace assigned
• D. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)