Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-116

Oracle 1z0-116 Exam Practice Questions (P. 1)

  • Full Access (72 questions)
  • One Year of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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. A
    SET ECHO OFF -
    CONNECT jane/&password
  2. B
    SET ECHO OFF -
    ACCEPT password CHAR PROMPT 'Enter password: '
    CONNECT jane/&password
  3. C
    SET VERIFY OFF -
    ACCEPT password CHAR PROMPT 'Enter password: ' HIDE
    CONNECT jane/&password

Correct Answer: D ?️

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. A
    SYSRAC
  2. B
    SYSASM
  3. C
    SYSDBA
  4. D
    SYSOPER

Correct Answer: A ?️

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

Correct Answer: D ?️

Question #4
What is generated when running dbsat collect without requiring encryption for the output file?
  1. A
    a zip file containing findings
  2. B
    a JSON file containing findings
  3. C
    an HTML file containing findings
  4. D
    a text file containing findings
  5. E
    an Excel spreadsheet file containing findings

Correct Answer: D ?️

Question #5
Which three statements are true about the DBSAT discoverer utility? (Choose three.)
  1. A
    You are limited to the sensitive categories provided by DBSAT.
  2. B
    You can specify literal strings that are to be searched for in column names, to be discovered as sensitive.
  3. C
    You can specify regular expressions for searching column values in each row, to be discovered as sensitive.
  4. D
    Each finding of sensitive data for a given category is assigned a risk level of high, medium, or low.
  5. E
    The Database Sensitive Data Assessment Report is appended to the Database Security Assessment Report.
  6. F
    You can exclude schemas from the discovery scan.

Correct Answer: BCF ?️

Next Questions

All Pages