The following SQL statement was used to create a table:

CREATE TABLE TABLE$10($

PROJECT$\_$NAME CHAR$(20),$

PROJECT$\_$LOCATION CHAR$(80))$

IN DB$10.$TS$10$;

TS$10$ is a universal table space. The table has been in use for quite a while and contains many rows. The DDL$\_$MATERIALIZATION subsystem parameter has been set to ALWAYS$\_$IMMEDIATE.

Which of the following statements would be considered a pending change?

Question $19$Select one:

A$.$

ALTER TABLE PROJECT

ADD PROJECT$\_$COST

NOT NULL WITH DEFAULT $0$;

B$.$

ALTER TABLE PROJECT

ALTER COLUMN PROJECT$\_$NAME

SET TYPE CHAR$(40)$;

C$.$

ALTER TABLE PROJECT

DROP COLUMN PROJECT$\_$LOCATION;

D$.$

ALTER TABLE PROJECT

ADD WITH RESTRICT ON DROP;