hakan.winther (9/30/2014)
Eirikur Eiriksson (9/30/2014)
Thank you for the question Amit.Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is {object,column}, one can rule out 0 as the query will return values, one can also rule out twenty as most objects have more than one column which leaves 2 as the only applicable answer.
😎
2 is not a correct answer as it will depend on the database. I also eliminated 0 and 20 to get my points, but the answer is still wrong.
Knowing that id is not the primary key column of syscolumns and no specific database was designated for the execution of the code, the answer 2 (two) is the only reasonable answer.
😎