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

出題：1

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

出題：2

Examine this code which executes successfully:

If the IN_OFFICE_ON_WEEKEND rule set returns true for an attempt to connect from Inside the office on weekends, which two are true about the effects of this configuration?

A. This has no effect on tom's connect attempts.

B. JIM can only connect when In the office on weekends.

C. JIM con never connect.

D. TOM can never connect.

E. This has no effect on JIM'S connection attempts.

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

出題：3

Examine this list:
1. You must monitor access to email column or salary column In the employees table.
2. If any activity is detected, the action must be audited and a notification sent out by email.
3. The database has Unified Auditing enabled.
4. You have created and successfully tested the email sending procedure, sysadmin_fga.emaii._ai.ert.
You create the audit policy:

A user with select privilege on hr.employees executes this :
SELECT email FROM HR.EMPLOYEES;
What will be the result?

A. The query will be executed, an entry will be created In FGA_LOG$ table, and the mall will be sent.

B. The query will be executed, no audit entry will be created but the mall will be sent.

C. The query will be executed, but no audit entry will be created nor any mail sent.

D. The query will be executed, an entry will be created in the unified audit trail, and the mail will be sent.

正解：C 解答を投票する

出題：4

Examine this configuration and requirement:
1. The hr user created a private database link in the pdb2 pluggable database linking to the hr schema In the PDBl pluggable database.
2. Other users in pdb2 must query the remote HR.EMPLOYEES table In PDBI using this database link.
Which two operations together ensure that the database link provides access only to the HR.EMPLOYEES table in the PDBI pluggable database?

A. Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.

B. Grant other users access to the database link In the PDB2 pluggable database.

C. Grant other users access to the database link in the PDBI pluggable database.

D. Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.

E. Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .

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

出題：5

To avoid hard coding passwords in scripts, you have elected to create an external password store-Examine this list of steps:
1. Set the external password store wallet location.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = "/*tc/ORACLE/WALLETS/orcl/external_Btore" SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET 'password'
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_LOGIH KEYSTORE '/etc/0RACLE/WALLETS/orcl/extemal_store';
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT 'TDE_WALLET'
TO LOCAL AUTO_L0GIN KEYSTORE ' /etc/ORACLE/WALLETS/orcl/external_store' ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.

A. 1,2,5,4

B. 1,2,3,6,4

C. 1,2,6,3,5

D. 1,2,3,4

E. 2,1,3,4

F. 2,3,6,4

正解：C 解答を投票する

出題：6

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

出題：7

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

出題：8

Examine these statements which execute successfully:

Which are the two reasons that no rows Are returned from the query?

A. Only DBA users can query SESSION_CONTEXT view contents.

B. Enterprise User Security is not configured and used for the user.

C. An administrator issues the ALTER SYSTEM FLUSH global context statement.

D. The set_empno_crx_proc procedure must be in a package.

E. The application context is global.

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

出題：9

What Is the first step when analyzing security within a database?

A. Mask nonproduction data using Data Masking & Subsetting

B. Deploy Oracle Key Vault

C. Execute Database Security Assessment Tool (DBSAT)

D. Create a Data Redaction Policy for your most sensitive tables

E. Configure and enable Database Vault

F. Encrypt tablespaces using Transparent Data Encryption

正解：F 解答を投票する

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