ORACLE DATABASE INTERVIEW QUESTIONS

What is the basic syntax for altering a table in Oracle?

How do you add a new column to an existing table?

How can you modify the data type of an existing column in a table?

How do you rename a column in an Oracle table?

Can you explain how to add a NOT NULL constraint to an existing column?

How do you drop a column from an Oracle table?

What is the purpose of adding a CHECK constraint using the ALTER TABLE statement, and how do you add one?

How can you add a composite unique constraint to a table?

Describe how to enable and disable constraints using the ALTER TABLE statement?

Explain how to use the ALTER TABLE statement to change the storage characteristics of a table?