NEW QUESTION 1
You want to export the pluggable database (PDB) HR_PDB1 from the multitenant container database (CDB) CDB1 and import it into the CDB2 CDB as the EMP_PDB1 PDB.
Examine the list of possible steps required to perform the task:
1. Create a PDB named EMP_PDB1.
2. Export the HR_PDB1 PDB by using the FULL clause.
3. Open the EMP_PDB1 PDB.
4. Mount the EMP_PDB1 PDB.
5. Synchronize the EMP_PDB1 PDB in restricted mode.
6. Copy the dump file to the Data Pump directory.
7. Create a Data Pump directory in the EMP_PDB1 PDB.
8. Import data into EMP_PDB1 with the FULL and REMAP clauses.
9. Create the same tablespaces in EMP_PDB1 as in HR_PDB1 for new local user objects. Identify the required steps in the correct order.

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

Answer: C

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

• A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
• B. It creates a file that contains the SQL statement, which is required to re-create the control file.
• C. It updates the alert log file with the location and contents of the control file.
• D. It creates a binary backup of the control file.

Answer: B

NEW QUESTION 3
A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2. Issue ALTER SYSTEM SET CONTROL_FILES= ‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,
/u01/app/oracle/oradata/cdb1/disk2/control02, ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’ SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’;.
4. Copy the control file from the existing location to ‘/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.

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

Answer: B

NEW QUESTION 4
You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the CREATE CATALOG command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the IMPORT CATALOG command.
6) Connect to the destination database.
7) Connect as CATALOG to the destination recovery catalog schema. Identify the option with the correct sequence for moving the recovery catalog.

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

Answer: C

NEW QUESTION 5
Which three statements are true about automated maintenance tasks?

• A. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
• B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
• C. They run at predefined time intervals that are intended to occur during a period of low system loads.
• D. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.
• E. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

Answer: ACD

NEW QUESTION 6
Which two statements are true about a common user? (Choose two.)

• A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
• B. A common user with the CREATE USER privilege can create other common users, as well as local users.
• C. A common user can be granted only a common role.
• D. A common user can have a local schema in a PDB.
• E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: BD

NEW QUESTION 7
After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE
------------------------- 0
SQL> EXECDBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full; NUMBER VALUE
------------------------
-1
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero. What must you do to activate the new default value for numeric full redaction?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

Explanation: About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

NEW QUESTION 8
You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0
MEMORY TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true? (Choose two.)

• A. The memory_max_target parameter is automatically set to 500 MB.
• B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
• C. The value of the memory_max_target parameter remains zero for the database instance.
• D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MBrespectively.
• E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer: AD

NEW QUESTION 9
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 10
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?

• A. A custom database template
• B. AData Warehouse database template
• C. Automatic Storage Management (ASM) for storage of data files
• D. A file system for storage of data files

Answer: A

NEW QUESTION 11
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true? (Choose two.)

• A. A resumable statement can be suspended and resumed only once during execution.
• B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
• C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
• D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
• E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Answer: CD

NEW QUESTION 12
In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)

• A. Undo retention guarantee must be enabled.
• B. No other table with the same name should exist in the HR schema.
• C. SCOTT should have the FLASHBACK ANY TABLE privilege.
• D. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
• E. No duplicates of the HR.EMPLOYEES table should exist in the recyclebin of the HR schema.
• F. The recycle bin should be enabled.

Answer: BCF

NEW QUESTION 13
You are administering a multitenant container database (CDB) CDB1 that has multiple pluggable databases (PDBs). As the SYS user on CDB$ROOT, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##ADMIN user that is created in all PDBs? (Choose two.)

• A. It can create only local users in all the PDBs.
• B. It has a common schema for all the PDBs.
• C. It can create common users only when it is logged in to the CDB.
• D. It can create only local users in the CDB.
• E. It can be granted only common roles in the PDBs.

Answer: AC

NEW QUESTION 14
A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;
Which statement is true about the execution of the command?

• A. The backup succeeds only if all the tablespaces are locally managed.
• B. The backup succeeds only if the RMAN default device for backup is set to disk.
• C. The backup fails because you cannot specify section size for a compressed backup.
• D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Answer: D

NEW QUESTION 15
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
• B. Setting the target tablespace to read-only after the segments are moved
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
• D. Taking the target tablespace offline after the segments are moved
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Answer: BC

NEW QUESTION 16
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: B

Explanation: The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin directory.

NEW QUESTION 17
In which three scenarios is media recovery required? (Choose three.)

• A. when a tablespace is accidentally dropped from a database
• B. when archived redo log files are lost
• C. when data files are lost
• D. when one of the online redo log members is corrupted
• E. when all control files are lost

Answer: ACE

NEW QUESTION 18
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

• A. All the read-only tablespaces should be taken offline.
• B. All the read-only tablespaces should be restored separately.
• C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
• D. All the read-only tablespaces should be made online with logging disabled.

Answer: A

NEW QUESTION 19
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D