[Q21-Q45] Pass Your 1z1-116 Exam Easily With 100% Exam Passing Guarantee [2022]

Rate this post

Pass Your 1z1-116 Exam Easily With 100% Exam Passing Guarantee [2022]

1z1-116 Dumps are Available for Instant Access from DumpTorrent

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

Length of Exam: 150 min
Examination Name: Oracle Database Security Administration Exam Number: 1Z0-116
Passing Score: 60% or higher

The benefit in Obtaining the 1Z0-116 Exam Certification

Oracle Database Security expert has more valuable and pertinent organizations that help them in defining profession objectives for themselves
Oracle Database Security expert can give you an edge around then effectively when competitors show up for a new employee screening businesses look to tell something which separates the person to another
Oracle Database Security expert gives functional experience to applicants from every one of the viewpoints to be a capable laborer in the association
Oracle Database Security expert give freedoms to find a new line of work effectively in which they are keen on as opposed to squandering years and ending
Oracle Database Security expert networks give you the correct vocation course than non confirmed as a rule can’t get

Q21. What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?

data redaction policies

data masking transformations

parent/child relationships between the columns holding sensitive information

encrypted columns

Q22. As the SYSKM user you must create the password-based keystore, which will be used for TDE. Examine this list:

Identify the sequence that Oracle uses to search for the keystore and its location.

3,5,2,4,1

1,4,5,2

1,2,5,4

1,2,3,5

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

You do not have select privileges on this database view.

The master key has been corrupted.

The key store is not open.

The master key has not been created.

This is expected behavior for this view.

Q24. 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?

REQUESTED

ACCEPTED

REQUIRED

REJECTED

Q25. 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.

Q26. 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

Q27. 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?

Shuffle

Auto Mask

Array List

Substitute

Random Strings

Q28. A DBA user created and configured this secure application role:

Why does the error occur?

User psmith Is connecting outside of the SYSDATE specified.

The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.

user psmith is connecting remotely.

The HR_ADMIN role must be granted to user PSMITH.

The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.

The HR.ROLE_CHECK procedure must be created without the AUTHID clause.

Q29. 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.

Q30. 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?

Set the server side sqlnet.ora parameter SQLNET.CRYPTO_CHECKSUM_SERVER-REQUESTED.

Use ALTER USER SCOTT PASSWORD EXPIRE.

Set the server side sqlnet.ora parameter SQLNET.ENCRYPTION_SERVER=REQUESTED.

Use ALTER USER SCOTT IDENTIFIED BY VALUES ‘<value>*.

Use ALTER USER SCOTT IDENTIFIED BY <password>.

Use the SQL”PIus command password SCOTT.

Q31. An audit administrator wants to log Client Context variables In the audit trail.
Examine this query and the output:

AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;

CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

AUDIT POLICY hr_emp_pol BY hr;

CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

AUDIT POLICY hr_emp_pol EXCEPT hr;

Q32. 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 .

Q33. Which two statements are true about Database Vault factors?

A factor can reference a function In another schema to compute its value, provided execute privilege Is granted to the sys user.

Changing a factor type can change how factors are evaluated.

You can configure a factor to be evaluated only once per session.

You get an error at the time of factor creation If the retrieval method function you have specified does not exist.

You can use a factor to enforce conditions for a command rule.

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

orapki

netca

dbca

netmgr

mkstore

owm

Q35. 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.

1,2

1,2,3

2,3

Q36. Examine this command:

Which two statements are true?

Opening the software keystore from remote computers is possible.

Opening the software keystore from the local computer Is possible.

Opening the software keystore from remote computers is not possible.

Opening the software keystore must always be done manually on the local computer.

Opening the software keystore from the local computer is not possible.

Q37. Users and applications must be able to access a web server of type https using database package UTL_HTTP.
Which three are part of the configuration to make this possible?

Configure liscener.oia with an endpolnt for tcps

Configure sqinet.ora with parameter sq.lnet.encrypt70N_server

Download the root certificate from the Certificate Authority In Base64 format

Configure sqlnet. ora with parameter tcp . invited_nodes

Download the trusted certificate of the web server in Base64 format a

Configure an Oracle wallet using mkstore or Wallet Manager

Configure access control lists using DBMS_NETWORK_ACL._ADMIN

Q38. 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?

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

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

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

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

Q39. Examine these commands and responses:

Which object privilege must be granted to allow execution of the stored procedure?

grant EXECUTE ON MARY.PBOC2 Co U1;

grant INHERIT PRIVILEGES ON USER U1 TO MARY;

grant INHERIT PRIVILEGES ON USER MARY TO Ul ;

grant EXECUTE ON Ul.PROC2 TO MARY;

Q40. 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.

Q41. Which CVSS Version 3.1 metric indicates how close an attacker needs to be to the vulnerable component?

Privileges Required

User Interaction

Attack Vector

Scope

Availability

Attack Complexity

Q42. Data Masking uses a combination of data patterns to discover sensitive dat a. Which three items are used?

column names

encrypted masks

column privileges

table privileges

column comments

column data

user-defined functions

Q43. Which statement is true about Network ACLs?

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

They are used to provide access to database packages.

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

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

Q44. 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

Q45. 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)