What is the output of the following query?
SELECT TRUNC(1234.5678,2) FROM DUAL;

Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 7814

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

1200

Asked In: Interviews | Alert Moderator

Bookmark It

< Previous : C# delegate keyword is derived form which namespac ...

Next > : What is subnet?

Comments or Responses

Posted by: Gauravsharma on: 12/30/2010 | Points: 10

SELECT TRUNC(1234.5678,2) FROM DUAL

for the above query the ans is 1234.56 not 1200

for this ans, the question should be SELECT TRUNC(1234.5678,-2) FROM DUAL

More Interview Questions by Abhisek

What is subnet?
What are the three levels of data abstraction?
What are the benefits of ADO.NET?
What are the components of .NET DataProvider?
What are the differences between ADO and ADO.NET?
ASP.Net pages are compiled and are not interpreted. True or False.
In Microsoft Windows XP, XP stands for what?
A constructor can be private. True or False

Latest Interview Questions

Can you compare two SQL fields with datatype "text" by using ...
what is web part?and type
what is MOSS ?
What are ways to create input forms for workflow ?
What are the types of input forms that can be created for a workflow ?
What is Authentication and Authorization.
what is Ajax?
what is PrePageExecute() event
More ...

What is the output of the following query? SELECT TRUNC(1234.5678,­2) FROM DUAL;

Comments or Responses

What is the output of the following query?
SELECT TRUNC(1234.5678,2) FROM DUAL;