NO.108 Which three are true? (Choose three.)

NO.109 Which three are true about using Database Resource Manager in an Oracle multitenant environment?

NO.110 Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

NO.111 Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

NO.112 Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true?

NO.113 Examine this configuration:

While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’ is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

NO.114 RMAN is connected to the target database prod1 and an auxiliary instance in nomount state.
Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE;
Which two statements are true about the execution of the duplicate command?

NO.115 You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1.Make the UNIVERSITY tablespace read-only on the source system.
2.Export the UNIVERSITY tablespace metadata using EXPDP.
3.Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.Copy the UNIVERSITY tablespace data files to the destination system.
5.Copy the Data Pump dump set to the destination system.
6.Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.Import the UNIVERSITY tablespace metadata using IMPDP.
8.Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

NO.116 choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

NO.117 Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true? (Choose two.)

NO.118 Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

NO.119 PDB1and PBD2are pluggable databases in CDB1.
Examine these commands:

CDB1is then restarted.
Which three are true? (Choose three.)

NO.120 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.)

NO.121 Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

NO.122 Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true?

NO.123 Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

NO.124 Which three are true about Data Pump in an Oracle multitenant environment?