1z1-116問題集、Oracle実際の試験問題

質問 1

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

A. Bind Masking

B. Transparent Data Encryption

C. Virtual Private Database

D. Data Redaction

正解: B

質問 2

For which two are Oracle Label Security policies not applied?

A. partitioned tables

B. users with the SYSDA privilege other than sys

C. direct path exports

D. objects in the SYS schema

E. conventional path exports

正解: A,D

質問 3

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. CURRENT SCHEMA

B. SESSION_CSER

C. CURRENT_OSER

D. CLIENT_INFO

正解: B

質問 4

To avoid hard coding passwords in scripts, you have elected to create an external password store-Examine this list of steps:
1. Set the external password store wallet location.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = "/*tc/ORACLE/WALLETS/orcl/external_Btore" SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET 'password'
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_LOGIH KEYSTORE '/etc/0RACLE/WALLETS/orcl/extemal_store';
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_L0GIN KEYSTORE ' /etc/ORACLE/WALLETS/orcl/external_store' ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.

A. 1,2,3,4

B. 1,2,5,4

C. 2,1,3,4

D. 1,2,6,3,5

E. 1,2,3,6,4

F. 2,3,6,4

正解: D

質問 5

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.
Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

A. COMMANI>=>' ALTER SYSTEM'

B. CLAUSE_NAME=>'CHECKPOINT'

C. OBJECT_NAME=>'CHECKPOINT'

D. PARAMETER_NAM£=>'CHECKPOINT'

E. COMMAND=>'ALTER'

F. CLAUSE_NAME=>'SYSTEM'

G. OBJECT_OWNER=>'SYS

正解: B,F

質問 6

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

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

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

C. It requires a password to be set.

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

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

正解: E

質問 7

Examine this parameter In sqinet.ora:
SQLNET.ADTHENTICATION_SEBVICES=(NONE)
For which two cases do you need a password file?

A. to authenticate administrative privileged users remotely

B. to authenticate externally Identified users locally

C. to authenticate nonprivileged database users remotely

D. to authenticate nonprivllegcd database users locally

E. to authenticate externally Identified users remotely

F. to authenticate administrative privileged users locally

正解: A,C

質問 8

A DBA user created and configured this secure application role:

Why does the error occur?

A. user psmith is connecting remotely.

B. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

C. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.

D. The HR_ADMIN role must be granted to user PSMITH.

E. User psmith Is connecting outside of the SYSDATE specified.

F. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.

正解: D

質問 9

Which two are true about auditing in an Oracle Database?

A. All SYS operations are audited by default in unified auditing.

B. SYS logon operations are always audited In unified auditing.

C. SYS logon operations are always audited in mixed mode auditing.

D. No SYS operations are audited if audit_sys_operations is set on false in unified auditing.

E. No SYS operations are audited if audit_sys_operations is set on false in mixed mode auditing.

F. No SYS operations are audited by default In unified auditing.

正解: E,F

質問 10

What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?

A. data masking transformations

B. parent/child relationships between the columns holding sensitive information

C. data redaction policies

D. encrypted columns

正解: B

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

Oracle Database Security Administration - 1z1-116 模擬練習