Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
Practice Problems: Table Creation and Management
1. Create a new table containing at least four columns of four different data types (CHAR,
VARCHAR2, NUMBER, DATE). Name the
table your_first_name_your_last_name (substitute your_first_name with your first name
and your_last_name with your last name).
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
2. Retrieve a list of tables in your schema to confirm that the table created in Problem 1 is stored in
your schema.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
3. Obtain information about the table created in Problem 1. Display the structure of the table that
includes column names, data types, and constraints.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
4. Add a column to the table created in Problem 1.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
5. Change the size of any column in the table created in Problem 1.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
6. Add a new constraint (UNIQUE, CHECK, etc.) to any column in the table created in Problem 1.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
7. Drop a column in the table created in Problem 1.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
8. Mark one of the columns in the table created in Problem 1 as unused. Verify that the column is no
longer available.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
9. Rename the table created in Problem 1.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
10. Delete the table created in Problem 1 permanently so that it isn’t moved to the recycle bin.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
Practice Problems: Constraints
1. Write an SQL code to create the VENDOR table. The informaton about the VENDOR
table is provided below. When creatng the table, make sure to include appropriate
constraints defned in the descripton.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
2. Write and SQL coed to create the PRODUCT table. The informaton about the PRODUCT
table is provided below. When creatng the table, make sure to include appropriate
constraints defned in the descripton.
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
3. Assuming that each product is manufactured by many vendors and each vendor makes many
products, create a bridge table between VENDOR and PRODUCT. When creating the table,
make sure to include appropriate constraints (primary key, foreign keys, etc.).
Manpreet Sandhu
MS AIT 524
M5_1_Practice_Problems
4. Use the ALTER TABLE … ADD CONSTRAINT command to add the UNIQUE constraint to the
PROD_DESC column in the PRODUCT table.
