Explain about SQLOS? - Functions such as buffer pool management, synchronization primitives, memory and I/O management, etc are supported by SQLOS. This forms the base component in SQL. Thread management is entirely performed by SQLOS, it also monitors worker threads to detect and recover it from dead locks - 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: Explain about SQLOS?

Answer: Functions such as buffer pool management, synchronization primitives, memory and I/O management, etc are supported by SQLOS. This forms the base component in SQL. Thread management is entirely performed by SQLOS, it also monitors worker threads to detect and recover it from dead locks

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

Question: Explain about SQLOS?

Answer:

Functions such as buffer pool management, synchronization primitives, memory and I/O management, etc are supported by SQLOS. This forms the base component in SQL. Thread management is entirely performed by SQLOS, it also monitors worker threads to detect and recover it from dead locks 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
	Detail about the hardware which is supported by SQL server?	View Answer
	Explain about the architecture of MYSQL?	View Answer
	Explain in brief about Microsoft SQL server?	View Answer
	How many devices can communicate concurrently?	View Answer
	In Reporting Services 2005, how is Report Builder typically deployed to end users?	View Answer
	You have a SQL Server 2005 sales database experiencing performance problems because of heavy I/O activity. You decide to create a snapshot of this database every hour, stored on a separate physical disk array and use that for reporting queries. However the queries still seem slow immediately after snapshot creation. Why?	View Answer
	What does the CREATE SERVICE statement do in SQL Server 2005?	View Answer
	Before a user can build reports using Report Builder in Reporting Services 2005, which one of the following steps must be done first?	View Answer
	In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?	View Answer
	What does @@textsize return?	View Answer
	Which types of replication work with Oracle publishers?	View Answer
	You have just upgraded your SQL Server 2000 instance on Windows 2000 to SQL Server 2005. You are looking to begin implementing encryption capabilities and need to choose an algorithm for your data. Which of the following is not available to you?	View Answer
	What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?	View Answer
	Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database	View Answer
	Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?	View Answer
	What does the DEALLOCATE statement do in SQL Server 2005?	View Answer
	When you install SQL Server 2005 and create a new database, is a Database Master Key created?	View Answer
	You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?	View Answer
	Where can you view the list of server-scoped DDL triggers?	View Answer
	You are setting up a native XML web service on your SQL Server 2005 to respond to inventory requests. How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?	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