Difficulty: Easy
Correct Answer: Valid (slash executes the SQL/PLSQL in the buffer)
Explanation:
Introduction / Context: Knowing how SQLPlus executes statements is essential for productivity. One commonly used control is the forward slash (/) typed on a line by itself, which instructs SQLPlus to execute whatever is currently stored in the statement buffer.
Given Data / Assumptions:
Concept / Approach: SQLPlus maintains a buffer of the most recently entered statement or PL/SQL block. A semicolon terminates a SQL statement during entry. The slash on a new line commands SQLPlus to execute the contents of that buffer. This is also how you dispatch a PL/SQL block after its final semicolon. Thus, the description that the “left-leaning slash” executes the buffered statement is correct.
Step-by-Step Solution:
Type a SQL statement and end with a semicolon to place it in the buffer.On a new line, type / and press Enter.SQLPlus executes the buffered text and returns results or messages.For PL/SQL blocks, place a semicolon at the end of the END; line, then type / on a fresh line to execute.Verification / Alternative check: Enter SELECT 1 FROM dual; then type / — the query re-runs without retyping it. Editing the buffer with EDIT and then / re-executes the edited content.
Why Other Options Are Wrong:
Common Pitfalls: Forgetting that / executes the last buffer even if you have typed unrelated lines since; accidentally re-running an old statement.
Final Answer: Valid (slash executes the SQL/PLSQL in the buffer)
Discussion & Comments