1. Home
  2. Oracle
  3. Oracle Database Security
  4. 1z0-116
  5. Oracle Database Security Administration Questions and Answers

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

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

The utl_http package is used to invoke REST API's to manage Oracle GoldenGate Microservlces Architecture components on host1.

You must use dbms__network_acl_admin to specify a range of ports to be used when connecting to host01.

What three requirements must you consider?

Options:
A.

The lower_port may be null but the upper_port must specify a value.

B.

The port range must not overlap with any other port ranges for host01.

C.

upper_port must be greater than or equal to lower_port.

D.

The port range may not include values larger than or equal to 1024.

E.

Both lower_port and upper_port must not be NULL

F.

The upper_port may be null but the lower_port must specify a value.

Questions # 12:

Which two are true about auditing in an Oracle Database?

Options:
A.

SYS logon operations are always audited In unified auditing.

B.

All SYS operations are audited by default in unified auditing.

C.

No SYS operations are audited by default In unified auditing.

D.

SYS logon operations are always audited in mixed mode auditing.

E.

No SYS operations are audited if audit_sys_operations is set on false in unified auditing.

F.

No SYS operations are audited if audit_sys_operations is set on false in mixed mode auditing.

Questions # 13:

You must redact the salary column of the HR.EMPLOYEES table to display only the number o. Examine this syntax:

Question # 13

Which function type must be Inserted at the end of line #7?

Options:
A.

DBMS_BEDACT.NONE

B.

DBMS_REDACT.PARTIAL

C.

DBMS_REDACT.FUI,I.

D.

DBMS REDACT.REGEXP

E.

DBMS_RE DACT.RANDOM

Questions # 14:

Database Vault Is configured and enabled In the Oracle database.

Three users are granted the dba, dv_omneb, and dv_acctmgb roles.

There is a requirement to create a user who can:

1. Connect to the database Instance

2. Select from dictionary views

Which users can complete the operation to meet the requirement?

Options:
A.

users granted DV_ACCTMGR and DV_OWNER roles

B.

users granted DV_OWNER role

C.

users granted DBA and DV_OWNER roles

D.

users granted DV_ACCTMGR and DBA roles

Questions # 15:

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

Options:
A.

orapki

B.

netca

C.

dbca

D.

netmgr

E.

mkstore

F.

owm

Questions # 16:

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 # 17:

A database link must be created to connect a source Autonomous Database to target on premises database.

Examine this command:

Question # 17

Which two options are true?

Options:
A.

The target database wallet can be uploaded to the data_pctmp_dtr directory.

B.

The db_link_cred parameter stores the password in a wallet.

C.

The db__link__cred references the credential for the username and password for the target database.

D.

The credential_nam£ parameter automatically creates the credential object store.

E.

The database link port Is not correct because It must be restricted to 1521.

F.

Only data_pump_dir directory can be used to store credential wallets.

Questions # 18:

Examine this query:

Question # 18

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.

Questions # 19:

Database Vault is not used in your installation.

Why is a conventional secure application role more secure than a normal role?

Options:
A.

It Is In effect only when configured as a default role for the user.

B.

It requires a password to be set.

C.

It can be set only by a package or procedure that is created with deflner's rights.

D.

It can be set only by users with the grant any bole privilege.

E.

It can be set only by a package or procedure associated with the role definition.

Questions # 20:

While upgrading your Oracle database server from 10g to 19c, you want to ensure that the users can still connect with their current passwords after the upgrade.

What do you need to set explicitly for this purpose?

Options:
A.

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home

B.

Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server

SQLNET.ALLOWED LOGON. VEBSION .SERVER.

C.

SQLNET.ALLOWED_LOGON_VERSION_client = 8 in the sqlnec.ora file of the client application.

D.

SQLNET.ALLOWED_LOGON_VERSION_sebveb = 8 In the aqlnec.ora of the new database homo.

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