1z1-116 試験問題を無料オンラインアクセス

A DBA user created and configured this secure application role:

Why does the error occur?

• A.The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.
• B.The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
• C.User psmith Is connecting outside of the SYSDATE specified.
• D.The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
• E.The HR_ADMIN role must be granted to user PSMITH.
• F.user psmith is connecting remotely.

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)

• A.Option B
• B.Option E
• C.Option C
• D.Option D
• E.Option A

Which two represent the set of users that are never affected by connect command rules?

• A.users with the DV_ADMIN role
• B.users with the DV_OWNER role
• C.SYS
• D.users with the DV_ACCTMGR role
• E.SYSTEM

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?

• A.Random Strings
• B.Shuffle
• C.Array List
• D.Substitute
• E.Auto Mask

Examine this statement and its result:

You issue this statement and then restart the database instance:

Which Is true about generated audit records?

• A.They are now written to XML files as well as the database.
• B.They now Include SQL statements and any bind variables.
• C.They now Include all application context attribute values.
• D.Information is now populated in auds .commentstext.