Your container database, CDB1, has a

多选题 Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

A、 CDB1 and CDB2 must be in shared undo mode.

B、 A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C、 All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D、 Cloning HR_ROOT automatically clones HR_PDB1.

E、 The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

查看答案

下载APP答题

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

相关试题

单选题 You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A、Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B、Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

C、Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

D、Create the database by using the CREATE DATABASE... command and manually import data by using Data Pump.

查看答案

单选题 Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed. No changes have been made to the standard PDB$SEED. How many default temporary tablespaces can be assigned in the CDB?

A、Seven

B、Five

C、Eight

D、Three

E、Six

查看答案

单选题 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.（CDB ROOT 不需要） 3. Create an application seed. 4. Install the SALES_APP application in the application seed.（APP SEED 不能安装 APP） 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 running in ARCHIVELOG mode. 2. Multiple uncommitted transactions are running in CDB1 . 3. Redo log groups 1 and 2 are INACTIVE. 4. Redo log group 3 is the CURRENT group. All members of redo log group 3 are lost before it is archived. Examine these possible steps: 1. SHUTDOWN ABORT 2. STARTUP NOMOUNT 3. STARTUP MOUNT 4. ALTER DATABASE MOUNT 5. RESTORE DATABASE 6. RECOVER DATABASE NOREDO 7. RECOVER DATABASE UNTIL AVAILABLE REDO 8. RESTORE ARCHIVELOG ALL 9. ALTER 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, 7, 10

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

D、1,3, 5, 6, 10

E、1,3,5, 6, 10

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

查看答案

单选题 Choose the best answer. Examine this configuration:

1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).

2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.

After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:

$$ export ORACLE_SID=cdb1

$$ sqlplus / as sysdba

SQL> STARTUP UPGRADE;

SQL> SHOW pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

2 PDB$$SEED MIGRATE YES

3 PDB1 MOUNTED YES

4 PDB2 MOUNTED YES

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE;

Pluggable database altered.

SQL> exit

$$ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2'

What is the outcome?

A、

It fails because PDB$SEED is in MIGRATE state.

B、

Only CDB$$ROOT, PDB$$SEED, and PDB1 are upgraded.

C、

Only CDB$$ROOT, PDB$$SEED, and PDB2 are upgraded.

D、

It fails because PDB2 is not in UPGRADE state.

E、CDB$$ROOT, PDB$$SEED, PDB1, and PDB2 are upgraded.

F、Only CDB$$ROOT and PDB$$SEED are upgraded.

查看答案

单选题 Choose the best answer. Examine this configuration: 1. CDB1 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/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

查看答案

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

查看答案

单选题 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. You execute these commands: $ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE ‘1.0’ TO ‘2.0’; Pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL); Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO ‘2.0’; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type ENO NUMBER ENAME VARCHAR2(20) SQL> SELECT * FROM emp; ENO ENAME 100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?

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

查看答案