Mock Oracle Test -dbms SQL,pl/SQL

5 Questions
Database Quizzes & Trivia

DBMS SQL,PL/SQL

Please wait...
Questions and Answers
  • 1. 
    A record is a collection of individual fields that represents a row in the table.
    • A. 

      True

    • B. 

      False

  • 2. 
    What is the correct order for steps of initialing the cursor? a.FETCH b.OPEN C.Declare d.close
    • A. 

      A,c,d,b,

    • B. 

      C,b,a,d

    • C. 

      B,d,a,c,

    • D. 

      C,a,d,b,

  • 3. 
    User-defined SUBTYPES  are subtypes based on an existing type.
    • A. 

      True

    • B. 

      False

  • 4. 
    %ROWTYPE is used to declare a variable with the same datatype as a column of a specific table
    • A. 

      True

    • B. 

      False

  • 5. 
    While using FOR loop,Upper_Bound and Lower_Bound must be integers.
    • A. 

      True

    • B. 

      False