ORACLE DATABASE INTERVIEW QUESTIONS

What are some common data types used in Oracle?

What is the difference between CHAR and VARCHAR2 data types?

How do you define a column to store dates and times in Oracle?

Explain the NUMBER data type and its precision and scale attributes?

What is the CLOB data type used for, and how does it differ from BLOB?

How can you store a large binary file, such as an image, in an Oracle database?

Describe the TIMESTAMP data type and how it differs from the DATE data type?

What is the INTERVAL data type and how is it used in Oracle?

Explain how the RAW data type is used in Oracle?

Discuss the NCLOB data type and its advantages in an Oracle database?