Practice with 1Z0-116 Dumps for Oracle Database Security Certified Exam Questions & Answer [Q22-Q37]

4.5/5 - (2 votes)

Practice with 1Z0-116 Dumps for Oracle Database Security Certified Exam Questions & Answer

REAL 1Z0-116 Exam Questions With 100% Refund Guarantee

Getting certified in Oracle 1z1-116 demonstrates a professional’s proficiency in database security management and can help advance their career in the field of database administration. It is especially essential for IT professionals who are responsible for managing sensitive data, such as customer information, financial records, and other critical business data.

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

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

Q24. Examine this query:

Why is this account in this status?

The account uses a global authentication.

The user exceeded the value of FAILED_LOGIN _ATTEMPTS and its password has not been reset yet.

The account has the SYSDBA privilege granted.

The user exceeded the value of PASSWORD_LIFE_TIME and Its password has not been reset yet

The ACCOUNTS_ STATUS column is not updated until the user attempts to log in.

Q25. You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?

CREATE CONTEXT global_hr USING hr_pkg;

CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;

CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;

CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;

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

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

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

Q29. Which two privileges can be restricted at the column level?

SELECT

INSERT

REVOKE

UPDATE

GRANT

DELETE

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

It can bo used for tables in encrypted tablcspaces.

encrypted columns cannot have an Index.

All encrypted columns of a table use the same encryption key.

Column level encrypted data remains encrypted in the buffer cache.

Column-level encryption keys are not encrypted by the master key.

Q31. You grant user JANE the SYSDBA administrative privilege. Which two are true?

User JANE must always connect as SYSDBA to the database instance.

User JANE can grant SYSDBA privilege to roles.

User JANE must use operating system authentication.

User JANE can create objects In sys schema only when connected as SYSDBA.

User JANE acquires the DBA role by default.

User JANE can backup and recover the database.

Q32. Which two statements are true about the Secure External Password Store (SEPS)?

Password credentials are stored on the database server.

Bypassing database authentication adds significant performance benefits to middle-tier applications.

The database does not need to authenticate the connection because the password credentials are stored in a wallet.

Wallet usage secures deployments that rely on password credentials for connecting to databases Instances.

Password rotation policies can be enforced without changing application code.

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

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

Q35. You export and Import a table’s data using Data Pump connected as a user who Is assigned DBA role with default privileges.
There is a data redaction policy on the table.
Which two statements are true about the redaction policy?

The actual data in the tables is copied to the Data Pump target system with the redaction policy applied.

The policy Is not Included In export and Import operation.

The actual data in the tables is copied to the Data Pump target system without being redacted.

The policy Is Included In the export and Import operation but is not applied by default to the objects In the target system.

The policy is included in the export and import operation and applied by default to the objects in the target system.

Q36. You are connected to an Oracle database Instance as a user with privileges to query the hr.employees table.
You are not exempt from any reduction policies.
Examine this query and result:

You implement this Data Redaction policy:

You re-execute the select statement.
What is the result?
A)

B)

C)

D)

E)