1z0-116 Exam - Free Actual Q&As, Page 1

Oracle 1z0-116 Actual Exam Questions

Last updated on Nov. 17, 2025.

Topic 1 - Exam A

Question #1 Topic 1

Which command avoids displaying the password on the command line or spooling it to a spool file?
A.

SET VERIFY OFF -
ACCEPT password CHAR PROMPT 'Enter password: '
CONNECT jane/&password

B. SET ECHO OFF -
CONNECT jane/&password
C. SET ECHO OFF -
ACCEPT password CHAR PROMPT 'Enter password: '
CONNECT jane/&password
D. SET VERIFY OFF -
ACCEPT password CHAR PROMPT 'Enter password: ' HIDE
CONNECT jane/&password

Reveal Solution Discussion

Correct Answer: D 🗳️

Question #2 Topic 1

You use srvctl in a RAC environment by using Oracle 12.2 default administrative privileges.
Examine these commands and output:

Which privilege is required by the Oracle clusterware agent?

A. SYSRAC
B. SYSASM
C. SYSDBA
D. SYSOPER

Reveal Solution Discussion

Correct Answer: A 🗳️

Question #3 Topic 1

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. SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8 in the sqlnet.ora file of the client application.
C. Client NET.ALLOWED_LOGON_VERSION_CLIENT must be set to a lower value than the server SQLNET.ALLOWED_LOGON_VERSION_SERVER.
D. SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 in the sqlnet.ora of the new database home.

Reveal Solution Discussion

Correct Answer: D 🗳️

Question #4 Topic 1

What is generated when running dbsat collect without requiring encryption for the output file?

A. a zip file containing findings
B. a JSON file containing findings
C. an HTML file containing findings
D. a text file containing findings
E. an Excel spreadsheet file containing findings

Reveal Solution Discussion

Correct Answer: D 🗳️

Viewing page 1 out of 18 pages.

Next Questions

Browse atleast 50% to increase passing rate