Choose three. You issued this comman

多选题 Choose three. You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true?

A、 All files in any previous FRA that have not yet been backed up, are backed up.

B、 All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.

C、 All files in the current FRA that have been backed up already, are backed up.

D、 All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

E、 All files in any previous FRA that have been backed up already, are backed up.

F、 All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up.

G、 All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

查看答案

下载APP答题

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

相关试题

单选题 Examine this configuration:

A、 It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’

B、 It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.

C、 It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’

D、 It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.

E、 It will fail because there is no autobackup of the controlfiles.

查看答案

单选题 Choose the best answer. Examine this configuration:
-1. CDB1 is a container database.
-2. 2. APP_ROOT is an application root in CDB1.
-3. 3. APP_PDB1 is an application PDB in APP_ROOT.
-4. 4. FLASHBACK DATABASE is ON.
You execute these commands:
$$ sqlplus sys/orac1e_4U@localhost:1521/cdb1
SQL> SELECT current_scn FROM v$$database;
CURRENT_SCN
2074756
SQL> 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 sysdba
Connected.
SQL> ALTER PLUGGABLE DATABASE app_root CLOSE;
Pluggable database altered.
SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756;
Flashback complete.
Which table or set of tables will exist after the Flashback operation has completed?

A、 CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

B、 CDB1_TAB and APP_PDB1_TAB

C、 CDB1_TAB and APP_ROOT_TAB

D、 CDB1_TAB only

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

查看答案

单选题 Choose the best answer.
Examine this output of an export from the current release of an Oracle multitenant database: $$ sqlplus system/oracle .
SQL> col name for a10
SQL> select name, open_mode from v$$pdbs;
NAME OPEN_MODE
PDB$$SEED READ ONLY
PDB1 READ WRITE
PDB2 MOUNTED
SQL> exit
Next you execute: $$ expdp system/oracle full=y
What is the outcome?

A、 It fails because Data Pump cannot be used while connected to the root container.

B、 It creates a full export of the root container and PDB1.

C、 It creates a full export of the root container and all PDBs.

D、 It creates a full export of the root container and all open PDBs.

E、 It creates a full export of only the root container.

查看答案

单选题 Choose the best answer. Examine this configuration:
-1. CDB1 is a container database.
-2.COMMON_USER_PREFIX is set to an empty string.
-3. PDB1 is a pluggable database in CDB1.
-4. APP1_ROOT is an application container in CDB1.
-5. APP1_PDB1 is an application PDB in APP1_ROOT.
You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;
Which is true?

A、 It will return an error because creation of a local role is not allowed in CDB$ROOT.

B、 ROLE1 will be created only in CDB$ROOT.

C、 It will return an error because common roles must start with C##.

D、 ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E、 ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

查看答案

单选题 Choose the best answer. 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 ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

B、 Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

C、 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.

D、 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.

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

查看答案

单选题 You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2.
You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true
About the result of this command?

A、 The statistics_level parameter is set to all when any of the PDBs is reopened.

B、 The statistics_level parameter is set to all only for PDB2 when it is reopened.

C、 The statistics_level parameter is set to all when the root database is restarted.

D、 The statement is ignored because there is no SPFILE for a PDB.

查看答案

单选题 Choose the best answer.
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
-1. Install the SALES_APP application, including the common tables, in the application root.
-2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
-3. Create an application seed. ;
-4. Install the SALES_APP application in the application seed.
-5. Create the SALES_APP1 and SALES_APP2 application PDBs.
-6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
-7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
-8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

A、 1,3,5,7

B、 3,4,1,6,8

C、 1,3,5,6,7

D、 1,5,6

E、 2,5,6

查看答案

单选题 Choose the best answer. Examine this configuration:
-1. CDB1 is a container database.
-2. DEFAULT_SHARING is METADATA.
-3. APP_ROOT is an application root contained in CDB1.
-4. APP_PDB1 is an application PDB contained in APP_ROOT.
-5. COMPANYAPP is an application contained in APP_ROOT.
-6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.

A、 SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B、 SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C、 It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

D、 It will return an error because EMP is not empty in APP_ROOT.

E、 It will return an error because EMP.SAL is empty in APP_ROOT.

查看答案