Which of the following is not an allocation unit in SQL Server 2005? - TEXT_IN_ROW_DATA The three types of allocation units are: IN_ROW_DATA, LOB_DATA, and ROW_OVERFLOW_DATA. Each heap or index has IN_ROW_DATA which holds part of the data. LOB_DATA is used for large object data types and ROW_OVERFLOW_DATA is used for varible length data that causes a row to exceed the 8060 byte limit. - SQL Server Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL SERVER

DETAILS

Question: Which of the following is not an allocation unit in SQL Server 2005?

Answer: TEXT_IN_ROW_DATA
The three types of allocation units are: IN_ROW_DATA, LOB_DATA, and ROW_OVERFLOW_DATA. Each heap or index has IN_ROW_DATA which holds part of the data. LOB_DATA is used for large object data types and ROW_OVERFLOW_DATA is used for varible length data that causes a row to exceed the 8060 byte limit.

Category	SQL Server Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8025 users
Added on	9/14/2014
Views	67534
Rate it!

Question: Which of the following is not an allocation unit in SQL Server 2005?

Answer:

TEXT_IN_ROW_DATA
The three types of allocation units are: IN_ROW_DATA, LOB_DATA, and ROW_OVERFLOW_DATA. Each heap or index has IN_ROW_DATA which holds part of the data. LOB_DATA is used for large object data types and ROW_OVERFLOW_DATA is used for varible length data that causes a row to exceed the 8060 byte limit. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What does the max full-text crawl range option do?	View Answer
	You have two Service Broker instances running. One is on SQL1 with the default collation and the other is on SQL2 setup for French collation. Which collation is used for Service Broker messages sent between the instances?	View Answer
	You have an old database that needs to run in compatibility mode 65 on your SQL Server 2005 server. Which framework would you use to manage this database programmatically?	View Answer
	You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?	View Answer
	What is the cost threshhold for parallelism in SQL Server 2005?	View Answer
	You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?	View Answer
	What does a @@fetch_status of -2 mean in SQL Server 2005?	View Answer
	You are performing an update of your Scalable Shared Database and receive note that two reports run at the same time received different results. These reports were both run during your update. What type of update did you perform?	View Answer
	What does the Log Reader agent in SQL Server 2005 replication do?	View Answer
	What does this return? select (1324 & 1024)	View Answer
	How are modified extents tracked in SQL Server 2005 (which internal structures)?	View Answer
	You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?	View Answer
	What is the Service Broker Identifier ?	View Answer
	Where does Profiler store its temporary data in SQL Server 2005?	View Answer
	You have installed a US English SQL Server 2000 instance with the default options, collation, and sorting. What does this return: create table MyTable ( Mychar varchar(20)) go insert Mytable select 'Apple' insert Mytable select 'ant' insert Mytable select 'Ball' go select * from MyTable where Mychar like '[^a]%'	View Answer
	What does this return? declare @i int select @i = -5 select +@i	View Answer
	Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?	View Answer
	If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?	View Answer
	The Sort component in SQL Server 2005 Integration Services is what type of component?	View Answer
	What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Server Interview Questions & Answers - Exam Mode / Learning Mode