A table is classified as a parent table and you

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

17. 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?

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

(Continued on next question...)

Other Job Interview Questions

• What are the two types of views available in the object navigator (specific to report 2.5)?
• What are three panes that appear in the run time pl/SQL interpreter?
• What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
• What are the different types of SQL statements?
• What are the different types of Delete details we can establish in Master-Details?
• How do you execute a UNIX command in the background?
• What is a SNAPSHOT?
• What are the different file extensions that are created by oracle reports?
• How can you determine if an index needs to be dropped and rebuilt?
• What are the different default triggers created when Master Deletes Property is set to Non-isolated?
• More...