MENU
Which of the following is used to execute a SQL statement from the SQL buffer?
Suggested Answer: D
Get Premium GSNA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
A SQL statement or a PL/SQL block can be executed by entering a semicolon (;) or a slash (/), or by using the RUN command at SQL prompt.
When a semicolon (;) is entered at the end of a command, the command is completed and executed.
When a slash (/) is entered, 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.
Note: The SQL buffer stores the most recently used SQL commands and PL/SQL blocks. It does not store SQL* Plus commands. It can be
edited or saved to a file.
Note: A SQL command can be saved in the buffer by entering a blank line.
'Understanding SQL COMMAND Syntax'
11 comments · newest first
FE
Felix
11 months ago
I agree, [RETURN] once is the way to go!
HA
Haydee
11 months ago
Wait, can you really execute with a slash?
JA
Jamie
12 months ago
Definitely not the asterisk.
GE
Georgene
12 months ago
I thought it was twice!
AN
Annabelle
12 months ago
Pretty sure it's pressing [RETURN] once.
JU
Julieta
1 year ago
I recall that pressing [RETURN] twice is often used in some SQL environments, but I might be mixing it up with something else.
EL
Elza
1 year ago
I’m a bit confused; I thought pressing [RETURN] once was enough, but now I’m not so sure.
LA
Lashunda
1 year ago
I practiced a similar question, and I feel like entering a slash (/) is the right answer for executing a statement.
NI
Nickolas
1 year ago
I think I remember that executing a SQL statement usually involves pressing [RETURN], but I'm not sure if it's once or twice.
EL
Elliott
1 year ago
Inventory turns seems like it would be most relevant for measuring the efficiency of material control processes. I'll select A as my answer.
MA
Matilda
1 year ago
I think the answer is A. Publishing the workflow seems like the optional step since the other choices like defining activities and approving the workflow seem more core to creating the workflow.