Which statement can be used to force password complexity in the password file?

• A.orapwd file=orapwORCL force=yes format=legacy
• B.orapwd file=orapwOPCL forcaat=12
• C.orapwd file=orapwOBCL forroat=12.2
• D.orapwd file=orapwORCL format=12 force-yes

Comment: *

Name: *

Email: *

Verification: *

You must redact the salary column of the HR.EMPLOYEES table to display only the number o. Examine this syntax:

Which function type must be Inserted at the end of line #7?

• A.DBMS_RE DACT.RANDOM
• B.DBMS_REDACT.PARTIAL
• C.DBMS_BEDACT.NONE
• D.DBMS REDACT.REGEXP
• E.DBMS_REDACT.FUI,I.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Valid Node Checking for Registration (VNCR)?

• A.It denies Instance registration through IPC.
• B.It can only be used with Oracle RAC.
• C.It restricts specific instances from registering with the Listener.
• D.It enforces the Listener connectivity through TCPS.
• E.It is a replacement for Class of Secure Transport (COST).

Comment: *

Name: *

Email: *

Verification: *

To avoid hard coding passwords in scripts, you have elected to create an external password store-Examine this list of steps:
1. Set the external password store wallet location.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = "/*tc/ORACLE/WALLETS/orcl/external_Btore" SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET 'password'
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_LOGIH KEYSTORE '/etc/0RACLE/WALLETS/orcl/extemal_store';
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_L0GIN KEYSTORE ' /etc/ORACLE/WALLETS/orcl/external_store' ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.

• A.2,3,6,4
• B.1,2,3,4
• C.1,2,5,4
• D.1,2,6,3,5
• E.1,2,3,6,4
• F.2,1,3,4

Comment: *

Name: *

Email: *

Verification: *

Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?

• A.column privileges
• B.user-defined functions
• C.encrypted masks
• D.table privileges
• E.column data
• F.column comments
• G.column names

Comment: *

Name: *

Email: *

Verification: *