Database Administrator (DBA) Question:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer:

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Download Database Administrator (DBA) PDF Read All 253 Database Administrator (DBA) Questions
Previous QuestionNext Question
What is a Segment?Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.