Mark works as a Database Administrator for MarLinc Inc. How will he execute a SQL command from the SQL buffer?

The correct answer is B. Enter a semicolon (;) E. Enter a slash (/). SQL buffer stores the most recently used SQL commands and PL/SQL blocks. It does not store the SQL* Plus commands. The SQL buffer can be edited or saved to a file. A SQL command or a PL/SQL block can be executed by entering a semicolon (;) or a slash (/), or by using the RUN…

Database & Application Auditing

Question

Options

AEnter an asterisk (*)
BEnter a semicolon (;)
CPress [ESC] twice
DPress [RETURN] twice
EEnter a slash (/)

How the community answered

(37 responses)

A
11% (4)
B
81% (30)
C
3% (1)
D
5% (2)

Explanation

SQL buffer stores the most recently used SQL commands and PL/SQL blocks. It does not store the SQL* Plus commands. The SQL buffer can be edited or saved to a file. A SQL command or a PL/SQL block can be executed by entering a semicolon (;) or a slash (/), or by using the RUN command at the command prompt. When a semicolon (;) is entered at the end of a command, the command is completed and executed. When a slash (/) is entered on a new line, the command in the buffer is executed. It can also be used to execute a PL/SQL block. The RUN command is used to execute a command in the buffer. A SQL command can be saved in the buffer by entering a blank line.

Topics

#SQL buffer#Oracle SQL#SQL commands#DBA operations

Community Discussion

No community discussion yet for this question.

Full GSNA Practice