Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

1z0-116 Oracle Database Security Administration Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Oracle 1z0-116 Oracle Database Security Administration certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Oracle 1z0-116 Premium Access     Download Demo    
Page: 1 / 2
Total 90 questions

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.

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

C.

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

D.

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

E.

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

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?

A.

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

B.

Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server

SQLNET.ALLOWED LOGON. VEBSION .SERVER.

C.

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

D.

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

Examine these statements which execute successfully:

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

A.

Only DBA users can query SESSION_CONTEXT view contents.

B.

An administrator issues the ALTER SYSTEM FLUSH global context statement.

C.

The set_empno_crx_proc procedure must be in a package.

D.

The application context is global.

E.

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

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?

A.

users granted DV_ACCTMGR and DV_OWNER roles

B.

users granted DV_OWNER role

C.

users granted DBA and DV_OWNER roles

D.

users granted DV_ACCTMGR and DBA roles

Which two does the master key encrypt with Transparent Data Encryption?

A.

encrypted columns

B.

encryption wallet

C.

temporary segments

D.

encrypted tablespace keys

E.

encrypted tablespaces

F.

encrypted column keys

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?

A.

the table name

B.

the schema owning the table

C.

the policy type

D.

the policy name

E.

the policy group to which the policy belongs

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?

A.

Grant become user to dbai.

B.

Grant sysoper to both users.

C.

Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.

D.

Grant imp_full_database and exp_full_database to dbai and dba2.

E.

Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.

F.

Grant become user to dba2.

G.

Grant sysdba to both users.

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?

A.

on client side of server B

B.

on client side of server A

C.

on server side of server B

D.

on server side of server A

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?

A.

SESSION_CSER

B.

CURRENT_OSER

C.

CURRENT SCHEMA

D.

CLIENT_INFO

You Issue this statement as user SYS:

audit, context namespace kilimanjaro attributes a, b;

Which is true?

A.

The statement will audit all users.

B.

The statement will not audit any users.

C.

The statement will only audit sys.

D.

The statement must be updated to specify which users to audit.

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.

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

B.

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

C.

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

D.

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

E.

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

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

A.

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

B.

User JANE can grant SYSDBA privilege to roles.

C.

User JANE must use operating system authentication.

D.

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

E.

User JANE acquires the DBA role by default.

F.

User JANE can backup and recover the database.

Examine this sqlnet.ora file used by a client application:

Which three are found in the wallet specified by the directory parameter?

A.

the private key of the database service

B.

the trusted certificates of the database service

C.

the user certificate used to uniquely Identify the database service

D.

the private key of the client application

E.

the username, password, and service name required to connect to the database

F.

the user certificate used to uniquely Identify the client application

G.

the trusted certificates of the Certification Authority

You must disable OS authentication for database administrative users on a RAC database.

Which option must you use to do this?

A.

Set sqlnet.aothentication_sebvices=(NONe» In sqlnet.ora on the database server.

B.

Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.

C.

Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.

D.

Set REMOTE_OS_AUTHENT = FALSE In the init.ora file.

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

A.

CREATE CONTEXT global_hr USING hr_pkg;

B.

CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;

C.

CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;

D.

CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;

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?

A.

All statements succeed even without Enterprise User Security configuration, but the role is not effective.

B.

The third statement falls because global roles can be granted only by using a central authority.

C.

The second statement falls because granting a global role can be completed only by using a central authority.

D.

The first statement falls because the database Is not set up with Enterprise User Security.

Examine this query:

Why is this account in this status?

A.

The account uses a global authentication.

B.

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

C.

The account has the SYSDBA privilege granted.

D.

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

E.

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

Examine this command that Is executed:

What is the result?

A.

The salary column is fine grain audited.

B.

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

C.

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

D.

The salary column is encrypted using TDE column encryption.

E.

The salary column is redacted when queried by database users.

The utl_http package is used to invoke REST API's to manage Oracle GoldenGate Microservlces Architecture components on host1.

You must use dbms__network_acl_admin to specify a range of ports to be used when connecting to host01.

What three requirements must you consider?

A.

The lower_port may be null but the upper_port must specify a value.

B.

The port range must not overlap with any other port ranges for host01.

C.

upper_port must be greater than or equal to lower_port.

D.

The port range may not include values larger than or equal to 1024.

E.

Both lower_port and upper_port must not be NULL

F.

The upper_port may be null but the lower_port must specify a value.

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?

A.

Configure liscener.oia with an endpolnt for tcps

B.

Configure sqinet.ora with parameter sq.lnet.encrypt70N_server

C.

Download the root certificate from the Certificate Authority In Base64 format

D.

Configure sqlnet. ora with parameter tcp . invited_nodes

E.

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

F.

Configure an Oracle wallet using mkstore or Wallet Manager

G.

Configure access control lists using DBMS_NETWORK_ACL._ADMIN

Oracle 1z0-116 Premium Access     Download Demo    
Page: 1 / 2
Total 90 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved