Choose the best answer. Examine this configuration: 1. CDB1 is anOracle container database from an older release. 2. PDB1, PDB2, PDB3, andPDB4 are pluggable databases in CDB1. A priority list UpgrdList has theseentries: 1, pdb2 2, pdb1, pdb3 You execute this command:$ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -LUpgrd List In which order will the upgrade occur?

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:$ sql plus sys/orac1e_4U@localhost:1521/cdb1SQL> SELECT current_scn FROM v$database; CURRENT_SCN 2074756SQL> 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 hascompleted?

Examine this configuration: While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’isaccidentally deleted. To recover from this critical failure, you execute thesecommands: What will be the outcome?

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 sysdbaSQL> CREATE ROLE role1 CONTAINER=CURRENT;Which is true?

Examine this configuration: -1. CDB1 is an Oracle Database 12c Release 2 database containing pluggabledatabases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY -3. PDB1 is open READ WRITE -4. PDB2 is MOUNTED -5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the currentrelease: For which databases will fixup scripts be created?

Aplication PDBs, SALES_APP1 and SALES_APP2, must be created andthey must access common tables of the SALES APP application. Examinethese steps:Install the SALES_APP application, induding the common tables, in theapplication root. Install the SALES_APP application in the application root and the commontables in both the CDB root and the application root. Create an application seed. Install the SALES_APP application in the application seed. Create the SALES_APP1 and SALES_APP2 application PDBs.Sync the SALES_APP1 and SALES_APP2 application PDBs with the applicationroot. Sync the SALES_APP1 and SALES_APP2 application PDBs with the applicationseed. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

Examine these actions: -1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for therecovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on thetablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalogschema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executingthe CREATE CATALOG command?

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 3are 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 thedatabase.

You notice that the performance of your production 24/7 Oracle 12cdatabase has significantly degraded. Sometimes you are not able to connectto the instance because it hangs. You do not want to restart the databaseinstance. How can you detect the cause of the degraded performance?

You notice that the performance of your production 24x7 Oracle 12cdatabase has significantly degraded. Sometimes, you are not able to connectto the database instance because it hangs. How can you detect the cause of the degraded performance?

You notice performance degradation in your production Oracle 12cdatabase. You want to know what caused this performance difference. Which method or feature should you use?

You notice a performance change in your production Oracle 12cdatabase. You want to know which change caused this performancedifference. Which method or feature should you use?

You must transport the UNIVERSITY tablespace from one database toanother. 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 files to the destination platformformat 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 platformformat 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, totransport the UNIVERSITY tablespace?

Choose the best answer. You want to transport the UNIVERSITYtablespace from one database to another. The UNIVERSITY tablespace iscurrently open read/write. The source and destination platforms have thesame endian Examine this list of steps:. 1. Make the UNIVERSITY tablespaceread-only on the source 2. Export the UNIVERSITY tablespace metadatausing EXPDP. 3. Create a cross-platform backup set from the UNIVERSITYsource system, using an RMAN command that includes the DATAPUMPclause. 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 anRMAN command that includes the DATAPUMP clause. 7. Import theUNIVERSITY tablespace metadata using IMPDP. 8. Make the UNIVERSITYtablespace read/write on the destination system. Which are the minimumnumber of steps required, in the correct order, to transport the UNIVERSITYtablespace?

choose one Examine the RMAN commands:RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILESECTION SIZE 400M;Which statement is true about the DUPLICATE command?