After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)

PL/SQL procedure successfully completed.

SQL> select number_value from redaction_values_for_type_full;

NUMBER VALUE

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

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

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

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

D. Flush the shared pool.

E. Restart the database instance.

You are administering a multitenant container database (CDB).

Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

A. by using the connect statement as a local user having only the set container privilege

B. by using easy connect

C. by using external authentication

D. as a common user with the set container privilege

E. by executing the alter session set container command as a local user

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

B. The command succeeds only if all the PDBs have the users and temp tablespaces.

C. The command gives an error because the container=all clause is missing.

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

Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.

Examine the steps to recover the database:

1.

Restore the control files by using the RMAN restore controlfile command.

2.

Mount the database.

3.

Restore the data files by using the RMAN restore database command.

4.

Open the database with the resetlogs option.

5.

Recover the data files by using the RMAN recover using backup controlfile command.

6.

Start the database instance in nomount state.

7.

Connect to the target database by using a recovery catalog.

8.

Open the database.

9.

Restore the data file.

10.

Recover the data file.

Identify the required steps in the correct order.

A. 7, 6, 1, 2, 3, 5, 4

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

C. 7, 6, 1, 2, 9, 10, 8

D. 7, 6, 1, 2, 9, 10, 4

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases

(PDBs). As the sys user on cdb$root, you execute the commands:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;

SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;

SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;

Which two statements are true about the c##admin user that is created in all PDBs?

A. It can create only local users in all the PDBs.

B. It has a common schema for all the PDBs.

C. It can create common users only when it is logged in to the CDB.

D. It can create only local users in the CDB.

E. It can be granted only common roles in the PDBs.

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.

The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.

You execute the RMAN commands: RMAN> CONNECT CATALOG rc12c/pass12c@catdb12c RMAN> IMPORT CATALOG rc11/pwdcat11@ract11

Which two tasks are performed as part of the import? (Choose two.)

A. All databases registered in the RC11 catalog are registered in the RC12C catalog.

B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

D. Imported databases are unregistered from the RC11 catalog.

E. Recovery catalog is resynchronized with the control files of the registered databases.

What two are the prerequisites for enabling Flashback Database?

A. The database must be in ARCHIVELOG mode

B. The database must be in MOUNT EXCLUSIVE mode

C. The database must be opened in RESTRICTED mode

D. The database instance must be started in the NOMOUNT state

E. The database instance must have the keep buffer pool defined

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

A. Only one nested subplan is allowed per parent plan

B. The plans can be nested up to four levels.

C. Nested plans only control resources used by recursive SQL

D. Nested plans control only the degree of parallelism and I/O requests

E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. A base recovery catalog should exist.

B. The owner of VPC cannot own recovery catalog.

C. At least one target database should be registered in the recovery catalog.

D. The register database privilege should be granted to the virtual catalog owner.

E. The DBA role should be granted to the virtual catalog owner.

Which two are prerequisites for performing Flashback Transaction? (Choose two.)

A. Fast Recovery Area must be enabled for the database

B. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package

C. Undo retention guarantee must be configured for the database

D. A supplemental log must be enabled for the primary key

E. Row movement must be enabled