Free Oracle 1z0-116 Practice Exam with Questions & Answers

Examine this statement and its result:

You issue this statement and then restart the database instance:

Which Is true about generated audit records?

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.

Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

You are connected to an Oracle database Instance as a user with privileges to query the hr.employees table.

You are not exempt from any reduction policies.

Examine this query and result:

You implement this Data Redaction policy:

You re-execute the select statement.

What is the result?

A)

B)

C)

D)

E)

You must mask data consistently In three database copies such that data relations across the databases remain In place.

Which Data Masking Format allows this?

You check the Risk Matrix of the latest Critical Patch Update (CPU).

One of the " Common Vulnerability and Exposure’’ reports (CVEs) has Base Score that is above 9 in the Risk Matrix.

Which one is not a supported method to address this CVE?

Examine this security parameter and Its value:

SEC_USER_ONAUTHORIZED_ACCESS_BANNER=/opt/oracla/admin/data/unauthwarninq.txt In which file must you include this parameter?

A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table.

Which two arguments are passed to the function?

Examine these commands and the output used to configure Real Application Security:

What does this output mean?

Examine this command that Is executed:

What is the result?

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?