Ask a Question
Advertise on boostr.in
Question:In prior version of Oracle, when updating a child table (EMP) the parent table (DEPT) implicitly received a Share Row Exclusive lock due to referential integrity. What must be done when using Oracle9i?
a. ¬†¬†¬†¬†¬†¬†¬†The query_rewrite must be turned on for the instance
b. ¬†¬†¬†¬†¬†¬†¬†The foreign key column must be indexed in the emp table
c. ¬†¬†¬†¬†¬†¬†¬†A unique index must be placed on the foreign key column in the emp table
d. ¬†¬†¬†¬†¬†¬†¬†Nothing is needed to be done, the implementation of the foreign key constraint is modified
Sep 13, 2013
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please