Mock Oracle Test -DBMS SQL,PL/SQL

5 Questions | Attempts: 3278
Share

SettingsSettingsSettings
Pl SQL Quizzes & Trivia

DBMS SQL,PL/SQL


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

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.