Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

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

Related Hot Questions

Government Jobs Opening