Online Access Free 1Z0-116 Practice Test

You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?

• A.The statement will only audit sys.
• B.The statement will audit all users.
• C.The statement will not audit any users.
• D.The statement must be updated to specify which users to audit.

Which two privileges can be restricted at the column level?

• A.REVOKE
• B.DELETE
• C.GRANT
• D.UPDATE
• E.INSERT
• F.SELECT

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 Is In effect only when configured as a default role for the user.
• D.It can be set only by a package or procedure associated with the role definition.
• E.It requires a password to be set.

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

• A.Password rotation policies can be enforced without changing application code.
• B.Bypassing database authentication adds significant performance benefits to middle-tier applications.
• 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.Password credentials are stored on the database server.

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;
• B.CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;
• C.CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;
• D.CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;