Which two are true about RMAN duplex

多选题 Which two are true about RMAN duplexed backup sets?

A、 They can be written to media.

B、 They can be created only by using the copies option of a BACKUP command.

C、 They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.

D、 They can be written only to disk.

E、 They must be written to media.

查看答案

下载APP答题

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

相关试题

单选题 Examine this configuration1CDB1 is a container database.2 APP_ _ROOT is an application root in CDB1.3 APP PDB1 is an application PDB in APP_ ROOT.4 FLASHBACK DATABASE is ON.You execute these commands:$$ sqlplus sys/oracle_ 4U@localhost:1521/cdb1SQL> SELECT current_ scn FROM v$$database ;CURRENT SCN--------------2074756SQL> CREATE TABLE cdb1_ tab(c1 NUMBER、 ;Table created .SQL> ALTER SESSION SET CONTAINER=apP_ root;Session altered.SQL> CREATE TABLE app_ root_ tab(c1 NUMBER、 ;Table created.SQL> ALTER SESSION SET CONTAINER=app_ pdb1 ;Session altered.SQL> CREATE TABLE app_ pdb1_ tab (c1 NUMBER、 ;Table created 。SQL> conn / as sysdbaConnectedWhich table or set of tables will exist after the Flashback operation has completed?

A、none of the tables, because all three tables will be dropped

B、CDB1_ TAB and APP _PDB1_ TAB

C、CDB1_ TAB and APP ROOT_TAB

D、CDB1 TAB only

E、 CDB1_ TAB, APP_ ROOT _TAB, and APP_ PDB1_ TAB

查看答案

单选题 Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

A、log writer performance

B、SQL statements

C、database instance memory management and sizes

D、general operating system health

E、 database writer performance

查看答案

单选题 Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

A、Itis a set of recommendations by the optimizer to create new indexes

B、It is a set of recommendations by the optimizer to change the access methods used

C、Itis auxiliary information collected by the optimizer for a SQL statement to help use better joins orders

D、Itis a set of recommendations by the optimizer to restructure a SQL statement to avoidSuboptimal execution plans

E、 It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error

查看答案

单选题 A schema owner truncated a table in error and must recover the data Which Oracle
Flashback feature could be used to recover the data?

A、 FLASHBACK VERSION QUERY

B、 FLASHBACK TABLE

C、FLASHBACK TRANSACTION

D、 FLASHBACK DATABASE

E、 FLASHBACK DATAARCHIVE

查看答案

单选题 How do you configure a CDB for local undo mode?

A、 Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace Execute AI TER DAMBASE LOCAL UNDO ON in each PDB. and then restart the CDB instance

B、 Open the CDB instance in restricted mode. In CDB$ROOT. execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB. and then restart the CDB instance.

C、 Open the CDB instance in upgrade mode. In CDB&ROOI, execute ALTER DAIABASE LOCAL UNDO ON, and then restart the CDB instance

D、 Open the CDB in read-only mode. In CDB$ROOI, execute ALTER DATABASE LOCAL UNDO ON and then change the CDB to read/write mode

E、 Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

查看答案

单选题 A user complains about poor database performance
You want to verify if the user's session has waited for certain types of I/O activity Which view displays all
Waits waited on by a session at least once?

A、 V$SESSTAT

B、 V$SESSION WAIT

C、 V$SESSION EVENT

D、 V$SESSION

E、 V$SESSION WAIT CLASS

查看答案

单选题 You want to transport the UNIVERSIRY tablespace from one database to another. The universiry tablespace is currently open read/write. The source and destination platforms have the same endian format. Examine this list of steps:
1 Make the UNIVERSIRY tablespace read-only on the source system
2 Export the UNIVERSIRY tablespace metadata using EXPDP
3 Create a cross platform backup set from the UNIVERSITY tablespace on the source system. using an RMAN command that includes the DAMAPUMP clause
4 Copy the cross-platform backup sets to the destination system
5 Copy the Data Pump dump set from the source to the destination system
6 Restore the cross-platform backup set on the destination system using an RMAN command that includes the pamapump clause
7 Import the UNIVERSIRY tablespace metadata using IMPDP
8 Make the UNIVERSIRY tablespace read /write on the destination system
Which are the minimum number of steps required. in the correct order, to transport the UNIVERSIRY tablespace?

A、3,4,6

B、1,3,4,6,8

C、1,2,3,4,5,6,7,8

D、2,3,4,5,6,7

查看答案

单选题 Examine this configuration
1CDB1 is a container database running in ARCHIVELOG mode.
2 Multiple uncommitted transactions are running in CDB1
3 Redo log groups 1 and 2 are INACTIVE
4edo log group 3 is the CURRENT group
All members of redo log group 3 are lost before it is archived Examine these
Possible steps
1SHUTDOWN ABORT
2STARTUP NOMOUNT
3 STARUP MOUNT
4 ALTER DATABASE MOUNT
5 RESTORE DATABASE
6 RECOVER DATABASE NOREDO
7 RECOVER DATABASE UNTIL AVAILABLE
8 RESTORE ARCHIVELOG ALL
9ALTER DATABASE OPEN
10 ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database

A、1,3,5,6,9

B、1,3,5,8,6,10

C、1,2,5,7,4,10

D、1,3,5,7,10

E、1,3,5,6,10

F、1,3,5,6,10

查看答案