Online Access Free Oracle.1Z0-116.v2022-11-01.q32 Practice Test (Page 2)

1Z0-116 Exam Question 1

A DBA user created and configured this secure application role:

Why does the error occur?

A.User psmith Is connecting outside of the SYSDATE specified.

B.The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.

C.The HR.ROLE_CHECK procedure must be created without the AUTHID clause.

D.The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

E.The HR_ADMIN role must be granted to user PSMITH.

F.user psmith is connecting remotely.

1Z0-116 Exam Question 2

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.An administrator issues the ALTER SYSTEM FLUSH global context statement.

C.The application context is global.

D.Enterprise User Security is not configured and used for the user.

E.Only DBA users can query SESSION_CONTEXT view contents.

1Z0-116 Exam Question 3

If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?

A.the primary and foreign key columns

B.foreign key columns only

C.columns with any type of constraint

D.the primary key column only

E.none of the columns

1Z0-116 Exam Question 4

Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.
Examine these requirements:
1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.
2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.
3. Audit records are to be collected for every evaluation of the rule set.
Which two options are true when creating the rule set?

A.The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

B.The rule set must be defined as is_static.

C.The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.

D.The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.

E.One rule set contains two rules OR'ed together.

1Z0-116 Exam Question 5

An audit administrator wants to log Client Context variables In the audit trail.
Examine this query and the output:

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

B.CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

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

D.CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

E.AUDIT POLICY hr_emp_pol EXCEPT hr;

F.AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;

G.AUDIT POLICY hr_emp_pol BY hr;

Latest Upload: 166ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 165Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 253EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z0-116 Exam Question 1

1Z0-116 Exam Question 2

1Z0-116 Exam Question 3

1Z0-116 Exam Question 4

1Z0-116 Exam Question 5

Download PDF File