GIAC GSNA Exam - Topic 1 Question 19 Discussion

Actual exam question for GIAC's GSNA exam

Question #: 19
Topic #: 1

[All GSNA Questions]

Which of the following is used to execute a SQL statement from the SQL buffer?

AEntering an asterisk (*).

BPressing [RETURN] once.

CPressing [RETURN] twice.

DEntering a slash (/).

EPressing [ESC] twice.

Show Suggested Answer

Suggested Answer: D

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'

by Twana at May 03, 2022, 05:47 PM

Limited Time Offer

25%

Off

Get Premium GSNA Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Felix

4 months ago

I agree, [RETURN] once is the way to go!

upvoted 0 times

...

Haydee

4 months ago

Wait, can you really execute with a slash?

upvoted 0 times

...

Jamie

4 months ago

Definitely not the asterisk.

upvoted 0 times

...

Georgene

4 months ago

I thought it was twice!

upvoted 0 times

...

Annabelle

5 months ago

Pretty sure it's pressing [RETURN] once.

upvoted 0 times

...

Julieta

5 months ago

I recall that pressing [RETURN] twice is often used in some SQL environments, but I might be mixing it up with something else.

upvoted 0 times

...

Elza

5 months ago

I’m a bit confused; I thought pressing [RETURN] once was enough, but now I’m not so sure.

upvoted 0 times

...

Lashunda

5 months ago

I practiced a similar question, and I feel like entering a slash (/) is the right answer for executing a statement.

upvoted 0 times

...

Nickolas

5 months 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.

upvoted 0 times

...

Elliott

5 months 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.

upvoted 0 times

...

Matilda

5 months 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.

upvoted 0 times

...