Only one column can be added to an existing table at one time.
4. More than one column can be changed at a time with the ALTER
Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?
Which command is used to rename a table you own?
The syntax of the CREATE
command requires that the column list be enclosed in parentheses.
When creating a table, which of the following statements is correct?
a valid table name.
A _______ column generates values automatically at runtime and may reference values from other
In which format does Oracle10
display a date value?
The DROP TABLE command can be used to remove a table and all its data from a database.
Which command instructs Oracle11
to create a new table?
The column definition of NUMBER(7, 4) indicates a precision of ____.
A _______ column generates values automatically at runtime and may reference values from other columns.
The maximum width of the NUMBER datatype is ____ digits.
An automatic column will generate a value at runtime and may reference values from other columns.
Which of the following keywords cannot be used to modify an existing table?