Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


boostr.in questions - 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

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
25 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...