Multiple choice

Which of the following is NOT a difference between SQL and PL/SQL ?

  1. SQL is declarative, while PL/SQL is procedural.

  2. SQL is used to write queries, whereas PL/SQL is used to code programs.

  3. SQL can be embedded within PL/SQL but a PL/SQL statement cannot be embedded in SQL.

  4. PL/SQL executes one statement at a time, whereas SQL is used to write a code block.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

PL/SQL is used to write individual statement in the form of a unit or program. When the program is executed, all the statements written in a complete logic are executed. On the other hand, SQL statements are executed one at a time when the user presses enter key to run the statement.

Keep practicing — related questions