Question

CREATE INDEX customer_dept_id_idx ON cutomer_info(cust_id);

Which of the following statements are true with respect to the above index?



Select one:
Increase the chance of full table scans.
May reduce the amount of disk I/O for SELECT statements.
May reduce the amount of disk I/O for INSERT statements.
Store an index in the CUSTOMER_INFO table.
Override the unique index created when the FK relationship was defined.

Answer 1

Answer:

CREATE INDEX customer_dept_id_idx ON cutomer_info(cust_id);

Which of the following statements are true with respect to the above index?

Select one:

Increase the chance of full table scans.

May reduce the amount of disk I/O for SELECT statements.

May reduce the amount of disk I/O for INSERT statements.

Store an index in the CUSTOMER_INFO table.

Override the unique index created when the FK relationship was defined.

Explanation:

this ossam.