1Z0-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

Examine this list of capabilities:
1. You can automatically restrict common users from accessing pluggable database (PDB).
2. Enabling Database Vault Operations Control In cdbsroot does not automatically enable It In PDBs.
3. Any common user granted the dv_admin role can enable Database Vault Operations Control.
4. To enable Database Vault Operations Control, use the dbms_macadm.enable_app_protection.
5. Common users' and Invokers' right procedures that must access PDB local data can be added to an exception list.
6. To disable Database Vault Operations Control, use the dbms_macadm.disable_app_protection.
Which statements describe Database Vault Operations Control?

A. 2, 3. 6

B. 3, 5, 6

C. 1, 2, 3, 5

D. 2, 4, 6

E. 1, 4, 6

正解：B 解答を投票する

出題：3

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

出題：4

Which two statements are true about column-level transparent data encryption?

A. It can bo used for tables in encrypted tablcspaces.

B. Column-level encryption keys are not encrypted by the master key.

C. All encrypted columns of a table use the same encryption key.

D. Column level encrypted data remains encrypted in the buffer cache.

E. encrypted columns cannot have an Index.

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

出題：5

Which statement is true about Network ACLs?

A. They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.

B. They ate used to control access by users to external network services and resources from the database through PL/SQL.

C. They are used to configure proxy for PL/SQL network utility packages.

D. They are used to provide access to database packages.

正解：C 解答を投票する

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

出題：6

You must rekey encrypted sensitive credential data In your database.
You run the command alter database dictionary rekey credentials.
Which three options ate true about the bkkey process?

A. The rekey process only applies to the SYS.SCHEDULES$ credential table.

B. The process of rekeylng does not automatically open the keystore.

C. The rekey process prompts the user to provide a new key algorithm If needed.

D. The credential data encryption process does not de-obfuscate the obfuscated passwords before re-encrypts begin.

E. Credential Data Is automatically encrypted using aes2S6.

F. The rekey process only applies to the sys.ltnks CREDENTUIALS table.

G. Both sys. links and sys . SCHEDULER_CREDENTIAL tables are rekeyed.

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

出題：7

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

出題：8

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

A. to authenticate nonprivileged database users remotely

B. to authenticate externally Identified users remotely

C. to authenticate administrative privileged users locally

D. to authenticate administrative privileged users remotely

E. to authenticate nonprivllegcd database users locally

F. to authenticate externally Identified users locally

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

出題：9

Which three are part of an access control list (ACL) when using Real Application Security?

A. data realms

B. policies

C. schemas

D. privileges

E. roles

F. column constraints

G. data realm constraints

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

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