Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

GIAC Exam GSNA 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?

Show Suggested Answer Hide 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'

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel