NEW QUESTION 1
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

• A. A target database’s persistent RMAN configuration settings are always stored in the target’s control file
• B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
• D. The RMAN SHOW ALL command displays only settings with nondefault values.
• E. A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
• G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Answer: ABF

NEW QUESTION 2
Which two are true about unplugging an application container from a container database and plugging it into a different container database?

• A. It requires local undo mode in both container databases.
• B. It requires only local undo mode in the database where the application container will be unplugged.
• C. Plugging the application root into a different CDB plugs In all its application PDBs.
• D. Application PDBs In the application container must beunplugged before the application root Is unplugged.
• E. Unplugging the application root from a CDB unplugs all its application PDBs.
• F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Answer: DE

NEW QUESTION 3
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A. A PDB snapshot is always a full copy of the source PDB.
• B. A PDB snapshot is always a sparse copy of the source PDB.
• C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Answer: AE

NEW QUESTION 4
Which three are located by using environment variables? (Choose three.)

• A. the Optimal Flexible Architecture (OFA) compliant path to storeOracle software and configuration files.
• B. the location of Oracle Net Services configuration files
• C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
• D. default directories for temporary files used by temporary tablespaces
• E. the temporary disk space used by Oracle Installer during installation
• F. the maximum number of database files that can be opened by a database instance

Answer: ABE

NEW QUESTION 5
Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

• A. It can be performed using anauxiliary instance managed by a DBA.
• B. It can be used to recover a truncated table.
• C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
• D. RMAN always includes tablespaces containing undo segments in the recovery set.
• E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
• F. flashback database must be enabled for it to work.
• G. It can be used to recover a dropped tablespace.
• H. It can be performed using an auxiliary instance managed by RMAN.

Answer: AEFH

NEW QUESTION 6
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

• A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
• B. Index balanced B*Tree height is considered whenevaluating the cost of using an index.
• C. The Statistics Advisor can help recommend the best way to gather statistics.
• D. Statistics collected using DBMS_STATS always yield the best optimizer result.
• E. The Statistics Advisor generates actions for all recommendations.

Answer: CD

NEW QUESTION 7
Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• B. Addonly the CREATE_FILE_DEST clause to the statement.
• C. Set only the PDB_FILE_NAME_CONVERT parameter.
• D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• E. Enable only OMF.
• F. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)

Answer: BDE

NEW QUESTION 8
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A. Data file 24 can be recovered only while connected to PDB2.
• B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
• C. Data file 24 can be restored only while connected toCDB$ROOT.
• D. Data file 24 can be restored only while connected to PDB2.
• E. Data file 24 can be recovered while connected to PDB2.
• F. Data file 24 can be recovered while connected to CDB$ROOT.

Answer: BCF

NEW QUESTION 9
You are managing this configuration:
CDB1is a container database.
PDB1andPDB2are two pluggable databases inCDB1.
USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2.
CDB1userSYSexecutes these commands after connecting successfully toPDB2:

Which two are true? (Choose two.)

• A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
• C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
• D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
• E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
• F. The insert on USER2.DEPT is uncommitted.
• G. The inserts on USER1.EMP were committed when the session connected to PDB2.

Answer: FG

NEW QUESTION 10
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

• A. Increase the size of tape I/O buffers.
• B. Disable FORCE LOGGING for the database.
• C. Increase the size of the database buffer cache.
• D. Enable asynchronous disk I/O.
• E. Increase the level of RMAN multiplexing.

Answer: DE

NEW QUESTION 11
Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A. It can berun only manually.
• B. It is part of the DBMS_ADVISOR package.
• C. It can recommend changes to improve the statistics gathering process.
• D. It always analyzes all schemas in the database.
• E. It runs automatically every night by default.
• F. It is part of theDBMS_STATS package.

Answer: ACF

Explanation:
https://mikedietrichde.com/2021/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/ https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf

NEW QUESTION 12
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

• A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
• B. creating the oracle OS user
• C. creating the OSDBA (dba) group
• D. creating thte oraInventory (oinstall) group
• E. creating the grid OS user
• F. configuring the OS for Oracle Automatic Storage Management shared storage access

Answer: BCD

NEW QUESTION 13
Which two are true about gathering optimizer statistics? (Choose two.)

• A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
• C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• D. System statistics can be gathered only while connected to CDB$ROOT.
• E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Answer: BE

Explanation:
https://mikedietrichde.com/2021/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%.

NEW QUESTION 14
Which three are true about an application seed pluggable database (PDB)? (Choose three.)

• A. It is automatically synchronized with its application root PDB when an application is upgraded.
• B. It cannot be added to an application container after the application container has already been created.
• C. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• D. It is automatically synchronized with its application root PDB when an application is installed.
• E. It cannot be dropped from its application container.
• F. A new application PDB created by cloning an application seed PDB canhave an up-to-date version of the application installed after cloning completes.
• G. It is not required in an application container.

Answer: DFG

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

• A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
• B. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.
• C. A new PDB is automatically created when importing a non-CDB into a CDB.
• D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
• E. Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and import.
• F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Answer: DE

NEW QUESTION 16
On the 10th ofAugust, you implement an incremental database backup strategy 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 0 backups. Today is the 26th of August.
Which backups will be obsolete?

• A. all backups prior to 10th of August
• B. all backups prior to 22nd of August
• C. all backups prior to 24th of August
• D. all backups prior to 20th of August
• E. all backups prior to 17th of August

Answer: C

NEW QUESTION 17
Which three are true about opatchauto? (Choose three.)

• A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
• B. It must be invoked by a user with root user privileges.
• C. Patches are appliedvia opatchauto.
• D. Users must always input patch plans to opatchauto.
• E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• F. It applies patches in nonrolling mode by default.
• G. It is used toapply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: ABC

NEW QUESTION 18
Which three are true about Audit policies In container databases (CDBs)?

• A. All audit records are written to the audit trail in CDB$ROOT
• B. A common unified audit policy can be created at the application root level.
• C. A common unified audit policy can be created at the CDB level.
• D. An application PDB cannot have a local audit policy.
• E. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
• F. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.

Answer: DEF

NEW QUESTION 19
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

• A. Using the Data Recovery Advisor LIST FAILURE command always requires that the databasefor which failures are to be listed is in MOUNT state.
• B. A failure can be closed only when it has been repaired.
• C. Data Recovery Advisor can be used if a database is closed.
• D. The Data Recovery Advisor CHANGE FAILURE command can be used only to changefailure priorities.
• E. Data Recovery Advisor can proactively check for failures.

Answer: DE

NEW QUESTION 20
Examine this configuration:
* 1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. * 2.ORCL uses disk group +FRAfor the Fast Recovery Area.
* 3. LISTENER is the listener for ORCL.
* 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5.All components are currently shut down.
You execute this command:

What is the outcome?

• A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENERare started.
• B. Only the ORCL database instance is started.
• C. Only the ORCL database and the ASM instances are started.
• D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
• E. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

Answer: D

NEW QUESTION 21
......