Sign Up Login


  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

How much does mysql cost?

0 Answers  

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

0 Answers  

How to show certain selected rows with the value "pcds".

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  

For the database from the previous question, please give an SQL query which returns the invoice number of all invoices which contain the article with the number ?1234?. The query should be able to run under a MySQL 4.0 database.

1 Answers  

How to create trigger in mysql phpmyadmin?

0 Answers  

What are the types of index?

0 Answers  

How is mysql database stored?

0 Answers  

What are the similarities between a function and a procedure?

0 Answers  

What is query design?

0 Answers  

Is mysqli faster than mysql?

0 Answers  

Explain advantages of MyISAM over InnoDB?

1 Answers  

For more MySQL Interview Questions Click Here
Categories