NEW QUESTION 1
You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?

• A. The event parameter was not set.
• B. The sql_trace parameter is set to false.
• C. Enterprise Manager was not used.
• D. The statistics_level parameter is set to basic.
• E. The timed_statistics parameter is set to false.

Answer: D

NEW QUESTION 2
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

• A. The backup must be performed in MOUNT state.
• B. The tablespace must be taken offline.
• C. All files must be backed up as backup sets.
• D. The database must be backed up as an image copy.

Answer: C

NEW QUESTION 3
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the local user B_ADMIN have only the CONNECT privilege.
You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
You then execute the commands:

Which two statements are true? (Choose two.)

• A. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
• B. B_ADMIN can create and select any table in both the root container and HR_PDB.
• C. C##ADMIN can create and select any table in the root container and all the PDBs.
• D. B_ADMIN can create and select any table only in HR_PDB.
• E. The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.

Answer: CD

NEW QUESTION 4
Which three RMAN persistent settings can be set for a database? (Choose three.)

• A. backup retention policy
• B. default backup device type
• C. default section size for backups
• D. default destinations for backups
• E. multiple backup device types for a single backup

Answer: ABD

NEW QUESTION 5
Your database is running in ARCHIVELOG mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in NOMOUNT state. Identify the required steps in the correct order.

• A. 1, 2, 5, 3, 6, 4
• B. 1, 2, 3, 5, 6, 4
• C. 2, 1, 5, 7, 3, 4
• D. 2, 1, 5, 6, 7, 4, 3

Answer: C

NEW QUESTION 6
You are administering a database that supports data warehousing workload and is running in NOARCHIVELOG mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in NOMOUNT state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the RESETLOG option.
10. Recover the database with the NOREDO option.
11. Recover the data file with the NOREDO option. Identify the required steps in the correct order.

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

Answer: C

NEW QUESTION 7
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

• A. tracking the most recent read time for a table segment in a user tablespace
• B. tracking the most recent write time for a table segment in a user tablespace
• C. tracking insert time by row for table rows
• D. tracking the most recent write time for each block in a table segment
• E. tracking the most recent read time for a table segment in the sysaux tablespace
• F. tracking the most recent write time for a table segment in the sysaux tablespace

Answer: ABD

NEW QUESTION 8
Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.)

• A. A base recovery catalog must exist.
• B. The owner of the VPC cannot own recovery catalog.
• C. At least one target database should be registered in the recovery catalog.
• D. The REGISTER DATABASE privilege should be granted to the virtual catalog owner.
• E. The DBA role must be granted to the virtual catalog owner.

Answer: ABE

NEW QUESTION 9
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem? (Choose two.)

• A. Enable temporary undo for the database.
• B. Enable undo retention guarantee.
• C. Increase the size of the redo log buffer.
• D. Enable Automatic Memory Management (AMM).
• E. Increase the size of the temporary tablespace.

Answer: AE

NEW QUESTION 10
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SGA.
• B. Use emergency monitoring to fetch data directly from SGA for analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E. Run ADDM in diagnostic mode.

Answer: B

NEW QUESTION 11
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

• A. The password for the encryption must be set up.
• B. Oracle wallet for the encryption must be set up.
• C. All the tablespaces in the database must be encrypted.
• D. Oracle Database Vault must be enabled.

Answer: B

NEW QUESTION 12
You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH ‘/disk1/backups’;
Which statement is true?

• A. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
• B. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.
• C. It lists all data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the/disk1/backups directory and its subdirectories.
• D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

Answer: D

Explanation: If you have data file copies, backup pieces, or archived logs on disk, then you can catalog them in the recovery catalog with the CATALOG command.
The following command catalogs all files in all of these directories, because /disk1/backups is a prefix for the paths for all of these directories:
CATALOG START WITH '/disk1/backups';
To catalog only backups in the /disk1/backups directory, the correct command is as follows: CATALOG START WITH '/disk1/backups/';
References: https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm

NEW QUESTION 13
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH; SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines= TRUE SCOPE = BOTH; SQL> CONN sys/oracle _4U@cdbl AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baseline=TRUE SCOPE=BOTH; Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?

• A. It gives an error because it cannot be set for the root database.
• B. It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
• C. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
• D. It is set to TRUE for the root database and all the PDBs, but is effective only when the CDB is restarted and the PDBs are reopened.

Answer: B

NEW QUESTION 14
Which three statements are true about compression of backup sets? (Choose three.)

• A. Compressed backups can only be written to media.
• B. Binary compression creates performance overhead during a backup operation.
• C. Unused blocks below the high-water mark are not backed up.
• D. Compressed backups cannot have section size defined during a backup operation.
• E. It works only for locally managed tablespaces.

Answer: BCE

NEW QUESTION 15
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A. The ADR base is shared across multiple instances.
• B. The ADR base keeps all diagnostic information in binary format.
• C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
• D. The ADR can be used for problem diagnosis even when the database instance is down.
• E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Answer: AD

NEW QUESTION 16
Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)

• A. Fast Recovery Area should be defined.
• B. Undo retention guarantee should be enabled.
• C. Supplemental logging should be enabled.
• D. Automatic Undo Management should be enabled.
• E. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
• F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Answer: DF

NEW QUESTION 17
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)

• A. A job is specified as part of a program definition.
• B. A program can be used in the definition of multiple jobs.
• C. A program and job can be specified as part of a schedule definition.
• D. A program and schedule can be specified as part of a job definition.
• E. A program and window can be specified as part of a job definition.

Answer: BDE

NEW QUESTION 18
You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.
Which statement is true about the database that is created?

• A. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).
• B. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.
• C. It is created as a PDB that must be plugged into an existing CDB.
• D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

Answer: D

Explanation: The CREATE DATABASE command with the ENABLE PLUGGABLE DATABASE clause indicates that a CDB is being created. The CDB will contain a root (CDB$ROOT) and a seed (PDB$SEED).
References: https://docs.oracle.com/database/121/SQLRF/statements_5005.htm

NEW QUESTION 19
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

• A. A PDB must be in closed state before it can be unplugged.
• B. A PDB must have been opened at least once after creation.
• C. A PDB must be in MOUNT state before it can be unplugged.
• D. PDB data file are automatically removed from disk.
• E. An unplugged PDB can be plugged into the same or another container database (CDB).

Answer: ABE

Explanation: A: To unplug a PDB, you first close it.
E: You can disassociate or unplug a PDB from a CDB and reassociate or plug the PDB into the same CDB or into another CDB.