Multiple choice technology databases

What tasks are you able to perform within a PL/SQL block?

  1. DELETE

  2. CREATE

  3. UPDATE

  4. ALTER
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

PL/SQL blocks can execute DML statements like DELETE and UPDATE to manipulate existing data. However, DDL statements like CREATE and ALTER cannot be used directly inside a PL/SQL block - they require dynamic SQL (EXECUTE IMMEDIATE).

Keep practicing — related questions