You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

• A. Increase the number of ASMB processes.
• B. Increase the number of DBWR_IO_SLAVES in the ASM instance.
• C. Specify the statement that adds the disk back to the disk group.
• D. Increase the value of the ASM_POWER_LIMIT parameter.
• E. Set the DISK_REPAIR_TIME disk attribute to a lower value.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?

• A. The user can connect to the root and all PDBs.
• B. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.
• C. The user can connect only to the root database.
• D. The user cannot connect any database because the CONTAINER clause is missing.

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?

• A. It fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.
• B. It executes successfully but neither tablespace nor the data file is created.
• C. It fails and reportsan error because the CONTAINER=ALL clause is not specified in the command.
• D. It falls and reports an error because there can be only one undo tablespace in a CDB.
• E. It executes successfully and creates an UNDO tablespace in HR_PDB.

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?

• A. Setting the target tablespace to read-only after the segments are moved
• B. 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
• C. 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
• D. 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 TBS PERCENT USED
• E. Taking the target tablespace offline after the segments are moved

The following parameter are set for your Oracle 12c database instance:

You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK
function.
3. Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK
function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK
function.
Identify the correct sequence of steps:

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