1Z0-116 PDF Dumps Apr 20, 2022 Exam Questions – Valid 1Z0-116 Dumps [Q25-Q44]

1Z0-116 Oracle

admin • April 20, 2022

1Z0-116 PDF Dumps Apr 20, 2022 Exam Questions – Valid 1Z0-116 Dumps [Q25-Q44]

Rate this post

1Z0-116 PDF Dumps Apr 20, 2022 Exam Questions – Valid 1Z0-116 Dumps

Ultimate 1Z0-116 Guide to Prepare Free Latest Oracle Practice Tests Dumps

How much Oracle Database Security Administration Exam Number: 1Z0-116 costs

Types of questions: Performance Based Questions
Examination Name: Oracle Database Security Administration Exam Number: 1Z0-116
Length of Exam: 150 min
No. of Questions: 85 Questions
Passing Score: 60% or higher

NEW QUESTION 25
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?

The target database wallet can be uploaded to the data_pctmp_dtr directory.

The db_link_cred parameter stores the password in a wallet.

The db__link__cred references the credential for the username and password for the target database.

The credential_nam£ parameter automatically creates the credential object store.

The database link port Is not correct because It must be restricted to 1521.

Only data_pump_dir directory can be used to store credential wallets.

NEW QUESTION 26
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?

the table name

the schema owning the table

the policy type

the policy name

the policy group to which the policy belongs

NEW QUESTION 27
Which type of attack attempts to find data by repeatedly trying similar SQL with a modified predicate?

timing attack

Inference attack

data remanence attack

cache attack

side-channel attack

known-plaintext attack

NEW QUESTION 28
Database Vault Is configured and enabled In the Oracle database.
Three users are granted the dba, dv_omneb, and dv_acctmgb roles.
There is a requirement to create a user who can:
1. Connect to the database Instance
2. Select from dictionary views
Which users can complete the operation to meet the requirement?

users granted DV_ACCTMGR and DV_OWNER roles

users granted DV_OWNER role

users granted DBA and DV_OWNER roles

users granted DV_ACCTMGR and DBA roles

NEW QUESTION 29
You configured Kerberos authentication for databases running on servers A and B.
However a database link connecting the database on server A to the database on server B fails with ORA-12638 Credential retrieval failed.
Where must you make a change to sqlnet.ora to allow the database link to use its stored credentials Instead of trying to use Kerberos?

on client side of server B

on client side of server A

on server side of server B

on server side of server A

NEW QUESTION 30
Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

It runs only on UNIX/Linux systems.

It must connect to the database using a SYSDBA connection.

It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.

It runs only on Windows systems.

It must be run on the server that contains the database.

NEW QUESTION 31
While upgrading your Oracle database server from 10g to 19c, you want to ensure that the users can still connect with their current passwords after the upgrade.
What do you need to set explicitly for this purpose?

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home

Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server SQLNET.ALLOWED LOGON. VEBSION .SERVER.

SQLNET.ALLOWED_LOGON_VERSION_client = 8 in the sqlnec.ora file of the client application.

SQLNET.ALLOWED_LOGON_VERSION_sebveb = 8 In the aqlnec.ora of the new database homo.

NEW QUESTION 32
Examine this command that Is executed:

What is the result?

The salary column is fine grain audited.

The salary column is nullified when queried by the database users.

The bind variables for the salary column are masked In trace files and vS views.

The salary column is encrypted using TDE column encryption.

The salary column is redacted when queried by database users.

NEW QUESTION 33
Which three authentication methods are available with Centrally Managed Users (CMU)?

remote Access Services authentication

smart key authentication

public key Infrastructure (PKT) authentication

kerberos authentication

username/password authentication

SSH authentication

NEW QUESTION 34
You are Implementing a security policy that makes use of the USERENV namespace.
Which USERRENV value does not change for the duration of a session?

SESSION_CSER

CURRENT_OSER

CURRENT SCHEMA

CLIENT_INFO

NEW QUESTION 35
You check the Risk Matrix of the latest Critical Patch Update (CPU).
One of the ” Common Vulnerability and Exposure” reports (CVEs) has Base Score that is above 9 in the Risk Matrix.
Which one is not a supported method to address this CVE?

Request a one off patch exception from Oracle Support.

Implement a workaround recommended by Oracle Support.

Upgrade to a new Release.

Install a new Release Update.

Install a new Release Update Revision.

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

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

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

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

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

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

NEW QUESTION 37
Examine these statements which execute successfully:

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

Only DBA users can query SESSION_CONTEXT view contents.

An administrator issues the ALTER SYSTEM FLUSH global context statement.

The set_empno_crx_proc procedure must be in a package.

The application context is global.

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

NEW QUESTION 38
Examine these commands and responses:

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

GRANT CREATE SESSION TO karan;

CREATE USER guest IDENTIFIED BY karen;

CREATE USER karen IDENTIFIED BY guest;

CREATE USER guest IDENTIFIED GLOBALLY as ”;

GRANT CREATE SESSION TO guest;

NEW QUESTION 39
Which three are true concerning command rules?

System privileges override command rules.

If a command rule’s associated rule set evaluation results In an error, the command is not allowed to execute.

A command can have only one command rule that applies to it.

For DML statement command rules, you can specify a wildcard for the object owner.

If a command rule’s associated rule set Is disabled, then the rule set evaluates to true.

For DML statement command rules, you can specify a wildcard for the object name.

Object privileges override command rules.

NEW QUESTION 40
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?

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

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

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

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

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

NEW QUESTION 41
You must redact the salary column of the HR.EMPLOYEES table to display only the number o. Examine this syntax:

Which function type must be Inserted at the end of line #7?

DBMS_BEDACT.NONE

DBMS_REDACT.PARTIAL

DBMS_REDACT.FUI,I.

DBMS REDACT.REGEXP

DBMS_RE DACT.RANDOM

NEW QUESTION 42
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?

Credential Data Is automatically encrypted using aes2S6.

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

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

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

The process of rekeylng does not automatically open the keystore.

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

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

NEW QUESTION 43
What is true about the client identifier?

The client Identifier is automatically included In the audit trail.

The client Identifier is automatically set by the SQL-Net layer.

A session can have multiple client Identifier values set simultaneously.

The client Identifier cannot be changed during the session.