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

出題：1

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

A. CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;

B. CREATE CONTEXT global_hr USING hr_pkg;

C. CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;

D. CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;

正解：B 解答を投票する

出題：2

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 解答を投票する

出題：3

An audit administrator wants to log Client Context variables In the audit trail.
Examine this query and the output:

A. AUDIT POLICY hr_emp_pol EXCEPT hr;

B. CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

C. AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

D. AUDIT POLICY hr_emp_pol BY hr;

E. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;

F. AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

G. CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

正解：C 解答を投票する

出題：4

Which two represent the set of users that are never affected by connect command rules?

A. SYSTEM

B. users with the DV_ADMIN role

C. users with the DV_ACCTMGR role

D. SYS

E. users with the DV_OWNER role

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

出題：5

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 解答を投票する

出題：6

Examine this command :
GRANT EXEMPT ACCESS POLICY TO PUBLIC;
Which Transparent Sensitive Data Protection functionality will be affected when this command is executed?

A. Data Redaction

B. Transparent Data Encryption

C. Bind Masking

D. Virtual Private Database

正解：B 解答を投票する

出題：7

You must rekey encrypted sensitive credential data In your database.
You run the command alter database dictionary rekey credentials.
Which three options ate true about the bkkey process?

A. The rekey process only applies to the SYS.SCHEDULES$ credential table.

B. The process of rekeylng does not automatically open the keystore.

C. The rekey process prompts the user to provide a new key algorithm If needed.

D. The credential data encryption process does not de-obfuscate the obfuscated passwords before re-encrypts begin.

E. Credential Data Is automatically encrypted using aes2S6.

F. The rekey process only applies to the sys.ltnks CREDENTUIALS table.

G. Both sys. links and sys . SCHEDULER_CREDENTIAL tables are rekeyed.

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

出題：8

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

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

B. Add or remove participants to or from the realm.

C. Add or remove owners to or from the realm.

D. Grant or revoke realm-secured database roles.

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

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

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

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

出題：9

The listener configuration contains these lines related to Valid Node Checking for Registration (VNCR);

Which two statements are true?

A. Listener listener will allow instance registration from IP address 192.168.20.2.

B. Both parameters cannot be set at the same time so will be Ignored.

C. Listener listener will allow Instance registration from
REGISTRATION_INVITED_NODES_LISTENEP.

D. Listener listener will deny instance registration from IP address 192.168.20.2.

E. Listener listener will only deny instance registration from
REGISTRATION EXCLUDED NODES LISTENER.

正解：C 解答を投票する

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