ORACLE DATABASE INTERVIEW QUESTIONS

What is a database view in Oracle?

How do you create a view in Oracle?

Can you modify data through a view in Oracle?

What are the advantages of using views in Oracle?

How do you update data through a view in Oracle?

Can you create a view with a join in Oracle?

What is an inline view, and how is it used in Oracle?

How do you create a materialized view in Oracle, and what is its purpose?

How do you refresh a materialized view in Oracle?

Explain how you would use a view within a PL/SQL block in Oracle?

Give brief description on the difference between a table and view in Oracle database