Multiple Choice
Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?
A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2) ;
B) ALTER TABLE T2 ADD COLUMN C5 NUMBER (2) ;
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0) ;
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0) ;
E) ALTER TABLE T2 ADD C5 NUMBER (2) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q9: The Oracle Database GUI provides graphical facilities
Q10: Explain sequences and their relationship to surrogate
Q11: An Oracle Database tablespace is a logical
Q13: Which of the following Oracle Database ReDo
Q31: SOONER and LATER triggers are placed on
Q43: The CurrVal method provides the current value
Q76: Oracle Database supports the ON UPDATE CASCADE
Q78: The PL/SQL keyword STOP HERE is used
Q88: With Oracle Database,stored procedures cannot use a
Q91: With Oracle Database,using a sequence does not