Oracle 1z0-032: Oracle 9i: Database Fundamentals II
#71. You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?
#72. Examine this syntax which allocates channels during a parallel image copy: RMAN> CONFIGURE DEVICE TYPE disk parallelism 4: 2> COPY 3> data file 1 TO ‘/BACKUP/data file1.dbf’, 4> data file 2 TO ‘/BACKUP/data file2.dbf’, 5> data file 3 TO ‘/BACKUP/data file3.dbf; RMAN>COPY 2> data file 4 TO ‘/BACKUP/data file4.dbf’; How many channels are used?
#73. Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle 9i?
#75. Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)
#78. The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps. 1. Shot down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command. 4. End read or update activity on the former primary and standby database.
#79. Click the Exhibit (missing) button and examine the diagram. You are running a database that takes advantage of features provided by Connection Manager, heterogeneous services, and external procedures. The diagram depicts the components used for the naming method you just configured. Which naming method are you using?
#80. When performing recover of a database in NOARCHIVE LOG mode with RMAN, the target database must be in the ______ state to restore the control file.