PL/SQL Assessment Test! Trivia Quiz

10 Questions | Total Attempts: 266

SettingsSettingsSettings
Please wait...
PL/SQL Assessment Test! Trivia Quiz

PL/SQL assessment test trivia quiz! We have a questionnaire designed for system developers who want to test out just how much they know about the system query languages and how to carry them out. If you feel like you are up to the challenge, take up the quiz and share it with others to see how smart you are compared to them on the topic. All the best!


Questions and Answers
  • 1. 
    What is the meaning of PL?
    • A. 

      Project language

    • B. 

      Procedural language

    • C. 

      Purpose language

    • D. 

      Programming language

  • 2. 
    What is an exception in PL/SQL?
    • A. 

      The error handling part of PL/SQL

    • B. 

      The role part of PL/SQL

    • C. 

      The joint part of PL/SQL

    • D. 

      The column part of PL/SQLl

  • 3. 
    What are the two types of exceptions?
    • A. 

      Username and password

    • B. 

      Admin and user

    • C. 

      System and user

    • D. 

      User_defined and predefined

  • 4. 
    Which of these is called a statement in PL/SQL?
    • A. 

      Function

    • B. 

      Table

    • C. 

      Procedure

    • D. 

      Exception

  • 5. 
    All of these rules applies to nulls while making comparisons except...
    • A. 

      Null cannot be equal or unequal to other values

    • B. 

      If a value is null then the expression itself is null

    • C. 

      Null can only be false

    • D. 

      Null can only be true

  • 6. 
    How many data types are available in PL/SQL?
    • A. 

      3

    • B. 

      8

    • C. 

      4

    • D. 

      5

  • 7. 
    What are the two types of cursor in PL/SQL?
    • A. 

      Open and Close cursor

    • B. 

      Implicit and Explicit cursor

    • C. 

      In and Out cursor

    • D. 

      Entry and Exit cursor

  • 8. 
    Which of these activities all rows in a table when enabled?
    • A. 

      Trigger

    • B. 

      Constraints

    • C. 

      Block

    • D. 

      Functions

  • 9. 
    A table which is currently being changed by DML is called a...
    • A. 

      Constraining table

    • B. 

      Cursive table

    • C. 

      Moving table

    • D. 

      Mutating table

  • 10. 
    Variables which are declared in procedure headings and referenced in the procedure body are called...
    • A. 

      Variables

    • B. 

      Procedural variables

    • C. 

      Actual parameters

    • D. 

      Formal parameters

Back to Top Back to top