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

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.