单选题

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?

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

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

单选题 Choose the best answer. You want to transport the UNIVERSITY

tablespace from one database to another. The UNIVERSITY tablespace is

currently open read/write. The source and destination platforms have the

same endian Examine this list of steps:

1. Make the UNIVERSITY tablespace read-only on the source

2. Export the UNIVERSITY tablespace metadata using EXPDP

3. Create a cross-platform backup set from the UNIVERSITY source system, using an RMAN command that includes the DATAPUMP 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 DATAPUMP clause

7. Import the UNIVERSITY tablespace metadata using IMPDP

8.Make the UNIVERSITY tablespace read/write on the destination system

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

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

单选题 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/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 schema owner truncated a table in error and must recover the data.

Which Oracle Flashback feature could be used to recover the data?

单选题 Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

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

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.