1Z0-082 practice question 1 of 25

Which three statements are true about using SQL*Plus?

Full set: 142 questions
Answer options
A: It has its own commands that are separate from any SQL statements. Correct answer
B: It must be downloaded from the Oracle Technology Network (OTN).
C: It can run scripts entered at the SQL prompt. Correct answer
D: It can run Recovery Manager (RMAN) commands.
E: It has both command-line and graphical user interfaces (GUI).
F: It can run scripts passed to it by a shell script. Correct answer
Correct Answer:
A. It has its own commands that are separate from any SQL statements.; C. It can run scripts entered at the SQL prompt.; F. It can run scripts passed to it by a shell script.
Explanation

SQLPlus is a command-line interface for Oracle Database. It has its own set of commands, such as DESCRIBE, SET, and SPOOL, which are distinct from SQL statements (A). It can execute SQL scripts either by being invoked from a shell script with the script name as an argument (F) or by using the @ or START command from within a SQLPlus session (C). These features allow for both interactive and automated database operations.

Why Incorrect

B. SQLPlus is included with the Oracle Database or Oracle Client software installation; it is not a separate download.
D. Recovery Manager (RMAN) is a separate utility with its own command-line interpreter and cannot be run from within SQLPlus.
E. SQLPlus is a command-line tool. Oracle SQL Developer is the modern graphical user interface (GUI) for database development.

References

1. Oracle Database SQLPlus® User's Guide, 19c, Chapter 1, "SQLPlus Overview". This chapter introduces SQLPlus as a command-line tool with its own commands.

2. Oracle Database SQLPlus® User's Guide, 19c, Chapter 6, "Running Scripts". This chapter details using the @, @@, and START commands to run scripts from the prompt (C) and how to pass script names as arguments when starting SQLPlus (F).

3. Oracle Database SQLPlus® User's Guide, 19c, Chapter 12, "SQLPlus Command Reference". This chapter lists commands like DESCRIBE and SET, confirming they are specific to SQLPlus and not SQL (A).

Scroll to Top