Database Administrator (DBA) Question: Download Questions PDF
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) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is a Segment? | Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each. |