PL/SQL MCQ Quiz

  1. PL/SQL is a completely portable, ________________transaction processing language.
  2. ___________types of literals are available in PL/SQL.
  3. The World SQL stands for -
  4. ____________is not a PL/SQL unit.
  5. It contains all information about the content of the package and the code for the subprograms. it is not true about PL/SQL package.
  6. From the following PL/SQL Delimiters____________symbol is exponentiation operator.
  7. PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content.
  8. PL/SQL stands for -
  9. which of the following datatypes supports PS/SQL ?
  10. which of the following are the features of PL/SQL.
  11. The Advantage of PL/SQL is -
  12. PL/SQL subprograms, unlike anonymous blocks, are compiled each time they are executed.
  13. what is the purpose of triggers ?
  14. __________________you declare an explicit cursor in the PL/SQL language
PL/SQL MCQ

Take PL/SQL Quiz To test your Knowledge

Below are few PL/SQL MCQ test that checks your basic knowledge of PL/SQL. This PL/SQL Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

  • Low-performance
  • high-performance
  • both 1 & 2
  • None of the above
View Answer
  • 2
  • 5
  • 4
  • 6
View Answer
  • Simple Query Language
  • Structured Query Language
  • Structured Query List
  • None of these
View Answer
  • Type
  • Table
  • Trigger
  • none
View Answer
  • ~=
  • <>
  • **
View Answer
  • Procedural Language/SQL
  • Programming Language/SQL
  • Portable Language/SQL
  • none of these
View Answer
  • Scalar datatype
  • Composite datatype
  • both 1 & 2
  • None of the above
View Answer
  • It offers extensive error checking
  • It offers numerous data types.
  • It offers a variety of programming structures.
  • All of the mentioned
View Answer
  • Applications written in PL/SQL are fully portable.
  • PL/SQL provides high security level.
  • PL/SQL provides access to predefined SQL packages.
  • All of the mentioned
View Answer
  • Enforcing referential integrity
  • Synchronous replication of tables
  • Preventing invalid transactions
  • All of the mentioned above
View Answer
  • In the PL/SQL declaration section
  • In the PL/SQL working storage sectio
  • In the PL/SQL exception section
  • None of the above
View Answer
  • SQL statements
  • Built-in SQL functions
  • PL/SQL functions invoked from SQL statements
  • All of the above
View Answer
  • A Collection
  • A Scalar
  • Both A & B
  • None of the above
View Answer
  • Procedure
  • Function
  • Both A & B
  • All of the above
View Answer
  • Procedure
  • Function
  • Both A & B
  • All of the above
View Answer