PL/SQL Parameters   «Prev  Next»

SQL Plus Parameter Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. Which of these commands correctly starts SQL*Plus with two parameters?
Please select the best answer.
  A. SQLPLUS PETSTORE/GREATPETS @RATINGS "Betty Grabel" 1996
  B. SQLPLUS SYSTEM/MANAGER @JOEY West Side Story FILM
  C. SQLPLUS SCOTT/TIGER @DISH 01-JUL-99 Health Food is better for you.
  D. SQLPLUS SYSTEM/MANAGER @MAKEUSER user148/pwd200

2. Consider the following SQL*Plus script. Assume that PO_BOX_NO is of NUMBER datatype and LAST_PAY_DATE is of DATE datatype. The script is named SMART.SQL.
Please select the best answer.
  A. Which of the following commands will successfully execute the script?
  B. RUN SMART.SQL 100 11/05/00
  C. START SMART.SQL 10B 01-JUN-99
  D. SQLPLUS SCOTT/TIGER @SMART.SQL 01-JAN-00 1105
  E. START SMART.SQL 159 "11/08/1999"

3. Which of the following statements is true regarding a PL/SQL parameter?
Please select all the correct answers.
  A. The parameter can be named by the procedure that uses it.
  B. The parameter is always character datatype
  C. The parameter can return a value to the calling application
  D. The parameter can be almost any datatype