A. Flush the shared pool.

B. Re-connect the sessions that access objects with redaction policies defined on them.

C. Restart the database instance.

D. Re-enable redaction policies that use FULL data redaction.

E. Re-create redaction policies that use FULL data redaction.

A. Flashback Database can recover a database to the state that it was in before a reset logs operation.

B. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

C. Flashback logs are written sequentially, and are archived.

D. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

E. Flashback Database uses a restored control file to recover a database.

F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

A. creating a database service using Oracle Database Configuration Assistant (DBCA)

B. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

C. creating an Oracle Database service by modifying the SERVICE_NAMES parameter

D. creating a disk group using the CREATE DISKGROUP SQL statement

E. creating a database using the CREATE DATABASE SQL statement

F. creating a database service using DBMS_SERVICE.CREATE_SERVICE

A. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

B. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

C. It is not possible if an archived log is missing.

D. It is performed by the Recovery Writer (RVWR) background process.

E. It is performed automatically while the database remains in MOUNT state. Then the database is opened.

F. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.

A. It is used to explicitly close the open failures.

B. It is used to change failure priority only for the CRITICAL priority.

C. It is used to inform the database about the repair after the repair script executes.

D. It is used to execute the advised repair script.

E. It is used to change failure priority only for HIGH or LOW priorities.

A. The four sections can be created serially.

B. The four sections must be image copies.

C. Each of the file sections must be processed serially.

D. The four sections must be contained in backup sets.

E. The four sections can be created in parallel.

A. when free space in a locally managed tablespace falls below a specified percentage

B. when the number of logons per second exceeds a specific value

C. when the total number of locked user account exceeds a specific value

D. when the total number of logons exceeds a specific value

E. when a resumable statement is suspended

F. when free space in a dictionary managed tablespace falls below a specified percentage

A. If the password file location changes, then the instance must be restarted.

B. Unified Auditing can be configured to audit only events that are issued indirectly by all users

C. Schema Only accounts can be granted administrator privileges.

D. All the Oracle-supplied accounts are Schema Only accounts.

E. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

A. FLASHBACK DATA ARCHIVE

B. FLASHBACK TRANSACTION

C. FLASHBACK TABLE

D. FLASHBACK VERSION QUERY

E. FLASHBACK DATABASE

A. Two application containers can share an application seed PDB.

B. It can contain multiple applications.

C. An application PDB can belong to multiple application containers.

D. It can contain a single application.

E. It must have an application root PDB.

F. It must have an application seed PDB.

A. A backup set may be duplexed with both copies written to disk.

B. A backup set may be duplexed with both copies written to sbt.

C. An image copy on disk can be copied to sbt.

D. A backup set may be duplexed so that one copy is written to sbt and the other to disk.

E. An image copy on sbt can be copied to disk.

F. An image copy on disk can be copied to disk.

A. APP1 can never be unplugged.

B. An application seed PDB is created for APP1.

C. An application root PDB is created for APP1.

D. Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.

E. A default service is created for the application root APP1.

F. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

A. CDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

B. CDB$ROOT, PDB1, PDB2, PDB3, and PDB4

C. CDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

D. CDB$ROOT, PDB2, PDB1, and PDB3

E. CDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4