Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true? (Choose two.)

• A.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
• B.A user belonging to the DSS_QUERIES resource consumer group can create a new session but the session will be queued.
• C.An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
• D.The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
• E.An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true regarding SecureFile lobs? (Choose two.)

• A.Fragmentation is minimized by using variable-sized chunks.
• B.They can be used only for nonpartitioned tables.
• C.They support random reads and writes of encrypted LOB data.
• D.The amount of undo retained is user controlled.

Comment: *

Name: *

Email: *

Verification: *

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, 4, 5, 3, 7, 6, 9, and 8
• B.2, 1, 3, 7, 6, 9, and 8
• C.2, 1, 3, 5, 7, 6, and 8
• D.2, 1, 3, 7, 6, and 8

Comment: *

Name: *

Email: *

Verification: *

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:
SQL> CREATE USER c##a_admin
IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA I00M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

• A.The command gives an error because the container=all clause is missing.
• B.The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.
• C.The command succeeds only if all the PDBs have the users and temp tablespaces.
• D.The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

Comment: *

Name: *

Email: *

Verification: *

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

• A.The PDB is closed and left in the unmount state.
• B.The PDB is placed and left in the mount state.
• C.The command executes only if the common user is granted the set container privilege for the PDB.
• D.The command results in an error because the PDB can be shut down only by a local user.

Comment: *

Name: *

Email: *

Verification: *