A. Block change tracking must be enabled tor the database.

B. Supplemental logging must be enabled.

C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

D. Recycle bin must be enabled for the database.

E. Undo retention guarantee for the database must be configured.

F. Flashback Database must be enabled.

A. Common users connected to a PDB can exercise privileges across other PDBs.

B. System privileges apply only to the PDB in which they are used.

C. The granter of system privileges must possess the set container privilege.

D. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

E. Local users cannot use local system privileges on the schema of a common user.

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B. If a PDB plan is enabled for a pluggable database, then resources are allocated toconsumergroups across all PDBs in the CDB.

C. In a PDB plan, subplans may be used with up to eight consumer groups.

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

A. 1,2,3,4,7,8

B. 1,2,5,6,7,8

C. 1,2,10,5,6,9

D. 10,3,4,8,9

A. The local listener may spawn a now process and have that new process create a thread

B. The local listener may pass the request to an existing process which in turn will create a thread.

C. Thread creation must be routed through a dispatcher process

D. Each multithreaded Oracle process has an SCMN thread.

E. Each Oracle process runs an SCMN thread.

A. The index is not updated by the DML statements on the indexed table.

B. The index remains invisible.

C. The index becomes unusable but the table is updated by the DML.

D. The index automatically becomes visible in order to have it updated by DML on the table.

E. The index is updated by the DML on the table.

A. 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

B. Taking the target tablespace offline after the segments are moved

C. 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

D. Setting the target tablespace to read-only 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

A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

D. Re-create the password file in the Oracle Database 12c format.

E. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

A. The operating system group that is specified should have the root user as its member.

B. The installation is being performed by the root user.

C. The ORACLE_BASE base parameter is not set.

D. The operating system group that is specified must have permission to write to the inventory directory.

A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
OCP.EXAM_RESULTS; connected as SYSTEM.

B. Recover the table using Automated Tablespace Point In Time Recovery.

C. Recover the table using traditional Tablespace Point In Time Recovery.

D. Recovery the table sing Database Point In Time Recovery.

E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
EXAM_RESULTS; connected as the OCP user.

A. to compare the performance change of top SQL statements for the two runs

B. to check the performance improvement and degradation caused during the change

C. to review the change in the initialization parameters between the two runs

D. to find the resource consumption by SQL statements that are common to both periods

E. to check the database time consumed for the two time periods

F. to review the hardware resources used during the two runs

A. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

B. All the triggers for the table are disabled without changing any of the column names or column types in the table.

C. VPD policies are copied from the original table to the new table during online redefinition.

D. You must copy the VPD policies manually from the original table to the new table during online redefinition.