1z1-116 Dumps To Pass Oracle Database Security Exam in One Day (Updated 92 Questions) [Q13-Q32]

NO.13 When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?

NO.14 Examine this statement and its result:

You issue this statement and then restart the database instance:

Which Is true about generated audit records?

NO.15 A database link must be created to connect a source Autonomous Database to target on premises database.
Examine this command:

Which two options are true?

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

NO.17 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?

NO.18 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)

NO.19 Database Vault is not used in your installation.
Why is a conventional secure application role more secure than a normal role?

NO.20 Which two statements are true about Database Vault factors?

NO.21 Oracle Database Vault is enabled In the database. You have these requirements:
1. Database administrator dbai must export and import data from and to a non-protected schema.
2. Database administrator dba2 must export and Import data from and to a protected schema.
Which three options together satisfy these requirements?

NO.22 A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table.
Which two arguments are passed to the function?

NO.23 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?

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

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

NO.26 Database user SCOTT requires the privilege to select from all tables and you decide to configure this using a global role.
You have not yet configured the database with Enterprise User Security.
You plan to perform these steps:
1. create role GLOBAI._ROI.E identified globally;
2. grant select any table to GLODAL_COLE;
3. grant GLOBAL_ROLE to SCOTT;
What is the result?

NO.27 You must disable OS authentication for database administrative users on a RAC database.
Which option must you use to do this?

NO.28 The listener configuration contains these lines related to Valid Node Checking for Registration (VNCR);

Which two statements are true?

NO.29 Examine these commands and responses:

User Karen is an enterprise user.
Which two commands are used to allow this login?

NO.30 You must mask data consistently In three database copies such that data relations across the databases remain In place.
Which Data Masking Format allows this?

NO.31 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.

NO.32 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.