Thanks for the question..hurray I got it correct...but only after reading explanation about it in BOL...I never heard about it before...but its a very useful function...

Yes..the explanation given by OP was wrong..answer II and III is absolutely correct.