Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Oracle Database Security Administration

Last Update 23 hours ago Total Questions : 90

The Oracle Database Security Administration content is now fully updated, with all current exam questions added 23 hours ago. Deciding to include 1z0-116 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our 1z0-116 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these 1z0-116 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Oracle Database Security Administration practice test comfortably within the allotted time.

Question # 11

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?

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;

Question # 12

Examine these statements which execute successfully:

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

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.

Question # 13

The listener configuration contains these lines related to Valid Node Checking for Registration (VNCR);

Which two statements are true?

A.

Both parameters cannot be set at the same time so will be Ignored.

B.

Listener listener will allow instance registration from IP address 192.168.20.2.

C.

Listener listener will allow Instance registration from

REGISTRATION_INVITED_NODES_LISTENEP.

D.

Listener listener will only deny instance registration from

REGISTRATION EXCLUDED NODES LISTENER.

E.

Listener listener will deny instance registration from IP address 192.168.20.2.

Question # 14

Examine the statement:

CREATE BOLE hr_admin IDENTIFIED USING pac_mgr.hr_admin_rola_ch9ck;

Which three are true about the sec_mgr. hr_admin_role_check procedure?

A.

It must use only one security check to validate the user.

B.

It must use the invokcr ' s rights to enable the role,

C.

It must use the deflner ' s rights to enable the role.

D.

It can Include one or more security checks to validate the user.

E.

It must contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.

F.

It can use only the DBMS_SESSION. SET_ROLE procedure.

G.

Its owner SEC_MGR must be granted the execute any procedure role.

Question # 15

Examine this list of capabilities:

1. You can automatically restrict common users from accessing pluggable database (PDB).

2. Enabling Database Vault Operations Control In cdbsroot does not automatically enable It In PDBs.

3. Any common user granted the dv_admin role can enable Database Vault Operations Control.

4. To enable Database Vault Operations Control, use the dbms_macadm.enable_app_protection.

5. Common users ' and Invokers ' right procedures that must access PDB local data can be added to an exception list.

6. To disable Database Vault Operations Control, use the dbms_macadm.disable_app_protection.

Which statements describe Database Vault Operations Control?

A.

3, 5, 6

B.

2, 3. 6

C.

2, 4, 6

D.

1, 4, 6

E.

1, 2, 3, 5

Question # 16

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.

Shuffle

B.

Auto Mask

C.

Array List

D.

Substitute

E.

Random Strings

Question # 17

Which two privileges can be restricted at the column level?

A.

SELECT

B.

INSERT

C.

REVOKE

D.

UPDATE

E.

GRANT

F.

DELETE

Question # 18

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.

init. era

B.

listener.ora

C.

aqlnet.ora

D.

tnsnaroes.ora

E.

names.ora

F.

server.xml

Question # 19

You must rekey encrypted sensitive credential data In your database.

You run the command alter database dictionary rekey credentials.

Which three options ate true about the bkkey process?

A.

Credential Data Is automatically encrypted using aes2S6.

B.

The credential data encryption process does not de-obfuscate the obfuscated passwords before re-encrypts begin.

C.

Both sys. links and sys . SCHEDULER_CREDENTIAL tables are rekeyed.

D.

The rekey process prompts the user to provide a new key algorithm If needed.

E.

The process of rekeylng does not automatically open the keystore.

F.

The rekey process only applies to the sys.ltnks CREDENTUIALS table.

G.

The rekey process only applies to the SYS.SCHEDULES$ credential table.

Question # 20

Using Unified Audit, you must determine who performed an pkan backup ot recovery operations on a database.

You are connected as sysdba.

Which statement(s) achieve this?

A)

B)

C)

D)

E)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

E.

Option E

Go to page: