[2026] Oracle Database Security Administration - 1Z0-116 무료 시험 문제

문제1

Which two statements are true about Database Vault rules and rule sets?

A. You must create a rule set for a rule, before creating the rule.

B. Deleting a rule set also deletes all the rules that have been added to It.

C. You con reference Oracle-supplied rules In rule sets that you create.

D. A given rule can be added to only one rule set.

E. If a rule set Is disabled. It Is evaluated to true without having Its rules evaluated.

정답: D,E

문제2

Examine this statement and its result:

You issue this statement and then restart the database instance:

Which Is true about generated audit records?

A. They are now written to XML files as well as the database.

B. They now Include all application context attribute values.

C. They now Include SQL statements and any bind variables.

D. Information is now populated in auds .commentstext.

정답: B

문제3

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,6,3,5

B. 1,2,5,4

C. 1,2,3,4

D. 2,1,3,4

E. 2,3,6,4

F. 1,2,3,6,4

정답: A

문제4

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

A. Encrypt tablespaces using Transparent Data Encryption

B. Deploy Oracle Key Vault

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

D. Configure and enable Database Vault

E. Mask nonproduction data using Data Masking & Subsetting

F. Execute Database Security Assessment Tool (DBSAT)

정답: A

문제5

For which two reasons would you define Network ACLs?

A. for configuring fine-grained access control to Oracle wallets to make HTTP requests that require password or client-certificate authentication

B. to Improve the performance of the database applications that require access to remote network services

C. to create auditing policies regarding the usage of network services from the database

D. for configuring fine-grained access control for users and roles that need to access external network services from the database

E. to block network attacks or denial of service attacks directed at the database

정답: D,E

문제6

When creating labels using Oracle Label Security, which is required?

A. group

B. level, compartment, and group

C. level and compartment

D. compartment and group

E. compartment

F. level and group

G. level

정답: G

문제7

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. This has no effect on JIM'S connection attempts.

C. TOM can never connect.

D. JIM con never connect.

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

정답: D,E

문제8

Examine this output:

Which three are true?

A. John can perform backup and recovery operations by using RMAN.

B. John can query dba tables.

C. John must connect as sys to perform backup and recovery operations.

D. John must connect as system to perform backup and recovery operations.

E. John Is not able to perform startup and shutdown operations.

F. John can perform backup and recovery operations by using SQL.

G. John can query other user's data.

정답: B,D,G

문제9

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 other users access to the database link in the PDBI pluggable database.

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

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

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

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

정답: B,D

문제10

Using Unified Audit, you must determine who performed an pkan backup ot recovery operations on a database.
You are connected as sysdba.
Which statement(s) achieve this?
A)

B)

C)

D)

E)

A. Option C

B. Option E

C. Option D

D. Option A

E. Option B

정답: D

Oracle Database Security Administration - 1Z0-116무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트