Quiz  /  PL/SQL Gate & PSU MCQ Questions With Answers

  • 1. 
    Which of the below are the two types of Blocks

  • Anonymous Block and Named Block
  • Declaration block and Named Block
  • Execution Block and Named Block
  • Exceptional Block and Named Block

  • 2. 
    _________ Block are optional Blocks.

  • Exception Handling
  • Declaration
  • Both A & B
  • None of the above

  • 3. 
    Which of the following returns the current error message text?

  • SQLERRM
  • SQLCODE
  • Both A & B
  • None of the above

  • 4. 
    What is the Full form of DBMS

  • Data Base Management Studies
  • Data Base Mein se
  • Data Base Management System
  • Data Byte Management System

  • 5. 
    The 3 tier architecture consists of

  • Database tier
  • Application Tier
  • (User) Presentation Tier
  • All of the above

  • 6. 
    Oracle predefined errors are NOT associated with specific error codes.

  • True
  • False

  • 7. 
    Which statements execute a sequence of statements multiple times?

  • EXIT
  • LOOP
  • Both A & B
  • None of the above

  • 8. 
    PL_SQL stands for ?

  • Procedural Language, Structured Query Language
  • Programming Language, Standard Query Language
  • Procedural Language, Standard Query Language
  • Programming Language, Structured Query Language

  • 9. 
    Rollback is the type of __________

  • Data Definition Language
  • Data Manipulation Language
  • Data Control language
  • Transaction Control Language

  • 10. 
    PL/SQL has two types of subprograms, procedures and functions. Which subprogram is used to compute a value?

  • Procedure
  • Function
  • Both A & B
  • None of the above

  • 11. 
    Which datatypes are PL/SQL-only datatypes that are more efficient than the SQL datatypes NUMBER or INTEGER for integer arithmetic?

  • PLS_INTEGER
  • NUMBER
  • Both A & B
  • None of the above

  • 12. 
    Which error occurs while the program is running and cannot be detected by the PL/SQL compiler?

  • Syntax error
  • Runtime error
  • Both A & B
  • None of the above

  • 13. 
    What is used in the database for entering data by a user?

  • Excel Sheets
  • Forms
  • SQL software
  • PL SQL Software

  • 14. 
    The name given for Implicit cursor is?

  • PLSQL
  • SQL
  • CURSOR
  • All the above

  • 15. 
    What is a record?

  • Each row in a table is a Record
  • Each column in a table is a Record
  • Every table is a Record
  • Only One name is a Record

  • 16. 
    _________ has the least control of the database

  • Administrators
  • End Users
  • Designers
  • Developers

  • 17. 
    Name 4 attributes of explicit cursors

  • %FOUND,%NOTFOUND,%ROWCOUNT,%ISOPEN
  • %FOUND,%NOTFOUND,%ISCLOSE,%ISOPEN
  • %FOUND,%OPEN,%ROWCOUNT,%ISOPEN
  • None of these
Report Question
warning
access_time
  Time