Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database Security 1z0-116 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam 1z0-116 Premium Access

View all detail and faqs for the 1z0-116 exam

Go to Exam

810 Students Passed

84% Average Score

94% Same Questions
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

You Issue this statement as user SYS:

audit, context namespace kilimanjaro attributes a, b;

Which is true?

Options:

A.

The statement will audit all users.

B.

The statement will not audit any users.

C.

The statement will only audit sys.

D.

The statement must be updated to specify which users to audit.

Questions # 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.

Questions # 13:

For which two are Oracle Label Security policies not applied?

Options:

A.

partitioned tables

B.

direct path exports

C.

users with the SYSDA privilege other than sys

D.

objects in the SYS schema

E.

conventional path exports

Questions # 14:

Data Masking uses a combination of data patterns to discover sensitive data. Which three items are used?

Options:

A.

column names

B.

encrypted masks

C.

column privileges

D.

table privileges

E.

column comments

F.

column data

G.

user-defined functions

Questions # 15:

Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

Options:

A.

It runs only on UNIX/Linux systems.

B.

It must connect to the database using a SYSDBA connection.

C.

It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.

D.

It runs only on Windows systems.

E.

It must be run on the server that contains the database.

Questions # 16:

Examine this list:

1. You must monitor access to email column or salary column In the employees table.

2. If any activity is detected, the action must be audited and a notification sent out by email.

3. The database has Unified Auditing enabled.

4. You have created and successfully tested the email sending procedure, sysadmin_fga.emaii._ai.ert.

You create the audit policy:

Question # 16

A user with select privilege on hr.employees executes this :

SELECT email FROM HR.EMPLOYEES;

What will be the result?

Options:

A.

The query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.

B.

The query will be executed, an entry will be created In FGA_LOG$ table, and the mall will be sent.

C.

The query will be executed, but no audit entry will be created nor any mail sent.

D.

The query will be executed, no audit entry will be created but the mall will be sent.

Questions # 17:

Examine these commands and responses:

Question # 17

Which object privilege must be granted to allow execution of the stored procedure?

Options:

A.

grant EXECUTE ON MARY.PBOC2 Co U1;

B.

grant INHERIT PRIVILEGES ON USER U1 TO MARY;

C.

grant INHERIT PRIVILEGES ON USER MARY TO Ul ;

D.

grant EXECUTE ON Ul.PROC2 TO MARY;

Questions # 18:

Examine this command:

Question # 18

What masking definitions does it list?

Options:

A.

All with the name credit and the commands to deploy them on all databases with names starting with test.

B.

All with names starting with credit and created on databases with names starting with test.

C.

All with the name credit and created on databases with name starting with teat.

D.

All with names starting with credit and created on any database.

E.

All with the name credit and the commands to deploy them on a database with the name test.

Questions # 19:

User jane must report on who has done RMAN backups on a database that has Unified Auditing enabled.

What is the minimum that must be done to allow JANE to generate these reports?

Options:

A.

Use create audit policy.

B.

Use grant audit_admin to Jane;

C.

Use grant audit_viewer to Jane;

D.

Use alter system set AUDIT_SYS_OPERATION= TRUE;

Questions # 20:

Which two tasks should you perform initially to Implement native network encryption without disrupting client applications?

Options:

A.

Upgrade all OCI-basod clients to match the database version.

B.

Set the server side sqinet.oia parameter sqlnet.encryption_server = requested.

C.

Configure the listener with an endpoint for protocol TCPS.

D.

Verify which clients have encrypted connections using the view vSsession_CONNECT_INFO.

E.

Set the client side sqinec.ora parameter SQLNET.ENCRYPTION _client = required.

F.

Set the server side sqinot.ora parameter SQLNET.CRYPTO_CHECKSOM_SERVER - accepted.

G.

Modify all JDBC Thin based clients to include network encryption parameters in Java.

Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25
ADM-201
Agentforce-Specialist
CMMC-CCP
Data-Cloud-Consultant
PDI
PSE-Strata-Pro-24
Secure-Software-Design
Sharing-and-Visibility-Architect
Workday-Pro-Integrations
ZDTA