Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table?

Answers were Sorted based on User's Feedback



If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this tabl..

Answer / amith

999.99 to -99.99. Note that with the negative number the
minus sign is considered one of the digits.

Is This Answer Correct ?    11 Yes 5 No

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this tabl..

Answer / rajesh kumar

minimum: -999.99
maximum: +999.99

It takes M+2 bytes to store. Here M is 5 and two extra byte
for storing sign & decimal.

Is This Answer Correct ?    5 Yes 3 No

Post New Answer

More MySQL Interview Questions

What is A BI Ap;plication?

1 Answers   HCL,


What does blob mean in mysql?

0 Answers  


How do I find the database name in mysql?

0 Answers  


What are the differences between char and nchar?

0 Answers  


about foregine

2 Answers  






What is the data source name for mysql?

0 Answers  


What sql does mysql use?

0 Answers  


Write a command to list all databases in mysql?

0 Answers  


How to dump one database for backup.

0 Answers  


How to delete the repeated records from a table?

0 Answers  


What is mysql connector used for?

0 Answers  


What is the diff. bwt. primary key and unique key?

4 Answers  






Categories