Examine these statements which execute successfully:

Which are the two reasons that no rows Are returned from the query?

• A.The set_empno_crx_proc procedure must be in a package.
• B.The application context is global.
• C.Enterprise User Security is not configured and used for the user.
• D.Only DBA users can query SESSION_CONTEXT view contents.
• E.An administrator issues the ALTER SYSTEM FLUSH global context statement.

Comment: *

Name: *

Email: *

Verification: *

Examine the statement:
CREATE BOLE hr_admin IDENTIFIED USING pac_mgr.hr_admin_rola_ch9ck;
Which three are true about the sec_mgr. hr_admin_role_check procedure?

• A.It must use only one security check to validate the user.
• B.It can use only the DBMS_SESSION. SET_ROLE procedure.
• C.Its owner SEC_MGR must be granted the execute any procedure role.
• D.It must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.
• E.It must use the deflner's rights to enable the role.
• F.It must use the invokcr's rights to enable the role,
• G.It can Include one or more security checks to validate the user.

Comment: *

Name: *

Email: *

Verification: *

Examine this sqlnet.ora file used by a client application:

Which three are found in the wallet specified by the directory parameter?

• A.the trusted certificates of the Certification Authority
• B.the user certificate used to uniquely Identify the database service
• C.the user certificate used to uniquely Identify the client application
• D.the trusted certificates of the database service
• E.the username, password, and service name required to connect to the database
• F.the private key of the client application
• G.the private key of the database service

Comment: *

Name: *

Email: *

Verification: *

Examine these commands that execute successfully:

What must be done to allow the index to be used?

• A.Enable encryption hardware acceleration on the CPUs of the machine.
• B.Add the first_name column to the ix_employee Index to Improve its selectivity.
• C.Create a SQL baseline to preserve the execution plan from before the encryption.
• D.Use tublespace encryption instead of column encryption.

Comment: *

Name: *

Email: *

Verification: *

Which three authentication methods are available with Centrally Managed Users (CMU)?

• A.public key Infrastructure (PKT) authentication
• B.smart key authentication
• C.SSH authentication
• D.remote Access Services authentication
• E.kerberos authentication
• F.username/password authentication

Comment: *

Name: *

Email: *

Verification: *