[Full-Version] 2022 New PassLeaderVCE 1Z0-116 PDF Recently Updated Questions [Q35-Q55]

4/5 - (1 vote)

[Full-Version] 2022 New PassLeaderVCE 1Z0-116 PDF Recently Updated Questions

1Z0-116 Exam with Guarantee Updated 92 Questions

NO.35 Which CVSS Version 3.1 metric indicates how close an attacker needs to be to the vulnerable component?

Privileges Required

User Interaction

Attack Vector

Scope

Availability

Attack Complexity

NO.36 Examine these commands and the output used to configure Real Application Security:

What does this output mean?

You treated an access control list that references a non-existent policy.

You created an access control list that references a non-existent realm.

You created a policy that references a non-existent access control list.

You created a realm and an access control list that reference a non-existent policy.

You created a policy that references a non-existent realm.

You created a realm that references a non-existent policy.

NO.37 Which two authorization rights does a Database Vault realm owner have that a realm participant does not have?

Add or remove realm-protected objects to or from the reaim.

Grant or revoke privileges on realm-protected objects to or from other users.

Add or remove realm-secured database roles to or from the realm.

Grant or revoke system privileges to access objects protected by the realm.

Add or remove participants to or from the realm.

Add or remove owners to or from the realm.

Grant or revoke realm-secured database roles.

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

level and group

level, compartment, and group

compartment

group

level

compartment and group

level and compartment

NO.39 When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?

You do not have select privileges on this database view.

The master key has been corrupted.

The key store is not open.

The master key has not been created.

This is expected behavior for this view.

NO.40 Which two are true about Database Privilege Analysis?

It can be used after you install the Oracle Database without any additional database configuration steps.

It must have the Database Vault option enabled.

Privilege analysis data for dropped objects are kept.

If a privilege is captured during run time, it is saved under the run-time capture name.

It shows the grant paths to the privileges and suggests which grant path to keep.

It cannot be used to capture the privileges that have been exercised on precompiled database objects.

NO.41 Examine this configuration and requirement:
1. The hr user created a private database link in the pdb2 pluggable database linking to the hr schema In the PDBl pluggable database.
2. Other users in pdb2 must query the remote HR.EMPLOYEES table In PDBI using this database link.
Which two operations together ensure that the database link provides access only to the HR.EMPLOYEES table in the PDBI pluggable database?

Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.

Grant other users access to the database link in the PDBI pluggable database.

Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.

Grant other users access to the database link In the PDB2 pluggable database.

Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .

NO.42 Which two privileges can be restricted at the column level?

SELECT

INSERT

REVOKE

UPDATE

GRANT

DELETE

NO.43 Examine this code which executes successfully:

If the IN_OFFICE_ON_WEEKEND rule set returns true for an attempt to connect from Inside the office on weekends, which two are true about the effects of this configuration?

JIM con never connect.

This has no effect on tom’s connect attempts.

TOM can never connect.

JIM can only connect when In the office on weekends.

This has no effect on JIM’S connection attempts.

NO.44 The sqinet.oia file on the client contains this parameter setting:
SQLNET.ENCRYPTION_CLIEKT = REQUESTED
What value for the parameter sQLNET.ENCRYPTION _server In the sqlnet.ora file on the server will disable Encryption and Data Negotiation?

REQUESTED

ACCEPTED

REQUIRED

REJECTED

NO.45 Which two statements are true about Database Vault rules and rule sets?

You must create a rule set for a rule, before creating the rule.

You con reference Oracle-supplied rules In rule sets that you create.

If a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.

A given rule can be added to only one rule set.

Deleting a rule set also deletes all the rules that have been added to It.

NO.46 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?

users granted DV_ACCTMGR and DV_OWNER roles

users granted DV_OWNER role

users granted DBA and DV_OWNER roles

users granted DV_ACCTMGR and DBA roles

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

none of the columns

foreign key columns only

the primary and foreign key columns

columns with any type of constraint

the primary key column only

NO.48 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?

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

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

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

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

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

It can use only the DBMS_SESSION. SET_ROLE procedure.

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

NO.49 You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?

CREATE CONTEXT global_hr USING hr_pkg;

CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;

CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;

CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;

NO.50 You are Implementing a security policy that makes use of the USERENV namespace.
Which USERRENV value does not change for the duration of a session?

SESSION_CSER

CURRENT_OSER

CURRENT SCHEMA

CLIENT_INFO

NO.51 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?

init. era

listener.ora

aqlnet.ora

tnsnaroes.ora

names.ora

server.xml

NO.52 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?

Use create audit policy.

Use grant audit_admin to Jane;

Use grant audit_viewer to Jane;

Use alter system set AUDIT_SYS_OPERATION= TRUE;

NO.53 Examine these commands and responses:

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

grant EXECUTE ON MARY.PBOC2 Co U1;

grant INHERIT PRIVILEGES ON USER U1 TO MARY;

grant INHERIT PRIVILEGES ON USER MARY TO Ul ;

grant EXECUTE ON Ul.PROC2 TO MARY;

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

orapwd file=orapwORCL format=12 force-yes

orapwd file=orapwORCL force=yes format=legacy

orapwd file=orapwOPCL forcaat=12

orapwd file=orapwOBCL forroat=12.2

NO.55 Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.
Examine these requirements:
1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.
2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.
3. Audit records are to be collected for every evaluation of the rule set.
Which two options are true when creating the rule set?

One rule set contains two rules OR’ed together.

The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.

The rule set must be defined as is_static.

The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.

The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.