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

出題：1

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?

A. users granted DV_ACCTMGR and DBA roles

B. users granted DV_OWNER role

C. users granted DBA and DV_OWNER roles

D. users granted DV_ACCTMGR and DV_OWNER roles

正解：A 解答を投票する

出題：2

Which two statements are true about column-level transparent data encryption?

A. It can bo used for tables in encrypted tablcspaces.

B. Column-level encryption keys are not encrypted by the master key.

C. All encrypted columns of a table use the same encryption key.

D. Column level encrypted data remains encrypted in the buffer cache.

E. encrypted columns cannot have an Index.

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

出題：3

Which type of masking directly masks and subsets data In a nonproduction database with minimal or no Impact on production environments?

A. In-export

B. deterministic

C. in-database

D. heterogeneous

E. conditional format

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

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?

A. CLIENT_INFO

B. SESSION_CSER

C. CURRENT SCHEMA

D. CURRENT_OSER

正解：B 解答を投票する

出題：5

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

A. The key store is not open.

B. The master key has been corrupted.

C. The master key has not been created.

D. You do not have select privileges on this database view.

E. This is expected behavior for this view.

正解：A 解答を投票する

出題：6

Examine these commands that execute successfully:

What must be done to allow the index to be used?

A. Add the first_name column to the ix_employee Index to Improve its selectivity.

B. Use tublespace encryption instead of column encryption.

C. Create a SQL baseline to preserve the execution plan from before the encryption.

D. Enable encryption hardware acceleration on the CPUs of the machine.

正解：D 解答を投票する

出題：7

Database Vault is not used in your installation.
Why is a conventional secure application role more secure than a normal role?

A. It requires a password to be set.

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

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

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

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

正解：C 解答を投票する

出題：8

Examine this command:

Which two statements are true?

A. Opening the software keystore from remote computers is possible.

B. Opening the software keystore from remote computers is not possible.

C. Opening the software keystore must always be done manually on the local computer.

D. Opening the software keystore from the local computer Is possible.

E. Opening the software keystore from the local computer is not possible.

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

出題：9

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?

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

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

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

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

E. Both lower_port and upper_port must not be NULL

F. upper_port must be greater than or equal to lower_port.

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

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