ITPub博客

（679）Which mode of database shutdown requires an instance recovery at the time of the next database startup?A. ABORTB. NORMALC. IMMEDIATED. TRANSACT答案：（A）

（678）Which are the two prerequisites before setting up Flashback Data Archive?(Choose two.)A. Flash recovery area must be definedB. Undo retention guarantee must be enabled.C. Database must be running in archivelog mode.D. Automatic undo management must be enabled.E. The tablesp...

（677）What are the prerequisites for performing flashback transactions?(Choose all that apply)A. Supplemental log must be enabledB. Supplemental log must be enabled for the primary keyC. Undo retention guarantee for the database must be configuredD. EXECUTE permission on the DBMS_FLA...

（676）Which command creates an image copy?A. backup as copyB. backup copyC. copy as backupD. copy back答案：（A）

（675）Which two client requests are captured during database replay Capture?(Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL*loaderE. Data definition l...

（674）View the Exhibit to observe the error.You receive this error regularly and have to shutdown the database instance to overcome the error.Automatic Shared Memory Management is configured for the instance.What can you do to reduce the chance of this error in the future?A. Increase...

（673）In Recovery Manager（RMAN）,you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals.You attempt to restart your database instance after a regular maintenance task,you realize that one of the data files that belongs to the U...

践

（671）Examine 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 se...

（670）After you have restored and recovered a database to a new host by using a previously performed Recovery Manager（RMAN）backup,which is the best option you would consider for the new database?A. Opening the database in RESTRICTED modeB. Opening the database with the RESETLOGS option...

（669）User SCOTT wants to back out the transactions on the REGIONS table in his schema.As a DBA,which commands must you execute to enable SCOTT to flash back the transactions?(Choose four.)A. ALTER DATABASE FLASHBACK ON;B. GRANT SELECT ANY TRANSACTION TO scott;C. GRANT EXECUTE ON dbm...

（668）Examine the following RMAN script:RMAN>run{  debug on;  allocate channel c1 type disk;  backup datafile 5;}Which statement describes the purpose of the script?...

（667）What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?A. An upper limit on how far you can flash back the database,depending on the information in the redo logsB. An upper limit on how far you can flash back the database,depending on the information in the undo tablespace...

（666）You are working in an online transaction processing（OLTP）environment.You use the FLASHBACK TABLE command to flash back the CUSTOMERS table.Before executing the FLASHBACK TABLE command,the system change number(SCN)was 663571.After flashing back the CUSTOMERS table,you realize that...

（665）Which two statements are true about the Automatic Diagnostic Repository(ADR)?(Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script,which can be used to work with ADRC. The ADR can be used for problem diagnosis only when t...

（664）You want to take a complete database backup using RMAN.The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?(Choose two.)A. Backup compression should be enabledB. Parallelism for the channel should be set to 2...

（663）Which options would you consider while configuring a flash recovery area（fast recovery area in 11g Release 2）for your production database that is running in ARCHIVELOG mode?（Choose all that apply.）A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting t...

（662）To enable faster incremental backups,you enabled block change tracking for the database.Which two statements are true about the block change tracking file?(Choose two.)A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after ...

（661）View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:RMAN>RUN{  ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;  BACKUP DATABASE FILESPERSET 4;...