Multiple Choice
Which of the following commands will drop any columns marked as unused from the TABLEA table?
A) DROP COLUMN FROM tablea WHERE column_status = UNUSED;
B) ALTER TABLE tablea DROP UNUSED COLUMNS;
C) ALTER TABLE tablea DROP (unused) ;
D) DROP UNUSED COLUMNS:
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q23: An automatic column will generate a value
Q24: Which of the following is a valid
Q25: The column definition of NUMBER(7,4)indicates a precision
Q26: Which command instructs Oracle 12c to create
Q27: A table must have at least _
Q29: Which of the following datatypes refers to
Q30: The structure of a table can be
Q31: In which format does Oracle 12c display
Q32: Which data dictionary object contains a column
Q33: When modifying data in existing columns,which of