Oracle 1Z0-116 Quiz 1 Topic 4 Questions 1-5

Question: 1

Which statement can be used to force password complexity in the password file?

Aorapwd file=orapwORCL format=12 force-yes

Borapwd file=orapwORCL force=yes format=legacy

Corapwd file=orapwOPCL forcaat=12

Dorapwd file=orapwOBCL forroat=12.2

Show Answer

Question: 2

Database Vault is not used in your installation.

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

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

BIt requires a password to be set.

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

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

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

Show Answer

Question: 3

If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?

Anone of the columns

Bforeign key columns only

Cthe primary and foreign key columns

Dcolumns with any type of constraint

Ethe primary key column only

Show Answer

Question: 4

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?

Ausers granted DV_ACCTMGR and DV_OWNER roles

Busers granted DV_OWNER role

Cusers granted DBA and DV_OWNER roles

Dusers granted DV_ACCTMGR and DBA roles

Show Answer

Question: 5

For which two reasons would you define Network ACLs?

Afor configuring fine-grained access control for users and roles that need to access external network services from the database

Bfor configuring fine-grained access control to Oracle wallets to make HTTP requests that require password or client-certificate authentication

Cto create auditing policies regarding the usage of network services from the database

Dto block network attacks or denial of service attacks directed at the database

Eto Improve the performance of the database applications that require access to remote network services

Show Answer

Oracle 1Z0-116 Quiz:1 Topic:4 Questions:1-5