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 ]
mysql 5.0/5.1 questions for learning purposes
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 ]
You must be logged in to post a comment.
Answer:
c
3 bits can store values from 0 to 7 (1+2+4).