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

出題：1

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

出題：2

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

出題：3

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

出題：4

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

出題：5

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

正解：C 解答を投票する

出題：6

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

出題：7

Which two privileges can be restricted at the column level?

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

出題：8

The utl_http package is used to invoke REST API's to manage Oracle GoldenGate Microservlces Architecture components on host1.
You must use dbms__network_acl_admin to specify a range of ports to be used when connecting to host01.
What three requirements must you consider?

A. The port range must not overlap with any other port ranges for host01.

B. The port range may not include values larger than or equal to 1024.

C. The lower_port may be null but the upper_port must specify a value.

D. The upper_port may be null but the lower_port must specify a value.

E. Both lower_port and upper_port must not be NULL

F. upper_port must be greater than or equal to lower_port.

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

出題：9

Examine this sqlnet.ora file used by a client application: