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

出題：1

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

出題：2

Which three authentication methods are available with Centrally Managed Users (CMU)?

A. username/password authentication

B. public key Infrastructure (PKT) authentication

C. smart key authentication

D. remote Access Services authentication

E. SSH authentication

F. kerberos authentication

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

出題：3

As an Autonomous Transaction Processing (ATP) database administrator, you want to extend the storage capacity In the database.
Examine this command and output from the database:

What is the reason for the error?

A. The storage quota has been reached for the ATP database.

B. Database Vault prevents you from executing this command.

C. There is not enough storage available in the ATP database.

D. The create TABLESAPECE statement is not available in ATP.

E. You must be explicitly granted the create TABLESPACE privilege in ATP.

正解：C 解答を投票する

出題：4

Examine these commands and responses:

Which object privilege must be granted to allow execution of the stored procedure?

A. grant INHERIT PRIVILEGES ON USER MARY TO Ul ;

B. grant EXECUTE ON Ul.PROC2 TO MARY;

C. grant EXECUTE ON MARY.PBOC2 Co U1;

D. grant INHERIT PRIVILEGES ON USER U1 TO MARY;

正解：C 解答を投票する

出題：5

A DBA user created and configured this secure application role:

Why does the error occur?

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

B. user psmith is connecting remotely.

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

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

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

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

正解：E 解答を投票する

出題：6

Users and applications must be able to access a web server of type https using database package UTL_HTTP.
Which three are part of the configuration to make this possible?

A. Configure liscener.oia with an endpolnt for tcps

B. Configure sqlnet. ora with parameter tcp . invited_nodes

C. Download the root certificate from the Certificate Authority In Base64 format

D. Configure sqinet.ora with parameter sq.lnet.encrypt70N_server

E. Download the trusted certificate of the web server in Base64 format a

F. Configure access control lists using DBMS_NETWORK_ACL._ADMIN

G. Configure an Oracle wallet using mkstore or Wallet Manager

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

出題：7

Which two privileges can be restricted at the column level?

A. UPDATE

B. REVOKE

C. GRANT

D. SELECT

E. DELETE

F. INSERT

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

出題：8

The sqinet.oia file on the client contains this parameter setting:
SQLNET.ENCRYPTION_CLIEKT = REQUESTED
What value for the parameter sQLNET.ENCRYPTION _server In the sqlnet.ora file on the server will disable Encryption and Data Negotiation?

A. ACCEPTED

B. REQUESTED

C. REJECTED

D. REQUIRED

正解：C 解答を投票する

出題：9

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

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