ORACLE DATABASE INTERVIEW QUESTIONS

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

What happens to the data in a table when you use the DROP TABLE statement?

Can you drop a table that has dependent objects, such as views or indexes, in Oracle?

How do you drop a table only if it exists, to avoid errors in Oracle?

What is the effect of the CASCADE CONSTRAINTS clause when dropping a table?

Explain the difference between the DROP TABLE and TRUNCATE TABLE statements?

How can you drop a table that is part of a partitioned table?

What are the implications of dropping a table that is referenced by materialized views in Oracle?

Describe how to safely drop a table in a multi-user environment without affecting active transactions?

Explain the significance of the PURGE clause when dropping a table and provide an example.