PL/SQL Quiz

What is PL/SQL?

• A programming language used to write SQL queries

• A procedural extension of SQL

• A query language used for database management

• A tool for managing database indexes

What is the primary difference between PL/SQL and SQL?

• PL/SQL is a query language; SQL is a procedural language

• PL/SQL allows procedural logic like loops, SQL does not

• SQL is used for database manipulation, PL/SQL is not

• PL/SQL uses more resources than SQL

Which of the following is a feature of PL/SQL?

• It allows complex queries to be written in SQL

• It supports variables, loops, and conditional statements

• It only works with Oracle databases

• It is purely declarative and does not support procedural logic

Which is NOT a fundamental of PL/SQL?

• Blocks of code

• Exception handling

• Use of SQL statements only

• Procedure and function creation

What are reserved words in PL/SQL?

• Keywords that cannot be used as identifiers (like variable names)

• Words used only for string literals

• Words that are not used in the language

• Words that are used for comments

What is the correct structure of a PL/SQL block?

• Header, Declaration, Execution, Exception handling

• Initialization, Execution, Termination

• Declaration, Execution, Exception

• SQL, Control, Finalization

What is an anonymous block in PL/SQL?

• A block without a name that runs only once

• A block with a specific name

• A block with a fixed set of parameters

• A block that stores results in tables

What is a named PL/SQL block?

• A block that contains no SQL queries

• A block with a specific name that can be invoked multiple times

• A block only used for anonymous queries

• A block with no exception handling

What type of comments can be used in PL/SQL?

• Single-line comments only

• Multi-line comments only

• Both single-line and multi-line comments

• Comments are not supported in PL/SQL

Which is a valid PL/SQL data type?

• NUMBER

• CHAR

• VARCHAR2

• All of the above