Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

• A.PARTIAL redaction is active of the HIREDATE column.
• B.FULL redaction is active on the SAL column
• C.RANDOM redaction is active on the MGR column
• D.RANDOM redaction is active on the HIREDATE column
• E.PARTIAL redaction is active on the MGR column.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Database Configuration Assistant (DBCA)?

• A.It can be used to add a new tablespace.
• B.It can generate SQL database creation scripts.
• C.It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
• D.It can configure Automatic Storage Management (ASM) diskgroups.
• E.It can be used to create a database template from an existing database.

Comment: *

Name: *

Email: *

Verification: *

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

• A.BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• B.BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• C.BACKUP SPFILE SECTION SIZE 1M;
• D.BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• E.BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• F.BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• G.BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Comment: *

Name: *

Email: *

Verification: *

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A.Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• B.Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• C.Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• D.Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• E.Re-createthepasswordfileintheOracleDatabase12cformat. Correct

Comment: *

Name: *

Email: *

Verification: *

Which operating system group is NOT needed to perform an Oracle Database installation?

• A.OSRACDBA
• B.OSOPER
• C.OSASM
• D.OSDBA
• E.OSKMDBA

Comment: *

Name: *

Email: *

Verification: *