DB Creation   «Prev  Next»

Using Oracle SQL*Plus - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following commands will successfully connect to your default Oracle database?
Please select the best answer.
  A. CONNECT INTERNAL
  B. CONNECT DEFAULT
  C. CONNECT ORACLE_SID
  D. CONNECT DEFAULT/INTERNAL

2. Which of the following SQL statements is terminated correctly?
Please select all the correct answers.
  A. select name from v$database/
  B. select name from v$database;
  C. select name from v$database.
  D. select name from v$database
\
  E. select name
from v$database
/

3. You made a mistake typing in a command and now Server Manager is letting you type more commands, but is not executing those commands. What should you do?
Please select the best answer.
  A. Reboot the database server
  B. Press Enter twice to reset the command prompt
  C. Call Oracle Support for help
  D. Type in a semicolon and press Enter

4. You need to log the output of a critical SQL script to a file. Which of the following command pairs will start and stop the logging of output?
Please select the best answer.
  A. SET OUTPUT filename
SET OUTPUT OFF
  B. SET ECHO ON
SET ECHO OFF
  C. SPOOL filename
SPOOL OFF
  D. LOG OUTPUT TO filename
LOG OFF