CertsTopics Logo

Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database Security 1z0-116 Syllabus Exam Questions Answers

Page: 3 / 3
Total 90 questions
Get 1z0-116 Full Access Download 1z0-116 PDF

Oracle Database Security Administration Questions and Answers

Question 9

Examine this query:

Why is this account in this status?

Options:

A.

The account uses a global authentication.

B.

The user exceeded the value of FAILED_LOGIN _ATTEMPTS and its password has not been reset yet.

C.

The account has the SYSDBA privilege granted.

D.

The user exceeded the value of PASSWORD_LIFE_TIME and Its password has not been reset yet

E.

The ACCOUNTS_ STATUS column is not updated until the user attempts to log in.

Question 10

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?

Options:

A.

One rule set contains two rules OR'ed together.

B.

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

C.

The rule set must be defined as is_static.

D.

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

E.

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

Question 11

You export and Import a table's data using Data Pump connected as a user who Is assigned DBA role with default privileges.

There is a data redaction policy on the table.

Which two statements are true about the redaction policy?

Options:

A.

The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.

B.

The policy Is not Included In export and Import operation.

C.

The actual data in the tables is copied to the Data Pump target system without being redacted.

D.

The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.

E.

The policy is included in the export and import operation and applied by default to the objects in the target system.

Question 12

Which statement is true about Network ACLs?

Options:

A.

They ate used to control access by users to external network services and resources from the database through PL/SQL.

B.

They are used to provide access to database packages.

C.

They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.

D.

They are used to configure proxy for PL/SQL network utility packages.

Page: 3 / 3
Total 90 questions
Get 1z0-116 Full Access Download 1z0-116 PDF