ORACLE DATABASE INTERVIEW QUESTIONS

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

What are some common data types used when creating tables in Oracle?

How do you add a NOT NULL constraint to a column when creating a table?

How do you create a table with a foreign key constraint in Oracle?

What is the purpose of using the UNIQUE constraint when creating a table?

Can you explain how to create a table with a default value for a column?

How do you create a table with a composite primary key in Oracle?

What are tablespaces, and how do you specify a tablespace when creating a table?

How can you create a table with partitioning in Oracle?

Explain how to create a table with an INDEX organized structure and its advantages?