1z0-116

Review 71 1Z0-116 practice questions with answer explanations and community insights.

Question 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

  1. SET ECHO OFF - CONNECT jane/&password
  2. SET ECHO OFF - ACCEPT password CHAR PROMPT 'Enter password: ' CONNECT jane/&password
  3. SET VERIFY OFF - ACCEPT password CHAR PROMPT 'Enter password: ' HIDE CONNECT jane/&password

Question 2

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?

  1. SYSRAC
  2. SYSASM
  3. SYSDBA
  4. SYSOPER

Question 3

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?

  1. SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home
  2. SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8 in the sqlnet.ora file of the client application.
  3. Client NET.ALLOWED_LOGON_VERSION_CLIENT must be set to a lower value than the server SQLNET.ALLOWED_LOGON_VERSION_SERVER.
  4. SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 in the sqlnet.ora of the new database home.

Question 4

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

  1. a zip file containing findings
  2. a JSON file containing findings
  3. an HTML file containing findings
  4. a text file containing findings
  5. an Excel spreadsheet file containing findings

Question 5

Which three statements are true about the DBSAT discoverer utility? (Choose three.)

  1. You are limited to the sensitive categories provided by DBSAT.
  2. You can specify literal strings that are to be searched for in column names, to be discovered as sensitive.
  3. You can specify regular expressions for searching column values in each row, to be discovered as sensitive.
  4. Each finding of sensitive data for a given category is assigned a risk level of high, medium, or low.
  5. The Database Sensitive Data Assessment Report is appended to the Database Security Assessment Report.
  6. You can exclude schemas from the discovery scan.
We are moving to a new platform

CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.