You issue the RMAN command:

RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

Which statement is true about the execution of the command?

A. The resulting backupset has backup pieces that cannot exceed 300 MB.

B. RMAN uses multiplexing to perform the backup.

C. RMAN always performs this type of backup in parallel.

D. The backup succeeds only if the USERS tablespace is locally managed.

E. The backup set size is limited to 300 MB.

One of your container databases (CDBs) has five pluggable databases (PDBs).

COMMON_USER_PREFIX is C##.

These commands executed successfully while connected as SYS to CDB$ROOT:

SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;

SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;

SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;

SQL> GRANT c##role1 to system CONTAINER=ALL;

Which three are true? (Choose three.)

A. The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.

B. The C##DBA_ADMIN user is a local user in CDB$ROOT and PDB$SEED.

C. The c##role1 role will always have the same privileges in all current and future PDBs.

D. The C##DBA_ADMIN user is a local user in CDB$ROOT.

E. SYSTEM is able to create views in any PDB as a result of being a DBA user.

F. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.

View the Exhibit showing steps to create a database resource manager plan.

SQL>execute dbms_resource_manager.create_pendingarea();

PL/SQL procedure successfully completed.

SQL>exec dbms_resource_manager, create_consumergroup

(consumer_group=>'OLTP,,comment=>,onlineuser')

PL/SQL procedure successfully completed.

SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio');

SQL>exec

Dbms_resource_manager.create_plan_directive

(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60);

PL/3QLproceduresuccessfullycompleted.

After executing the steps in the exhibit you execute this procedure, which results in an error:

SQL> EXECUTE dbms_resource_manager. validate_pending_area ();

What is the reason for the error?

A. The pending area is automatically submitted when creating plan directives.

B. The procedure must be executed before creating any plan directive.

C. The sys_group group is not included in the resource plan.

D. The other_groups group is not included in the resource plan.

E. Pending areas can not be validated until submitted.

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:

create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time);

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

A. The valid time columns employee_time_start and employee_time_end are automatically created.

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

C. The valid time columns are not populated by the Oracle Server automatically.

D. The valid time columns are visible by default when the table is described.

E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

A. The minimum size for the standard buffer cache is 100 MB.

B. The maximum size for the standard buffer cache is 100 MB.

C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.

D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

E. The minimum size for all buffer caches is 100 MB.