What does the CEILING() function do? - Returns the smallest integer greater than or equal to the value passed in. CEILING() returns the smallest integer that is great than or equal to the value passed in. - MS 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

MS SQL SERVER

DETAILS

Question: What does the CEILING() function do?

Answer: Returns the smallest integer greater than or equal to the value passed in.
CEILING() returns the smallest integer that is great than or equal to the value passed in.

Category	MS SQL Server Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7105 users
Added on	9/19/2014
Views	71624
Rate it!

Question: What does the CEILING() function do?

Answer:

Returns the smallest integer greater than or equal to the value passed in.
CEILING() returns the smallest integer that is great than or equal to the value passed in. 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 message types exist in SQL Server 2005 Service Broker?	View Answer
	What is not true about the Raw File Destination connection in SQL Server 2005 Integration Services?	View Answer
	For configuring event logging for your SQL Server 2005 Notification Services instance. Where would you make this change?	View Answer
	Can you call Notification Services APIs from unmanaged code?	View Answer
	How can you determine which Service Broker ports are being used on your server?	View Answer
	What does a report model provide in SQL Server 2005 Reporting Services?	View Answer
	Where are Notification Services event messages logged in SQL Server 2005?	View Answer
	In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?	View Answer
	If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?	View Answer
	In Reporting Services 2005, how is Report Builder typically deployed to end users?	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, what 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 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 which 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
	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
	What algorithm is used to encrypt the Database Master Key when it is created?	View Answer
	Out of the box Report Builder supports two report level fields that can be shown on a report. Which has those two options?	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 MS SQL Server Interview Questions & Answers - Exam Mode / Learning Mode