IT314 modifying tables
When modifying data in existing columns, which of the following is correct?
A column must be as wide as the data it already contains
When adding a column to an existing table, the ____________________ clause must be used with the ALTER TABLE command.
ADD
The ____ TABLE command is used to modify an existing column's data declaration
ALTER
The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.
ALTER TABLE
Which of the following commands can be used to make structural changes to an existing table?
ALTER TABLE
Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?
ALTER TABLE customers MODIFY (city VARCHAR2(20), lastname VARCHAR2(14));
The ____________________ TABLE command can be used to delete a table from a database
DROP
The ____________________ clause of the ALTER TABLE command can be used to delete a column from an existing table.
DROP COLUMN
Which of the following keywords is used to remove a database table in Oracle11 g?
DROP TABLE
A database must be shut down before the ALTER TABLE command can be executed.
FALSE
Data manipulation language commands are used to create or modify database tables.
FALSE
Only one column can be added to an existing table at one time
FALSE
Only one column can be added to an existing table at one time.
FALSE
The ALTER TABLE name can be used to rename a table.
FALSE
The CHANGE TABLE command can be used to modify an existing table.
FALSE
The DELETE TABLE command can be used to remove a table from a database.
FALSE
The MODIFY TABLE command can be used to change the size of a table
FALSE
The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table.
FALSE
The SQL command to create a database table is an example of DML
FALSE
The TRUNCATE TABLE command can be used to delete a table from a database.
FALSE
the ALTER TABLE name can be used to rename a table
FALSE
The ____________________ clause of the ALTER TABLE command can be used to change the size of a column
MODIFY
DDL commands are used to create or modify database objects.
TRUE
More than one column can be changed at a time with the ALTER TABLE...MODIFY command
TRUE
You cannot delete the last column in a table
TRUE
The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table, while still retaining the table's structure.
TRUNCATE
To delete all the rows in a table and free up the storage space that was occupied by those rows, the ____ command should be used.
TRUNCATE TABLE
Which of the following terms refers to commands that are used to create or modify database tables?
data definition language (DDL)
Which command would be used to delete table x and all foreign key constraints to x?
drop x cascade constraints
Once a table is ____________________, any associated indexes will be removed from the database
dropped
The TRUNCATE TABLE command can be used to delete a table from a database
false
When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?
the command can be used to delete multiple columns from a table
The DROP TABLE command can be used to remove a table and all its data from a database
true
When a column is deleted, the deletion is permanent.
true
Deleting columns from a table is a(n) ____ action
unrestricted
