Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Is oracle mysql free?

0 Answers  


What are the advantages of stored procedures, triggers, indexes?

5 Answers  


How can we change the name and data type of a column of a table?

9 Answers   Google,


How to use 'mysql' to run sql statements?

0 Answers  


Which command is used to view the content of the table in mysql?

0 Answers  


how we connect the data base in any programme

2 Answers  


How do I install mysql on windows 10 64 bit?

0 Answers  


Why do we use pragma autonomous transaction?

0 Answers  


How do I start mysql manually?

0 Answers  


Can you tell few best practices to be followed for optimization in sql?

0 Answers  


What are MySQL transactions?

2 Answers  


What is mysqlcommand?

0 Answers  


Categories