Font size
WorksheetsThe CREATE TABLE Statement
Total questions: 10
Worksheet time: 2mins
What type of SQL statement does the command CREATE TABLE belong to?
Data Control Language
Data Definition Language
Data Manipulation Language
Transaction Control Language
What statement is used to add, edit, and delete a column?
ALTER COLUMN
ALTER TABLE
CREATE COLUMN
CREATE TABLE
Which clause(s) do(es) not work together with the ALTER TABLE statement? Select two.
ADD COLUMN
MODIFY COLUMN
DROP COLUMN
RENAME COLUMN
What commands are used to view the structure of a table? Choose two.
DESC
DESCRIBE
SELECT
SHOW
Which one is the correct way of deleting an index named prod_idx?
DELETE prod_idx;
DELETE INDEX prod_idx;
DROP prod_idx;
DROP INDEX prod_idx;
The ALTER TABLE statement can only be used to remove a column?
TRUE
FALSE
An index is created automatically when a primary key constraint is created.
TRUE
FALSE
You can decrease the width of a character column.
TRUE
FALSE
After creating a table, you can no longer add a foreign key constraint to a column.
TRUE
FALSE
You can increase the precision of a numeric column.
TRUE
FALSE
