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

出題：1

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

出題：2

Examine this command:

What masking definitions does it list?

A. All with the name credit and created on databases with name starting with teat.

B. All with the name credit and the commands to deploy them on a database with the name test.

C. All with names starting with credit and created on databases with names starting with test.

D. All with the name credit and the commands to deploy them on all databases with names starting with test.

E. All with names starting with credit and created on any database.

正解：A 解答を投票する

出題：3

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

出題：4

Which two statements are true about the Secure External Password Store (SEPS)?

A. Password rotation policies can be enforced without changing application code.

B. Wallet usage secures deployments that rely on password credentials for connecting to databases Instances.

C. Password credentials are stored on the database server.

D. The database does not need to authenticate the connection because the password credentials are stored in a wallet.

E. Bypassing database authentication adds significant performance benefits to middle-tier applications.

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

出題：5

Which two commands can a user with the syskm privilege execute?

A. SELECT * FROM DBA_TABLESPACES WHERE ENCRYPTED = 'YES*;

B. ALTER DATABASE DICTIONARY REKEY CREDENTIALS;

C. ALTER TABLESPACE APPDATA ENCRYPTION OFFLINE ENCRYPT;

D. ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;

E. SELECT * FROM DBA_OBJECTS;

F. ADMINISTER KEY MANAGEMENT SET KFYSTOBF OPEN IDENTIFIED BY password:

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

出題：6

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

出題：7

Examine these steps:
1. Run the DBSAT Collector
2. Run the DBSAT Discoverer
3. Run the DBSAT Reporter
Identify the minimum required steps for producing a report of schemas with sensitive data.

A. 1,2

B. 2,3

C. 2

D. 1,2,3

正解：D 解答を投票する

出題：8

Which two statements are true about Valid Node Checking for Registration (VNCR)?

A. It can only be used with Oracle RAC.

B. It is a replacement for Class of Secure Transport (COST).

C. It enforces the Listener connectivity through TCPS.

D. It denies Instance registration through IPC.

E. It restricts specific instances from registering with the Listener.

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

出題：9

Examine these commands and responses:

User Karen is an enterprise user.
Which two commands are used to allow this login?

A. GRANT CREATE SESSION TO guest;

B. CREATE USER guest IDENTIFIED GLOBALLY as '';

C. CREATE USER guest IDENTIFIED BY karen;

D. GRANT CREATE SESSION TO karan;

E. CREATE USER karen IDENTIFIED BY guest;

正解：B 解答を投票する

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