首页  /  试题详情

单选题 LIST、 ADVISE、 REPAIR FAILURE
A container database (CDB. CDB1 runs in ARCHIVELOG mode.
It contains pluggable databases (PDBs), PDB_1 andPDB_2.
Examine this command andoutput:
SQL> alter pluggable databane pdb_1 open;
ORA-01157: cannot identify/ lock data file 11 - see DBWR trace file
ORA-01110: data file 11: ‘ /u01/app/oracle/oradata/ cdb1/pdb 1/example01 .dbf "
You connect RMAN to CDB$ROOT in CDB1.
Now examine these commands:
RMAN> LIST FAILURE ,
RMAN> REPAIR FATLURE ;
Which is true

A、 The command produces an error because the LIST FAILURE command was executed before
The REPAIR FAILURE command.
B、 The command performs recovery, closes the fallure, and opens PDB 1 .
C、 The command performs the recovery, leaves the failure open, and leaves PDB_ 1 mounted.
D、 The command produces an error because the ADVISE FAILURE command was not executed
Before the REPAIR FAILURE command.
E、 The command performs the recovery, closes the failure, and leaves PDB_ 1 mounted.
查看答案
下载APP答题
由4l***zm提供 分享 举报 纠错
相关题库推荐
063新
2021-06-29
共359道

相关试题

单选题
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure
Backup
1)RMAN initiates backup and passes the database backup storage selector to OSB.RMANRMAN
2)RMAN creates the backup job.
3)OSB creates the backup job with an OSBuser
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

单选题
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.

单选题
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 backupsets

单选题
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.

单选题
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.

单选题
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

单选题
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

单选题
You are administering a multitenant container database (CDB. CDB1 with two pluggable
Databases(PDBs),PDB1 and PDB2.
Your execute the following commands on CBD$ROOT as the sys user:
SQL>CREATE USER C##scott IDENWTIFTED BY scottorcl1; SQL>GRANT CREATE SESSION TO
C##scott;
Which statement is true about the c##scott user?

A、 It is created and has the CREATE SESSION privilege only in a PDB that isopen.
B、 It is created in all the PDBs with the CREATE SESSTON privilege.
C、 It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
D、 It is created only in CDB$ROOT and has the CREATE SESSION privilege.