ITPub博客

（378）In order to perform Flashback Transaction Query operations,which of these steps are required?(Choose all that apply.)A. Ensure that database is running with version 10.1 compatibility.B. Enable Flashback Logging.C. Enable Supplemental Logging.D. Ensure that the database is runn...

（377）AUM has been retaining about 15 minutes worth of undo.You want to double the retention period,but not at the expense of new transactions failing.You decide to alter the system to set the parameter UNDO_RETENTION=18000.However,AUM still retains only about 15 minutes worth of undo.What i...

（376）A user named Arren is executing this query:select table_name,operation,undo_sql from flashback_transaction_query t,(select versions_xid as xid from employees versions between scn minvalue and maxvaluewhere employee_id=123) e where t.xid = e...

（375）Over the course of a day,a department performed multiple DML statements(inserts,updates,deletes) on multiple rows of data in multiple tables.The manager would like a report showing the time,table name,and DML type for all changes that were made.Which Flashback technology would be the b...

（374）Which of the following statements are true regarding the Recycle Bin?(Choose all that apply.)A. The Recycle Bin is a physical storage area for dropped objects.B. The Recycle Bin is a logical container for dropped objects.C. The Recycle Bin stores the results of a Flashback Drop ope...

（373）Which of the following Oracle features utilize the undo tablespace?(Choose all that apply)A. Flashback QueryB. Flashback DropC. Flashback TableD. Flashback DatabaseE. Transaction ProcessingF. Recycle Bin答案：（A、C、E）

（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）