1z1-116試験無料問題集（92題）「Oracle Database Security Administration 認定」

出題：1

For which two reasons would you define Network ACLs?

A. to block network attacks or denial of service attacks directed at the database

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

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

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

E. to create auditing policies regarding the usage of network services from the database

正解：A,B 解答を投票する

出題：2

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

A. Scope

B. Attack Complexity

C. Attack Vector

D. Availability

E. User Interaction

F. Privileges Required

正解：A 解答を投票する

出題：3

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. Enterprise User Security is not configured and used for the user.

C. An administrator issues the ALTER SYSTEM FLUSH global context statement.

D. The set_empno_crx_proc procedure must be in a package.

E. The application context is global.

正解：B,E 解答を投票する

出題：4

Oracle Database Vault is enabled In the database. You have these requirements:
1. Database administrator dbai must export and import data from and to a non-protected schema.
2. Database administrator dba2 must export and Import data from and to a protected schema.
Which three options together satisfy these requirements?

A. Grant become user to dbai.

B. Grant imp_full_database and exp_full_database to dbai and dba2.

C. Grant sysdba to both users.

D. Grant become user to dba2.

E. Grant sysoper to both users.

F. Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.

G. Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.

正解：A,F,G 解答を投票する

出題：5

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?

A. This has no effect on tom's connect attempts.

B. JIM can only connect when In the office on weekends.

C. JIM con never connect.

D. TOM can never connect.

E. This has no effect on JIM'S connection attempts.

正解：B,C 解答を投票する

出題：6

A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table.
Which two arguments are passed to the function?

A. the policy name

B. the schema owning the table

C. the policy group to which the policy belongs

D. the policy type

E. the table name

正解：A,B 解答を投票する

出題：7

Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?

A. column comments

B. encrypted masks

C. column names

D. table privileges

E. user-defined functions

F. column privileges

G. column data

正解：B,D,G 解答を投票する

出題：8

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 contain a SET ROLE statement or a DBMS_SESSION.SET_ROLE call.

C. It can use only the DBMS_SESSION. SET_ROLE procedure.

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

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

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

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

正解：C,D,F 解答を投票する

出題：9

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

Which two options are true?

A. Only data_pump_dir directory can be used to store credential wallets.

B. The db_link_cred parameter stores the password in a wallet.

C. The credential_nam£ parameter automatically creates the credential object store.

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

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

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

正解：B,C 解答を投票する

1z1-116試験無料問題集「Oracle Database Security Administration 認定」