SQL* Plus CLI  «Prev  Next»

SQL*Plus Line Editing - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. You have the following SQL statement in the buffer:
SELECT tuble_name FROM user_tables;
Which of these commands will correct the spelling of the word “table”?
Please select the best answer.
  A. C /tuble_name/ to /table_name/
  B. C /tuble_name/table_name/
  C. R /tuble_name/table_name/
  D. CHG tuble_name,table_name

2. Which of the following would allow you to insert new lines after line 3 of the current SQL statement?
Please select the best answer.
  A. L 3 I
  B. I 3
  C. L 4 I
  D. I /3

3. Which of the following sets of commands could be used to add an ORDER BY clause to this SQL statement:
SELECT table_name
FROM user_tables
Please select all the correct answers.
  A. L
I ORDER BY table_name
  B. L 2
A ORDER BY table_name
  C. L
C /ORDER BY table_name/
  D. /
ORDER BY table_name

4. When you are done editing a statement in the buffer, which of the following commands could you use to execute it?
Please select the best answer.
  A. RUN
  B. @@
  C. /
  D. GO