1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / amith

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 memory table in mysql?

0 Answers  

How to upload a large file through phpmyadmin in mysql?

0 Answers  

How do I show all mysql databases?

0 Answers  

How will you export tables as an xml file in mysql?

0 Answers  

How to shutdown mysql server?

0 Answers  




Define REGEXP?

0 Answers  

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

0 Answers  

What are the common mysql functions?

0 Answers  

what is database white box testing? : Mysql dba

0 Answers  

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

What are the similarities between a function and a procedure?

0 Answers  

What is blob and text in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories