20150729实际考错的OCP 1Z0-053题目.doc

Feedback on your performance is printed below. The report lists the objectives for which you answered a question incorrectly. Back up and recover a control file Back up the recovery catalog Configure automatic PGA memory management Configure backup optimization Create a multisection,compressed and encrypted backup Create and Use RMAN stored scripts Define, apply and use a retention policy Enable fast incremental backup Identify the need of backup mode Perform Block Media Recovery Perform Flashback Query Perform user-managed incomplete database recovery Restore a database onto a new host Set up and use a Flashback Data Archive Use Flash Recovery Area Use Flashback Transaction Use a time-based or event-based schedule for executing Scheduler jobs Use job chains to perform a series of related tasksQUESTION 9In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. Youexecuted the following commands to configure the settings in RMAN:Which statement is true about the outcome?A. Only one channel is allocated and the backup is created in the flash recovery areaB. Only one channel is allocated and the backup is created in the destination specified for channelC. Two channels are allocated and backup sets are created in the destinations specified for channels 1and 2D. Three channels are allocated and backup sets are created in the destinations specified for channels 1,2, and FRACorrect Answer: A很容易错误的选B，我正选的BSection: Using the RMAN Recovery Catalog (RC)ExplanationQUESTION 94Which two statements correctly describe the relationship among the Scheduler components: job, program,and schedule? (Choose two)A. A job is specified as part of a program definitionB. A program can be used in the definition of multiple jobsC. A program and job can be specified as part of a schedule definitionD. A program and schedule can be specified as part of a job definitionCorrect Answer: BD错误题库选择的是:AC 我也选的ACSection: Automating Tasks with the SchedulerQUESTION 70You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC. Set the WORKAREA_SIZE_POLICY parameter to MANUALD. Set the PGA_AGGREGATE_TARGET parameter to nonzero valueCorrect Answer: D错误 选择:ASection: Managing MemoryQUESTION 34While performing a regular check on your recovery catalog you realized that the catalog database isrunning out of space and you do not have options to increase the space. However, you have anotherdatabase where more space is available and you want to move your existing recovery catalog to thisdatabase.The options that can be considered while moving the recovery catalog are as follows:1. Using one of the Oracle expdp utilities to export the catalog data2. Creating a recovery catalog user and granting the necessary privileges in the other database3. Creating the recovery catalog using the CREATE CATALOG command4. Using the corresponding impdp utility to import the catalog data into the other database5. Registering the target database in the new catalog database using the REGISTER DATABASEcommand.Identify the option with the correct sequence for moving the recovery catalog.A. 2, 3, 5B. 1, 2, 4C. 1, 2, 4, 5D. 1, 2, 3, 4, 5Correct Answer: B错误 选择:ASection: Using the RMAN Recovery Catalog (RC)ExplanationExplanation/Reference:The exp/imp tools can export and import the complete data structure and data extents to the destinationdatabase, so that you dont need to do create catalog and register database.You realize that the control file is damaged in your production database. After restoring the control file fromautobackup, what is the next step that you must do to proceed with the database recovery?A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS optionCorrect Answer: A粗心 选择：DSection: Performing User-Managed Backup and RecoveryExplanationExplanation/Reference:After restoring the control file, it is time to load the restored control file onto the database instance,to issue STARTUP MOUNT command to load it.QUESTION 36QUESTION 69Examine the following RMAN command:RMAN CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryptionCorrect Answer: B错误 选择：ASection: Configuring Backup SpecificationsQUESTION 75Identity two advantages of using a recovery catalog in-load of the control File of the target databaseRecovery Manager (RMAN). (Choose two.)A. You can use RMAN stored scripts.B. Recovery is faster if data is stored in catalog in addition to the control file.C. You can store backup Information of all registered databases in one place.D. Database backups are automatically deleted when they are older than the specified time period.Correct Answer: AC错误 :ADYour database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERStablespace is damaged and you need to recover the file until the point of failure. The backup for the datafileis available.Which three files would be used in the user-managed recovery process performed by the databaseadministrator (DBA)? (Choose Three)A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failureCorrect Answer: ACF粗心选择:ADC此题可用来复习J P S之间的关系（512）Which two statements correctly describe the schedule?(Choose two) A. A job is specified as part of a program definition B. A program can be used in the definition of multiple jobs C. A program and job can be specified as part of a schedule definition D. A program and schedule can be specified as part of a job definition答案：（B、D） 解析： 如图可见job，program和schedule三者的关系。QUESTION 42View the following SQL statements:Transaction T1SQL INSERT INTO hr.regions2 VALUES (5,Pole);3 COMMIT;Transaction T2SQL UPDATE hr.regions2 SET region_name=Poles3 WHERE region_id = 5;4 COMMIT;Transaction T3SQL UPDATE hr.regions2 SET region_name=North and South Poles3 WHERE region_id = 5;You want to back out transaction T2. Which option would you use?A. It is possible, but transaction T3 also backs out.B. It is possible with the NOCASCADE_FORCE option.C. It is possible with the NONCONFLICT_ONLY option.D. It is not possible because it has conflicts with transaction T3.Correct Answer: B错误选的:ASection: Using Flashback TechnologyQUESTION 77Your production database is functional on the SHOST1 host. You are backing up the production databaseby using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the productiondatabase to anther host, SHOST2, for testing new applications.After you ensured that the backups of the target database are accessible on the new host, what must youdo to restore and recover the backup for the test environment?A. Restoring the control file from the backup by using the NOCATALOG option to restore, and recoveringthe data filesB. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command tochange the locationC. Restoring the server parameter file from the backup by using the recovery catalog to restore,D. Restoring the data files from the backup by using the recovery catalog to recover the files, and usingthe SWITCH command to change the location.Correct Answer: A错误选择：BSection: Using RMAN to Perform RecoveryExplanationExplanation/Reference:Refer to here:To restore the database on a new host:1. Ensure that the backups of the target database are accessible on the new host.2. Configure the ORACLE_SID on hostb.3. Start RMAN on hostb and connect to the target database without connecting to the recoverycatalog.For example, enter the following command:% rman NOCATALOGRMAN CONNECT TARGET/4. Set the DBID and start the database instance without mounting the database.For example, run SET DBID to set the DBID, then run STARTUP NOMOUNT:SET DBID 1340752057;STARTUP NOMOUNTRMAN fails to find the server parameter file, which has not yet been restored, but starts the instancewith a dummy file. Sample output follows:startup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file /net/hostb/oracle/dbs/inittrgta.oratrying to start the Oracle instance without parameter files .Oracle instance started5. Restore and edit the server parameter file.Allocate a channel to the media manager, then restore the server parameter file as a client-sideparameter file and use the SET command to indicate the location of the autobackup (in this example,the autobackup is in /tmp):RUNALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS .;SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO /tmp/%F;RESTORE SPFILETO PFILE ?/oradata/test/inittrgta.oraFROM AUTOBACKUP;SHUTDOWN ABORT;6. Edit the restored initialization parameter file.Change any location-specific parameters, for example, those ending in _DEST, to reflect the newdirectory structure. For example, edit the following parameters:- IFILE- LOG_ARCHIVE_DEST_1- CONTROL_FILES7. Restart the instance with the edited initialization parameter file.For example, enter the following command:STARTUP FORCE NOMOUNT PFILE=?/oradata/test/inittrgta.ora;8. Restore the control file from an autobackup and then mount the database.For example, enter the following command:RUNALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS .;RESTORE CONTROLFILE FROM AUTOBACKUP;ALTER DATABASE MOUNT;RMAN restores the control file to whatever locations you specified in the CONTROL_FILES initializationparameter.9. Catalog the data file copies that you copied in Restoring Disk Backups to a New Host, using their newfile names or CATALOG START WITH (if you know all the files are in directories with a common prefixeasily addressed with a CATALOG START WITH command). For example, run:CATALOG START WITH /oracle/oradata/trgt/;If you want to specify files individually, then you can execute a CATALOG command as follows:CATALOG DATAFILECOPY/oracle/oradata/trgt/system01.dbf, /oracle/oradata/trgt/undotbs01.dbf,/oracle/oradata/trgt/cwmlite01.dbf, /oracle/oradata/trgt/drsys01.dbf,/oracle/oradata/trgt/example01.dbf, /oracle/oradata/trgt/indx01.dbf,/oracle/oradata/trgt/tools01.dbf, /oracle/oradata/trgt/users01.dbf;10. Start a SQL*Plus session on the new database and query the database file names recorded in thecontrol file.Because the control file is from the trgta database, the recorded file names use the original hosta filenames. You can query V$ views to obtain this information. Run the following query in SQL*Plus:COLUMN NAME FORMAT a60SPOOL LOG /tmp/db_filenames.outSELECT FILE# AS File/Grp#, NAMEFROM V$DATAFILEUNIONSELECT GROUP#,MEMBERFROM V$LOGFILE;SPOOL OFFEXIT11. Write the RMAN restore and recovery script. The script must include the following steps:a. For each data file on the destination host that is restored to a different path than it had on the sourcehost, use a SET NEWNAME command to specify the new path on the destination host. If the filesystems on the destination system are set up to have the same paths as the source host, thendo not use SET NEWNAME for those files restored to the same path as on the source host.b. For each online redo log that is to be created at a different location than it had on the source host,use SQL ALTER DATABASE RENAME FILE commands to specify the path name on the destinationhost. If the file systems on the destination system are set up to have the same paths as the sourcehost, then do not use ALTER DATABASE RENAME FILE for those files restored to the same path as onthe source host.c. Perform a SET UNTIL operation to limit recovery to the end of the archived redo logs. The recoverystops with an error if no SET UNTIL command is specified.d. Restore and recover the database.e. Run the SWITCH DATAFILE ALL command so that the control file recognizes the new path namesas the official new names of the data files.Example 20-3 shows the RMAN script reco_test.rman that can perform the restore and recoveryoperation.Example 20-3 Restoring a Database on a New Host:RUN# allocate a channel to the tape deviceALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS .;# rename the data files and online redo logsSET NEWNAME FOR DATAFILE 1 TO ?/oradata/test/system01.dbf;SET NEWNAME FOR DATAFILE 2 TO ?/oradata/test/undotbs01.dbf;SET NEWNAME FOR DATAFILE 3 TO ?/oradata/test/cwmlite01.dbf;SET NEWNAME FOR DATAFILE 4 TO ?/oradata/test/drsys01.dbf;SET NEWNAME FOR DATAFILE 5 TO ?/oradata/test/example01.dbf;SET NEWNAME FOR DATAFILE 6 TO ?/oradata/test/indx01.dbf;SET NEWNAME FOR DATAFILE 7 TO ?/oradata/test/tools01.dbf;SET NEWNAME FOR DATAFILE 8 TO ?/oradata/test/users01.dbf;SQL ALTER DATABASE RENAME FILE /dev3/oracle/dbs/redo01.logTO ?/oradata/test/redo01.log ;SQL ALTER DATABASE RENAME FILE /dev3/oracle/dbs/redo02.logTO ?/oradata/test/redo02.log ;# Do a SET UNTIL to prevent recovery of the online logsSET UNTIL SCN 123456;# restore the database and switch the data file namesRESTORE DATABASE;SWITCH DATAFILE ALL;# recover the d