DB2 Indexes

I ) Unique Index can be created only on Primary Key.
ii) Query will execute faster if predicates are applied on Indexed column.

1 Both are True
2 i) is only True
3 ii) is Only True
4 Neither is True

Questions by radibioinfo   answers by radibioinfo

Showing Answers 1 - 27 of 27 Answers

padmanabha

  • Feb 2nd, 2012
 

Answer is 1 Both are True.

  Was this answer useful?  Yes

sri

  • Aug 28th, 2013
 

Hi Guys,

Is anybody know how to write fetch last ten records in DB2.

  Was this answer useful?  Yes

sangilimurugan

  • Feb 3rd, 2014
 

2 i) is only true

  Was this answer useful?  Yes

madhavan

  • Mar 10th, 2014
 

SELECT * FROM Table_name where condition

FETCH FIRST 10 ROWS ONLY;

  Was this answer useful?  Yes

Prachi Patankar

  • Jun 22nd, 2014
 

Both are true

  Was this answer useful?  Yes

Rishu

  • Aug 9th, 2014
 

3 ii) is Only True

  Was this answer useful?  Yes

Gilbert

  • Mar 3rd, 2015
 

both are true

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions