db"orq"

Diagnostic Monitor(ADDM) in an Oracle multitenant environment?

pluggable database(PDB) starting from Oracle 19c?

Examine these commands:

（含图）

SQL> STARTUP

-----

Database opened.

SQL> SHOW PDBS

CON_ID CON_NAME OPEN MODE RESTRICTED

-------------------------------------------

（含图）

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;

pluqgable database altered.

CDB1 is then restarted.

Which three are true?

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 database is configured in ARCHIVELOG mode.

A full RMAN backup exists but no control file backup to trace has been taken.

A media failure has occurred.

In which two scenarios is incomplete recovery required?

compression using RMAN default

compression!

Workload Repository (AWR) snapshots!

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:

（含图）

（含图）

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.

Which table or set of tables will exist after the Flashback operation has completed?

1. CDB1 and CDB2 are two container databases.

2. PDB1 is a pluggable database in CDB1.

3. PDB1_C1_SRV is a service for PDB1.

4. CDB1_LINK is a database link in CDB2 referring to PDB1.

5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.

（含图）

Which two are true?

You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1

ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)

CREATE_FILE_DEST='/u01/app/oracle/oradate/cdb1/pdb1';

Which three are true about PDB1?