Free Oracle 1z0-116 Practice Exam with Questions & Answers | Set: 3

The client Identifier is automatically included In the audit trail.

The client Identifier is automatically set by the SQL-Net layer.

A session can have multiple client Identifier values set simultaneously.

The client Identifier cannot be changed during the session.

column names

encrypted masks

column privileges

table privileges

column comments

column data

user-defined functions

SESSION_CSER

CURRENT_OSER

CURRENT SCHEMA

CLIENT_INFO

The target database wallet can be uploaded to the data_pctmp_dtr directory.

The db_link_cred parameter stores the password in a wallet.

The db__link__cred references the credential for the username and password for the target database.

The credential_nam£ parameter automatically creates the credential object store.

The database link port Is not correct because It must be restricted to 1521.

Only data_pump_dir directory can be used to store credential wallets.

It must use only one security check to validate the user.

It must use the invokcr's rights to enable the role,

It must use the deflner's rights to enable the role.

It can Include one or more security checks to validate the user.

It must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.

It can use only the DBMS_SESSION. SET_ROLE procedure.

Its owner SEC_MGR must be granted the execute any procedure role.

SYS logon operations are always audited In unified auditing.

All SYS operations are audited by default in unified auditing.

No SYS operations are audited by default In unified auditing.

SYS logon operations are always audited in mixed mode auditing.

No SYS operations are audited if audit_sys_operations is set on false in unified auditing.

No SYS operations are audited if audit_sys_operations is set on false in mixed mode auditing.

AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES

current:_user( db_name BY hr;

CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

AUDIT POLICY hr_emp_pol BY hr;

CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

AUDIT POLICY hr_emp_pol EXCEPT hr;