Mock Oracle Test -dbms SQL,pl/SQL

5 Questions  I  By Pras027
Please take the quiz to rate it.

Database Quizzes & Trivia
DBMS SQL,PL/SQL

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.