ORACLE DATABASE INTERVIEW QUESTIONS

What is a table in an Oracle database?

How do you create a table in Oracle? Answer:

What is the purpose of the VARCHAR2 data type in Oracle tables?

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

What is a composite primary key, and how do you define it in an Oracle table?

Explain how foreign keys are used in Oracle tables

What are Oracle partitioned tables, and why are they used?

Describe how you can use Oracle indexes to improve query performance?

What are materialized views, and how are they different from regular views in Oracle?

Explain the concept of table compression in Oracle and its benefits?