Which action would you perform to avoid waiting in the first session ?
A. Drop any existing index on the EMP table
B. Drop any existing index on the DEPT table
C. Create an index on the deptno column of the EMP table
D. Create an index on the deptno column of the DEPT table
Answer:A
Which action would you perform to avoid waiting in the first session ?
A. Drop any existing index on the EMP table B. Drop any existing index on the DEPT table C. Create an index on the deptno column of the EMP table D. Create an index on the deptno column of the DEPT table
Explanation: Creation index on the column will may increase the disk space requirements of your database and slow down dml (i.e. inserts, updates and deletes)also increase the maintenance requirements of your Oracle database,index may make your queries slower instead of faster.