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:
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