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

What is datadir?

0 Answers  


How do I remove a user from mysql?

0 Answers  


What mysql means?

0 Answers  


Which is better mysql or mssql?

0 Answers  


What is the usage of ENUMs in MySQL?

0 Answers  


Can we create table in stored procedure?

0 Answers  


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers  


In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1 Answers  


What can you do with mysql?

0 Answers  


Why myisam is faster than innodb?

0 Answers  


How do I disable mysql?

0 Answers  


If you wish to encrypt the username and password using php, how will you do that?

0 Answers  


Categories