Home » MCQs » Oracle MCQs » Oracle Tables MCQs

Oracle will ____ the table if there is a referential integrity constraint on table_name that is not specified as CASCADE CONSTRAINTS on the DROP TABLE statement

25. Oracle will ____ the table if there is a referential integrity constraint on table_name that is not specified as CASCADE CONSTRAINTS on the DROP TABLE statement.

1. Not Drop
2. Drop
3. Not Delete
4. Delete

Answer: A) Not Drop

Explanation:

Oracle will not drop the table if there is a referential integrity constraint on table_name that is not specified as CASCADE CONSTRAINTS on the DROP TABLE statement.