Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

Oracle Database Security Administration Question and Answers

Oracle Database Security Administration

Last Update Apr 29, 2024
Total Questions : 90

We are offering FREE 1z0-116 Oracle exam questions. All you do is to just go and sign up. Give your details, prepare 1z0-116 free exam questions and then go for complete pool of Oracle Database Security Administration test questions that will help you more.

1z0-116 pdf

1z0-116 PDF

$35  $99.99
 Add to Cart
1z0-116 Engine

1z0-116 Testing Engine

$42  $119.99
 Add to Cart
1z0-116 PDF + Engine

1z0-116 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

Which type of attack attempts to find data by repeatedly trying similar SQL with a modified predicate?

Options:

A.  

timing attack

B.  

Inference attack

C.  

data remanence attack

D.  

cache attack

E.  

side-channel attack

F.  

known-plaintext attack

Discussion 0
Questions 2

Which four products, features, or methods can help facilitate compliance with various privacy-related regulatory requirements such as PCI-DSS and the EU GDPR?

Options:

A.  

Data Redaction

B.  

Data Guard

C.  

Real Application Clusters

D.  

Transparent Data Encryption

E.  

Data Masking & Subsetting

F.  

Table Partitioning

G.  

Database Vault

Discussion 0
Questions 3

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.

Discussion 0
Questions 4

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.

Discussion 0
Questions 5

Examine these statements which execute successfully:

Which are the two reasons that no rows Are returned from the query?

Options:

A.  

Only DBA users can query SESSION_CONTEXT view contents.

B.  

An administrator issues the ALTER SYSTEM FLUSH global context statement.

C.  

The set_empno_crx_proc procedure must be in a package.

D.  

The application context is global.

E.  

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

Discussion 0
Questions 6

When creating labels using Oracle Label Security, which is required?

Options:

A.  

level and group

B.  

level, compartment, and group

C.  

compartment

D.  

group

E.  

level

F.  

compartment and group

G.  

level and compartment

Discussion 0
Questions 7

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

Discussion 0
Questions 8

Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role.

You have not yet configured the database with Enterprise User Security.

You plan to perform these steps:

1. create role GLOBAI._ROI.E identified globally;

2. grant select any table to GLODAL_COLE;

3. grant GLOBAL_ROLE to SCOTT;

What is the result?

Options:

A.  

All statements succeed even without Enterprise User Security configuration, but the role is not effective.

B.  

The third statement falls because global roles can be granted only by using a central authority.

C.  

The second statement falls because granting a global role can be completed only by using a central authority.

D.  

The first statement falls because the database Is not set up with Enterprise User Security.

Discussion 0
Questions 9

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?

Options:

A.  

Shuffle

B.  

Auto Mask

C.  

Array List

D.  

Substitute

E.  

Random Strings

Discussion 0
Questions 10

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

Options:

A.  

SYS

B.  

users with the DV_ACCTMGR role

C.  

users with the DV_OWNER role

D.  

users with the DV_ADMIN role

E.  

SYSTEM

Discussion 0
Questions 11

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

Discussion 0
Questions 12

Examine these commands that execute successfully:

What must be done to allow the index to be used?

Options:

A.  

Use tublespace encryption instead of column encryption.

B.  

Add the first_name column to the ix_employee Index to Improve its selectivity.

C.  

Create a SQL baseline to preserve the execution plan from before the encryption.

D.  

Enable encryption hardware acceleration on the CPUs of the machine.

Discussion 0
Questions 13

Examine this command that Is executed:

What is the result?

Options:

A.  

The salary column is fine grain audited.

B.  

The salary column is nullified when queried by the database users.

C.  

The bind variables for the salary column are masked In trace files and vS views.

D.  

The salary column is encrypted using TDE column encryption.

E.  

The salary column is redacted when queried by database users.

Discussion 0
1z0-116 Questions Answers | 1z0-116 Test Prep | Oracle Database Security Administration Questions PDF | 1z0-116 Online Exam | 1z0-116 Practice Test | 1z0-116 PDF | 1z0-116 Test Questions | 1z0-116 Study Material | 1z0-116 Exam Preparation | 1z0-116 Valid Dumps | 1z0-116 Real Questions | Oracle Database Security 1z0-116 Exam Questions