Online Access Free 1Z0-116 Exam Questions

You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?

• A.CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;
• B.CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;
• C.CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;
• D.CREATE CONTEXT global_hr USING hr_pkg;

Examine this command:

Which two statements are true?

• A.Opening the software keystore from remote computers is possible.
• B.Opening the software keystore from the local computer is not possible.
• C.Opening the software keystore must always be done manually on the local computer.
• D.Opening the software keystore from remote computers is not possible.
• E.Opening the software keystore from the local computer Is possible.

Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role.
You have not yet configured the database with Enterprise User Security.
You plan to perform these steps:
1. create role GLOBAI._ROI.E identified globally;
2. grant select any table to GLODAL_COLE;
3. grant GLOBAL_ROLE to SCOTT;
What is the result?

• A.The first statement falls because the database Is not set up with Enterprise User Security.
• B.The third statement falls because global roles can be granted only by using a central authority.
• C.All statements succeed even without Enterprise User Security configuration, but the role is not effective.
• D.The second statement falls because granting a global role can be completed only by using a central authority.

Database Vault is not used in your installation.
Why is a conventional secure application role more secure than a normal role?

• A.It can be set only by a package or procedure that is created with deflner's rights.
• B.It can be set only by users with the grant any bole privilege.
• C.It requires a password to be set.
• D.It can be set only by a package or procedure associated with the role definition.
• E.It Is In effect only when configured as a default role for the user.

Which two statements are true about the Secure External Password Store (SEPS)?

• A.Password credentials are stored on the database server.
• B.Password rotation policies can be enforced without changing application code.
• C.Wallet usage secures deployments that rely on password credentials for connecting to databases Instances.
• D.The database does not need to authenticate the connection because the password credentials are stored in a wallet.
• E.Bypassing database authentication adds significant performance benefits to middle-tier applications.