.You use RMAN to take regular backup

单选题 .You use RMAN to take regular backups for your database. Examine the RMANcommands: RMAN> CROSSCHECK BACKUP; RMAN> DELETE EXPIRED BACKUP;
Which statement is true?

A、 All metadata pertaining to backups and archived redo log files that have exceeded the age set by the RMAN retention policy are deleted from therepository.

B、 All metadata, for backups and archived redo log files that are recorded in the repository but do not exist on disk or media, isdeleted.

C、 All backups that have exceeded the age set by the RMAN retention policy are deleted.

D、 All backups and archived redo log files that are not recovery are deleted and the repository is updated.

查看答案

下载APP答题

由4l***jx提供分享举报纠错

相关试题

单选题 .You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users:
Which statement is true about the execution of the command?

A、 The backup succeeds only if the users tablespace is locally managed.

B、 RMAN uses multiplexing to perform thebackup.

C、 The resulting backupset has backup pieces that cannot exceed 300 MB.

D、 RMAN always performs this type of backup in parallel.

E、 The backup set size is limited to 300 MB.

查看答案

单选题 .Your database is running in ARCHIVELOG mode and flashback is enabled
In which scenario must you use RMAN backups for recovering tables and table partitions?

A、 when recovering a table to a point intime

B、 when recovering a table that has been logically corrupted

C、 when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo

D、 when recovering dropped tables that are present in the recycle bin

E、 when recovering data that was lost after a DDL operation modified the structure of a table

查看答案

多选题 .Which two are prerequisites for performing FlashbackTransaction?

A、 Undo retention guarantee must be configured for the database.

B、 The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

C、 A supplemental log must be enabled for the primary key.

D、 Row movement must beenabled.

E、 Fast Recovery Area must be enabled for the database.

查看答案

单选题 .you enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for Keeping transactions from four to two years .
You execute the following command to change the requirement:
SQL>ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTTON 2 YEAR;
What is the outcome?

A、 All historical data older than two years, if any, is purged from the flashback archive FDA1.

B、 All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retentiontime.

C、 An error is returned because the retention period cannot be reduced.

D、 AIl the flashback data archives are purged and the subsequently created flashback archives are maintained for twoyears.

查看答案

单选题 .Examine the RMAN command: RMAN> RUN
{ ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP INCREENTAL LEVEL = 0 (DATAFILE 1, 4, 5 CHANNEL c1)
(DATAFILE 2, 3, 9 CHANNEL c2)
(DATAFILE 6, 7, 8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true about the command?

A、 It uses parallelization for thebackupset.

B、 It uses multisection backup.

C、 It uses asynchronous I/O for the backup.

D、 It creates compressed backup sets

查看答案

单选题 .Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup(OSB):

1.RMAN initiates backup and passes the database backup storage selector to OSB.RMAN

2.RMAN creates the backupjob.

3.OSB creates the backup job with an OSB user

4.RMAN updates its repository.

5.RMAN executes the job and transfers data from a client tomedia.

6.OSB executes the job and transfers data from a client to media

7.OSB updates its repository. Identify the required steps in the correct order.

A、

2,1,6,4,7

B、

1,3,6,7,4

C、

1,3,6,4,7

D、

1,3,5,7,4

查看答案

单选题 .Examine the RMAN commands:
RMAN> CONNECT TARGET "sbu@prod as SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db as SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_dbFROM ACTIVE DATABASEPASSWORD FILESECTION SIZE 400M;
Which statement is true about the DUPLICATE command?

A、 It succeeds only if the target database is in MOUNT state.

B、 It succeeds and creates multisection backup sets that are used for active database duplication.

C、 It fails because there is no connection to a recovery catalog

D、 It fails because no parallel channels are allocated for the auxiliary database

查看答案

多选题 .In your database, the user scott wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL>FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed?

A、 scott should have the FLASHBACK ANY TABLEprivilege.

B、 No duplicates of the HR.EMPLOYEES table should exist in the recycle bin of the HR schema.

C、 scott should have the SELECT privilege on the HR schema and its recycle bin

D、 Undo retention guarantee must be enabled.

E、 No other table with the same name should exist in the HR schema HR

F、 The recycle bin should be enabled

查看答案