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. You are running SQL*Plus on the database server. Your operating system account is authorized for OS-authenticated SYSDBA access, and your environment identifies the intended local instance. Which command establishes an administrative connection?
Please select the best answer.
  A. CONNECT / AS SYSDBA
  B. CONNECT DEFAULT
  C. CONNECT ORACLE_SID
  D. CONNECT DEFAULT/INTERNAL

2. Assume SQL*Plus uses its default SQL terminator settings. Which examples correctly execute the SELECT statement?
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. While entering an unfinished SQL statement interactively in SQL*Plus, you see a numbered continuation prompt. With SET SQLBLANKLINES OFF, how can you return to the SQL> prompt without executing the statement?
Please select the best answer.
  A. Restart the database instance.
  B. Enter a slash (/) on a line by itself.
  C. Enter a semicolon (;) and press Enter.
  D. Press Enter on an empty continuation line.

4. You need to capture SQL*Plus output from a script in a file named maintenance.log. Which command pair starts and stops spooling?
Please select the best answer.
  A. SET OUTPUT maintenance.log
SET OUTPUT OFF
  B. SET ECHO ON
SET ECHO OFF
  C. SPOOL maintenance.log
SPOOL OFF
  D. LOG OUTPUT TO maintenance.log
LOG OFF