摘要:
Which mode of database shutdown requires an instance recovery at the time of the next database startup?A.ABORTB.NORMALC.IMMEDIATED.TRANSACTIONAL 数据库在关 阅读全文
摘要:
View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:RMAN> BACKUP DATABASE FILE 阅读全文
摘要:
Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The dat 阅读全文
摘要:
Which option is best practice for creating a recovery catalog owner in the catalog database? A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to t 阅读全文
摘要:
The database is running in the ARCHIVELOG mode. It has three redo log groups with one membereach. One of the redo log groups has become corrupted. You 阅读全文
摘要:
In Recovery Manager (RMAN), you are taking image copies of the data files of your productiondatabase and rolling them forward at regular intervals. Yo 阅读全文
摘要:
Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?A. New chan 阅读全文
摘要:
Your database is running in ARCHIVELOG mode.One of the data files,USERDATA01.dbf,inthe USERS tablespace is damaged and you need to recover the file un 阅读全文
摘要:
You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the 阅读全文
摘要:
You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sb 阅读全文
摘要:
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What 阅读全文
摘要:
Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)A.Flash recovery area must be definedB.Undo retention guarantee 阅读全文
摘要:
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed u 阅读全文
摘要:
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two sce 阅读全文
摘要:
View the Exhibit and note the contents of V$DIAG_INFO.Which statement is true about the ADR? A. The text alert log file will be available in Diag Trac 阅读全文
摘要:
You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LO 阅读全文
摘要:
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP 阅读全文
摘要:
The EMP table has some discrepancy in data entry with a particular employee ID. You execute thequery as shown in the Exhibit to retrieve all versions 阅读全文
摘要:
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed 阅读全文
摘要:
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?(Choose three.)A. Alert log fi 阅读全文