Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Know Your SQL Objects Expand / Collapse
Author
Message
Posted Thursday, May 12, 2011 11:19 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:14 AM
Points: 5,576, Visits: 6,360
Comments posted to this topic are about the item Know Your SQL Objects

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1108200
Posted Thursday, May 12, 2011 11:51 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Good question!!!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1108207
Posted Friday, May 13, 2011 12:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Learn new thing.. thx



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1108209
Posted Friday, May 13, 2011 12:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:55 AM
Points: 1,013, Visits: 1,048
Easy but tricky question,
Srikant
Post #1108210
Posted Friday, May 13, 2011 1:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,869, Visits: 3,456
Good question, but I thing the answer options are a little confusing.

"-Extents can be owned by multiple objects"
True, mixed extents.
"-Rows can span multiple pages (excluding LOB data)"
True. Row-overflow.
"-Extents can be owned by only one object"
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your use of the word "only" that confuses me, but what I read is "an extent must be owned by one, and only one, object."
"-Data pages can be owned by multiple objects"
False, obviously.
"-Text data is stored on data pages."
Do you mean text as in the datatype text, or as in text/strings? If you mean text as the text datatype, which makes this answer false, then please write so. If you mean text as in all data types that can store strings, then this answer is true.
"-Data pages can be owned by only one object"
True. One and only one object can use a data page. And when you compare the extent vs data page answers, you see why I'm confused.
"-A table row can be bigger than 8060 bytes if some of the datatypes are variable"
True. Again, row-overflow.

I don't care about the points, but I think some of the options were a little vague.
Or perhaps I'm just wrong
Post #1108222
Posted Friday, May 13, 2011 1:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 12,965, Visits: 10,739
Nils Gustav Stråbø (5/13/2011)

"-Extents can be owned by only one object"
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your use of the word "only" that confuses me, but what I read is "an extent must be owned by one, and only one, object."


The question uses the word can, not must. If an extent can be owned by multiple objects, it can certainly be owned by one object.

Anyway, nice question, but only one point?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1108228
Posted Friday, May 13, 2011 1:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 5, 2014 7:57 AM
Points: 558, Visits: 1,481
Good question but the wording was a little ambiguous in my opinion. I learnt something though so I'm not complaining.
Post #1108234
Posted Friday, May 13, 2011 1:59 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,869, Visits: 3,456
@Koen, yes I agree that I should not have interpreted the word "can" as "must", but unfortunately I did

But the answer about text data is definitely ambiguous. Based on the "correct" answer it obviously related to the text datatype, not text data in general.
Post #1108236
Posted Friday, May 13, 2011 3:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
Good question, I could get 3 options right :)

Mohammed Moinudheen
Post #1108267
Posted Friday, May 13, 2011 4:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 5,369, Visits: 9,922
Koen Verbeeck (5/13/2011)
Nils Gustav Stråbø (5/13/2011)

"-Extents can be owned by only one object"
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your use of the word "only" that confuses me, but what I read is "an extent must be owned by one, and only one, object."


The question uses the word can, not must. If an extent can be owned by multiple objects, it can certainly be owned by one object.

Anyway, nice question, but only one point?

I'm with Nils on this. The sentence can be interpreted as "it is only possible for an extent to be owned by one object" or as "it is possible for an extent to be owned by only one object". I went for the former and so got it wrong. But, as has been pointed out, it's the discussion and what you learn that's important, not the points.

John
Post #1108288
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse