Field Data Storage Quiz
Interesting notes on data storage in MySQL. |
| Esta encuesta ya lo hizo 47 veces |
| | | | How much space does a char(20) field require minimum? | | 1 byte | 4.3% |  | | 2 bytes | 8.5% | | | 4 bytes | 8.5% | | | 8 bytes | 8.5% | | | 20 bytes | 31.9% | | | 21 bytes | 4.3% | | | 22 bytes | 2.1% | | | 24 bytes | 17.0% | | | Other View Answers | 8.5% | | | | | How much space does a varchar(20) field require minimum? | | 1 byte | 14.9% |  | | 2 bytes | 4.3% | | | 4 bytes | 8.5% | | | 8 bytes | 12.8% | | | 20 bytes | 31.9% | | | 21 bytes | 6.4% | | | 22 bytes | 0.0% | | | 24 bytes | 8.5% | | | Other View Answers | 6.4% | | | | | Are you surprised to know that char(20) requires 20 bytes minimum, regardless of field content? | | Yes | 29.8% | | | No | 31.9% | | | Don't Know | 31.9% | | | | | Are you surprised to know that varchar(20) requires only 1 byte minimum if there is no data for that field? | | Yes | 38.3% | | | No | 27.7% | | | Don't Know | 27.7% | | | | | True or False: char() and varchar() both have max storage values of 255 bytes? | | Yes | 19.1% | | | No | 27.7% | | | Don't Know | 46.8% | | | | | True or False: The documentation at dev.mysql.com explains why char() is better to use than varchar() | | True | 29.8% | | | False | 19.1% | | | Don't Know | 44.7% | | | | | Are you surprised to know that varchar() is actually capable of storing over 65kb of data, and char is limited to 255b? | | Yes | 29.8% | | | No | 29.8% | | | Don't Know | 34.0% | | | | | How does this knowledge make you feel about database storage and the decisions behind field type selection? | | Veer Respuestas |
|
Aquí están algunos otras encuestas que pueda estar interesado en:
