What SQL statement could not be part of a PL/SQL program?
A)INSERT INTO my_table ('abc');
B)SELECT * from my_table;
C)CREATE TABLE my_table (col1 CHAR(10));
D)DELETE my_table;

Question

Quizplus · Accepted Answer

DC) The CREATE TABLE statement is typically not allowed in PL/SQL blocks because PL/SQL is designed for procedural logic and data manipulation rather than schema definition. However, it can be executed through dynamic SQL using EXECUTE IMMEDIATE, but directly it's not part of procedural logic.D) The correct syntax for the DELETE statement should be "DELETE FROM my_table;" rather than "DELETE my_table;". This syntax error makes it incorrect and thus it could not be part of a PL/SQL program without correction.

What SQL Statement Could Not Be Part of a PL/SQL