Table of Contents
Question
Which three statements are true about using SQL*Plus? (Choose three.)
A. It has both command-line and graphical user interfaces (GUI).
B. It must be downloaded from the Oracle Technology Network (OTN).
C. It can run Recovery Manager (RMAN) commands.
D. It has its own commands that are separate from any SQL statements.
E. It can run scripts entered at the SQL prompt.
F. It can run scripts passed to it by a shell script.
Answer
A. It has both command-line and graphical user interfaces (GUI).
D. It has its own commands that are separate from any SQL statements.
E. It can run scripts entered at the SQL prompt.
Explanation
The correct answers are:
A. It has both command-line and graphical user interfaces (GUI).
SQL*Plus is a command-line tool that provides an interface to the Oracle Database. It allows you to execute SQL commands, PL/SQL blocks, and SQL*Plus commands interactively, or from a script. The graphical user interface version of SQL*Plus is called iSQL*Plus, which was a web-based version of SQL*Plus, but it has been deprecated and is no longer used in recent versions of Oracle.
D. It has its own commands that are separate from any SQL statements.
SQL*Plus has its own set of commands that are separate from SQL statements. These commands are used to format query results, control system variables, and manage scripts. Examples of SQL*Plus commands include SET, SHOW, SPOOL, and EXIT.
E. It can run scripts entered at the SQL prompt.
SQL*Plus allows you to run scripts that contain SQL commands, PL/SQL blocks, and SQL*Plus commands. You can enter these scripts directly at the SQL prompt, or you can use the START or @ command to run a script that is stored in a file.
Explanation:
Option B is incorrect because SQL*Plus is included with the Oracle Database software and does not need to be downloaded separately from the Oracle Technology Network (OTN).
Option C is incorrect because SQL*Plus cannot run Recovery Manager (RMAN) commands. RMAN is a separate Oracle tool used for backup and recovery tasks.
Option F is incorrect because while SQL*Plus can execute scripts, it does not directly interact with shell scripts. However, you can call SQL*Plus from a shell script and pass a SQL script to it for execution.
Reference
- SQL*Plus (oracle.com)
- SQL*Plus Commands (oracle.com)
- Instant Client for Microsoft Windows (x64) 64-bit (oracle.com)
- SQL*Plus FAQ – Oracle FAQ (orafaq.com)
- What is Oracle SQL Plus and SQL Plus Usage – Database Tutorials (dbtut.com)
- User’s Guide and Reference (oracle.com)
- What’s New in SQL*Plus? (oracle.com)
- Ever Evolving SQL*Plus 12.2.0.1 Adds New Performance Features (oracle.com)
- Release Notes (oracle.com)
- SQL*Plus® User’s Guide and Reference – Contents (oracle.com)
- SQL*Plus User’s Guide and Reference — Contents (oracle.com)
Oracle Database Administration I 1z0-082 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Oracle Database Administration I 1z0-082 exam and earn Oracle Database Administration I 1z0-082 certification.