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:The ITEM table has six columns. Since the table is often queried with a join to the SALE table, an index was created on five of the columns in the ITEM table. What will be the result?

a.        Inserts to the table will be slower
b.        The size of the ITEM table will be increased
c.        All queries on the ITEM table will be faster if it does not contain a large number of NULL values
d.        The speed of deletes will be increased

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

Related Hot Questions

Government Jobs Opening