choose one. You take regular backups of one of your productiondatabases by using RMAN with a recovery catalog. You have added two newtablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the newdatafiles?

choose one You want to create a test database as a replica of yourproduction database with minimum intervention from a DBA. Which methodwould you use?

Choose the best answer. Which statement correctly describes the SQLprofiling performed by the SQL Tuning Advisor?

Choose the best answer. Which should be tuned first when doing aperformance tuning exercise for an Oracle Database environment?

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

Examine this configuration: -1. The ORCL database data files are in Automatic Storage Management(Oracle ASM) disk group +DATA. 2. ORCL uses disk group +FRA for the Fast Recovery Area. 3. LISTENER is the listener for ORCL.4. The database, listener, ASM instance, and ASM disk groups are managedby Oracle Restart. 5. All components are currently shut down. You execute this command:ssrvctl startdatabase-doRC LWhat is the outcome?

In a recent Automatic Workload Repository (AWR) report for yourdatabase, you notice a high number of buffer busy waits. The databaseconsists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused bycontention on data blocks. Which option would you consider first to decrease the wait eventimmediately?

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore PointR1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

Choose the best answer. On the 10th of August, you implement an incremental database backupstrategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0backups. Today is the 26th of August. Which backups will be obsolete?

Choose the best answer. How do you configure a CDB for local undo mode?

Choose the best answer. Which operating system group is NOTneeded to perform an Oracle Database installation?

You issue the command:SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;Which statement is true about the command?

Choose the best answer. Examine this configuration: -1. CDB1 is a container database. 2. There are several pluggable databases (PDBs) in CDB1. 5. Each PDB has several tables with referential integrity constraints. 6. FLASHBACK DATABASE is ON. 7. UNDO RETENTION GUARANTEE is enabled. Multiple undesired multitable changes were made in all the PDBs. Which method can be used to undo the changes using a single command?

Choose the best answer. Examine this configuration: -1. CDB1 is a container database. 2. DEFAULT_SHARING is METADAT .A. 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:$ sql plus sys/orac1e@localhost:1521/cdb1 as sysdbaSQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA;System altered. SQL> ALTER SESSION SET CONTAINER=app_root;Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGINUPGRADE '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 ENDUPGRADE 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 BenSQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC;What will be the outcome and why?

Choose the best answer. Examine this configuration: 1. CDB1 is anOracle Database 12c Release 2 container database (CDB). -2. PDB1 and PDB2are two pluggable databases (PDBs) in CDB1. After successfully performingall the preupgrade tasks, you execute these commands from the Oracle Database 18c environment: $ export ORACLE_SID=cdb1 $ sqlplus / assysdba SQL> STARTUP UPGRADE; SQL> SHOW pdbs CON_ID CON_NAMEOPEN MODE RESTRICTED--------------------------------------------------------------2PDB$SEED 3 PDB1 4 PDB2 MIGRATE YES MOUNTED YES MOUNTED YESSQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; Pluggabledatabase altered. SQL> exit $ $ORACLE_HOME/perl/bin/perl catctl.pl -C'PDB2' What is the outcome?