What is the proper method for disabling and re-e

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

(Continued from previous question...)

What is the proper method for disabling and re-enabling a primary key constraint?

Level: Intermediate
Expected answer: You use the ALTER TABLE command for both. However, for the enable clause you must specify the USING INDEX and TABLESPACE clause for primary keys.

(Continued on next question...)

Other Job Interview Questions

• What are the built-ins used for finding object ID functions?
• Auditing
• What are the trigger associated with image items?
• Do View contain Data?
• How can you enable a trace for a session?
• What is the maximum no of chars the parameter can store?
• What other parts of your organization do you interact with and how?
• What is the proper method for disabling and re-enabling a primary key constraint?
• What are the two phases of block coordination?
• Differentiate simple and complex, snapshots?
• More...