Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 11: What is the maximum value column a can store? – MySQL Question of the Day

Skip to content

By urs in mysql questions

 
See the following table:

CREATE TABLE `bittst` (
  `a` bit(3) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 
What is the maximum value column a can store?

a) 3
b) 8
c) 7
d) 127

 
[ Data Types (15%) - Numeric Data Types ]
 

Tags: , ,

Comment Feed

One Response


  1. Answer:

    c

    3 bits can store values from 0 to 7 (1+2+4).

You must be logged in to post a comment.