ITPub博客

（372）Which command do you use to generate a report of database incarnations?A. list incarnation of databaseB. report incarnation of databaseC. list database incarnationD. database incarnation listE. report database incarnation答案：（A）解析：...

（371）In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?A. The datafiles have an ONLINE status.B. The datafiles have an OFFLINE status.C. The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.D. The d...

（370）Why should you back up a duplicated tablespace after a TSPITR is complete?A. The tablespace cannot be duplicated or restored to any point in time after the duplication.B. The tablespace cannot be duplicated or restored to the point in time before the duplication.C. The entire datab...

（369）Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?A. The SGA Tuning AdvisorB. The SQL Access AdvisorC. The SQL Tuning AdvisorD. The Memory Advisor答案：（B）解析：答案解析：The SQL Access Advisor i...

（368）When issuing the duplicate database command,you use the parameter DB_FILE_NAME_CONVERT.For what purpose do you use this parameter?A. To indicate the location of the auxiliary-instance online redo logs.B. To indicate the location of the target database datafiles.C. To indicate t...

（367）You’re performing tablespace point-in-time recovery on a tablespace called USERS.If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS。which statement is true?A. You cannot perform the TSPITR with the constraints enabled.B. You ...

（366）If you are going to run a TSPITR recovery,which view will help you to determine which objects will be lost during the TSPITR?A. TS_OBJECTS_TO_BE_DROPPEDB. TS_PTTR_OBJECT_DROPPEDC. TS_PITR_OBJECTS_TO_BE_DROPPEDD. TS_OBJECTS_DROPPEDE. TS_DROPPED_OBJECTS答案：（C）...

（365）Which of the following restrictions are not true with respect to tablespace point-in-time recovery?(Choose all that apply.)A. The target database must be in NOARCHIVELOG mode.B. No backup is required of the database before you perform a TSPITR.C. You must have all archived redo log...

（364）When running the tablespace point-in-time commandrecover tablespace users until time '10/06/2008:22:42:00' auxiliary destination 'c:\oracle\auxiliary';you receive the following error:RMAN-00571:==============================================...

（363）you can perform an active database duplication when the database is in NOARCHIVELOG mode.A. TrueB. False答案：（B）解析：活动的数据库复制，必须要求数据库运行在归档模式

（362）Which command would correctly start a TSPITR of the USERS tablespace?A. recover tablespace users until time '10/06/2008:22:42:00' auxiliary 'c:\oracle\auxiliary';B. recover tablespace users time '10/06/2008:22:42:00' auxiliary destination 'c:\oracle\auxiliary';C. recover tablespace...

（361）When performing a database duplication,which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?A. log_file_name_convertB. convert_log_file_nameC. file_name_convert_logD. redo_log_file_name_convertE. logfile_co...

活动链接：

（360）When performing a full database disaster recovery with RMAN, in what order would you execute these steps?a. Restore the control file from autobackups.b. Run the RMAN restore and recover command.c. Restore the database spfile from autobackups.d. Make the RMAN backup set pieces a...

（359）What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?A. TS_CHECKB. TPITR_CHECKC. TS_PITR_CHECKD. CHECK_TSPITRE. PITR_TS_CHECK答案：（C）

（358）What command is used to reset a database to a previous incarnation?A. reset incarnationB. incarnation resetC. reset database to incarnationD. reset database incarnationE. reset databse incarnation number答案：（C）

（357）How many database instances are used during a database-duplication process?A.  OneB.  TwoC.  ThreeD.  FourE.  Five答案：（B）

（356）Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?A.set oracle_sid=orclrman target=sys/robert auxname=sys/Robert@orcl2create duplicate target database to n...