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

出題：1

You connect to the database Instance over a network to change the password of user scott.
Which two methods avoid the new password for user scott from being compromised by network sniffing?

A. Use ALTER USER SCOTT PASSWORD EXPIRE.

B. Use ALTER USER SCOTT IDENTIFIED BY <password>.

C. Use the SQL"PIus command password SCOTT.

D. Set the server side sqlnet.ora parameter SQLNET.CRYPTO_CHECKSUM_SERVER-REQUESTED.

E. Set the server side sqlnet.ora parameter SQLNET.ENCRYPTION_SERVER=REQUESTED.

F. Use ALTER USER SCOTT IDENTIFIED BY VALUES '<value>*.

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

出題：2

Examine this security parameter and Its value:
SEC_USER_ONAUTHORIZED_ACCESS_BANNER=/opt/oracla/admin/data/unauthwarninq.txt In which file must you include this parameter?

A. tnsnaroes.ora

B. aqlnet.ora

C. server.xml

D. names.ora

E. listener.ora

F. init. era

正解：E 解答を投票する

出題：3

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

出題：4

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

出題：5

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

出題：6

Which two tasks should you perform initially to Implement native network encryption without disrupting client applications?

A. Verify which clients have encrypted connections using the view vSsession_CONNECT_INFO.

B. Upgrade all OCI-basod clients to match the database version.

C. Set the client side sqinec.ora parameter SQLNET.ENCRYPTION _client = required.

D. Modify all JDBC Thin based clients to include network encryption parameters in Java.

E. Set the server side sqinot.ora parameter SQLNET.CRYPTO_CHECKSOM_SERVER - accepted.

F. Configure the listener with an endpoint for protocol TCPS.

G. Set the server side sqinet.oia parameter sqlnet.encryption_server = requested.

正解：F 解答を投票する

出題：7

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

出題：8

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

出題：9

You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?

A. The statement will not audit any users.

B. The statement will only audit sys.

C. The statement must be updated to specify which users to audit.

D. The statement will audit all users.

正解：B 解答を投票する

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