PL/SQL Questions Exam Quiz!

10 Questions | Total Attempts: 4229

SettingsSettingsSettings
PL/SQL Questions Exam Quiz! - Quiz

Multiple choice questions. . .


Questions and Answers
  • 1. 
    How many tables may be included with a join?
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      All the above

  • 2. 
    Which of the following SQL functions can operate on any data type?
    • A. 

      TO_CHAR

    • B. 

      LOWER

    • C. 

      LPAD

    • D. 

      CEIL

  • 3. 
    Assuming today is Monday, 21 NOV 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;  
    • A. 

      03-NOV-00

    • B. 

      10-NOV-00

    • C. 

      28-NOV-00

    • D. 

      17-NOV-00

  • 4. 
    In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?
    • A. 

      NULL

    • B. 

      0

    • C. 

      Results in a compilation error

    • D. 

      An exception will be raised

  • 5. 
    What is the result if two NULL values are compared to each other?
    • A. 

      True

    • B. 

      False

    • C. 

      Undefined

    • D. 

      Null

  • 6. 
    PL/SQL raises an exception, in which TWO of the following cases:
    • A. 

      When a SELECT statement returns no rows

    • B. 

      When a SELECT statement returns more than one row

    • C. 

      When the datatypes of SELECT clause and INTO clause do not match

  • 7. 
    Functions for error trapping are contained in which section of a PL/SQL block?
    • A. 

      Header

    • B. 

      Declarative

    • C. 

      Executable

    • D. 

      Exception

  • 8. 
    The SQL WHERE clause
    • A. 

      Limits the column data that are returned

    • B. 

      Limits the row data are returned

    • C. 

      Both A and B are correct.

    • D. 

      Neither a or b is correct

  • 9. 
    Which of the following is true concerning triggers?
    • A. 

      You do not create them with SQL

    • B. 

      They execute against only some applications that access a database

    • C. 

      They have an event, condition, and action

    • D. 

      They cannot cascade (cause another trigger to fire).

  • 10. 
    In this PL/SQL statement, which of the following lines will produce an error?
    • A. 

      Cursor CAPITALS is

    • B. 

      Select CITY, STATE

    • C. 

      Into my_city, my_state

    • D. 

      From CITIES

    • E. 

      Where CAPITAL = 'Y'

    • F. 

      There are no errors in these statements

Back to Top Back to top