D both constraints not deferrable and use the alter

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: TER SESSION command to defer checking of the foreign key constraint as needed. E. The foreign key constraints DEFERRABLE, and use the ALTER TABLE command to defer checking of the foreign key constraint as needed. Answer: B Explanation: Answer B is correct. To be able to insert data in the child table before inserting rows in the parent table, you must set the foreign constraints DEFERRABLE and the PRIMARY KEY for parent table as NOT DEFERRABLE. Incorrect Answers: A: PRIMARY KEY constraint for the parent table needs to be NOT DEFFERRABLE to avoid wrong data inserts. C: Foreign constraints in child table can be DEFFERRABLE in this case. SET CONSTRAINT command does not exist in Oracle. D: Foreign constraints in child table can be DEFFERRABLE in this case. ALTER SESSION command will not help to defer checking of the foreign key constraint as needed. E: PRIMARY KEY constraint for the parent table needs to be NOT DEFFERRABLE to avoid wrong data inserts. Oracle 8, DBA Certification Exam Guide, Jason S. C...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online