I selected A as the answer:
1 (A).
Schema1 Table1dbo Table1
My coworker suggested B as the answer but I know he was wrong. Having read and reviewed scheme, it was all good. Then I saw Answer C, that almost seem right to me because I haven't encounter sys.objects before and just last night, I got the information I want from sysobjects ... I was sooo leaning towards C but select B to claim my coworker down.
What do you know, my answer was right. He was still questioning the concept so we ran the code in sql 2005 and boom, A, was the correct answer.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.