NEW QUESTION 1
Your CDB has two regular PDBs as well as one application container with two applicationPDBs and an application seed
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

• A. three
• B. eight
• C. seven
• D. six
• E. five

Answer: C

NEW QUESTION 2
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

• A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• B. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
• C. All Oracle recovery files in the current FRA that have not been backed up already,are backed up.
• D. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
• E. These backups can be written to disk or SBT.

Answer: DE

Explanation:
https://blog.toadworld.com/rman_-_using_the_flash_recovery_area

NEW QUESTION 3
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 4
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A. using Database Replay
• B. using SQL Developer
• C. using Oracle Data Pump
• D. using operating system file copy utilities
• E. using Database Upgrade Assistant
• F. using the CREATE TABLE AS SELECT SQLstatement

Answer: DEF

NEW QUESTION 5
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 6
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

• A. when any archived log from, before, or after the most recent backup is corrupt.
• B. after losing all copies of the control file
• C. after losing an archived log from after the most recent backup
• D. after losing an archived log from before the most recent backup
• E. after losing the SYSTEM tablespace

Answer: DE

NEW QUESTION 7
Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to
recover PDB1 toRestore Point R1. How do you achieve this?

• A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to PDB1.
• B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to PDB1.
• C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to CDB$ROOT.
• D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to CDB$ROOT.
• E. This cannot be done due to the lack of aclean restore point.

Answer: B

NEW QUESTION 8
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 9
Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

• A. Run the SQL Access Advisor.
• B. Run the Memory Advisor for the shared pool.
• C. Run the SQL Tunning Advisor.
• D. Run theMemory Advisor for the Program Global Area.
• E. Run the Memory Advisor for the System Global Area.

Answer: B

NEW QUESTION 10
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 11
Which two are true about automatic block repair? (Choose two.)

• A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
• B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• D. It is not possible for media corrupt blocks.
• E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Answer: BC

NEW QUESTION 12
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 13
Which two are true about RMAN encryption? (Choose two.)

• A. RMAN encryption keys are stored in a database keystore.
• B. RMAN can encrypt the Oracle Database password file.
• C. Dual-mode encrypted backups can be restored only if boththe password and the keystore used for encryption are available.
• D. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
• E. Password encryption can be persistently configured using the CONFIGUREENCRYPTION command.

Answer: CD

NEW QUESTION 14
Examine this output:

Which two are true? (Choose two.)

• A. Any PDB not specified in the plan will be unable to execute statementsin parallel.
• B. PDB3 can use all available parallel execution processes at times.
• C. PDB1 is always limited to 40% of the available system resources regardless of demand.
• D. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Answer: AE

NEW QUESTION 15
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 16
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A. It is integrated with the SQL Access Advisor.
• B. It predicts the impact of system changes on SQL workloadresponse time.
• C. It provides before and after execution statistics for each SQL statement in the analysis task
• D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E. SQL statements that were originally run concurrently are run concurrently by SPA.

Answer: BD

NEW QUESTION 17
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

• A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
• B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
• C. An Oracle database can be restored from backup files copied using O/S utilities.
• D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
• E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
• F. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
• G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

Answer: BDE

NEW QUESTION 18
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A. By default, AWR snapshots are taken every 60 minutes.
• B. Its collection level is determined by the value of theSTATISTICS_LEVEL database parameter.
• C. By default, AWR snapshots are retained for 7 days.
• D. The taking of AWR snapshots can be disabled.
• E. AWR data is stored in the SYSTEM tablespace.

Answer: ABD

NEW QUESTION 19
Examine thisconfiguration:
* 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 3 arelost 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 the database.

• A. 1, 3, 5, 6, 10
• B. 1, 3, 5, 8, 6, 10
• C. 1, 3, 5, 6, 9
• D. 1, 3, 5, 6, 10
• E. 1, 2, 5, 7,4, 10
• F. 1, 3, 5, 7, 10

Answer: D

NEW QUESTION 20
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

• A. Flashback logs areautomatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
• B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
• C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
• D. Flashback logs are monitored for being older than the retentionperiod defined inDB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
• E. Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer: BE

NEW QUESTION 21
Which two are true about OS groups and users for OracleGrid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

• A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• C. The Oracle Grid Infrastructure installation must be owned by the grid user.
• D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
• E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Answer: EF

NEW QUESTION 22
Examine this command:
$ rhpctl move database –sourcehome Oracle_home_path –destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

• A. to switch an existing Oracle Database home to anewer release of Oracle software on the same server
• B. to switch to a read-only Oracle home
• C. to switch back to the previous Oracle home as part of a rollback operation
• D. to switch the Oracle Database home when using a centralized Rapid Home Provisioningserver
• E. to switch to a patched Oracle Database home

Answer: CE

Explanation:
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home. The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image. You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.

NEW QUESTION 23
......