The best datatype for a column that is expected to store values up to – McqOptions

MCQOPTIONS

1.	The best datatype for a column that is expected to store values up to 2 million is _________.
A.	BIGINT
B.	MEDIUMINT
C.	TINYINT
D.	SMALLINT
E.	None of these
Answer» B. MEDIUMINT

Discussion

No Comment Found

Related MCQs

Which of these is not optional?<br><pre class="prettyprint lang-c">SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;<br></pre>
How many of these are for use with only MyISAM tables?<br>mysql, mysqladmin, mysqldump, mysqlisamchk
How many of these can replace level in myisam-recover = level ?<br>BACKUP, FORCE, QUICK
REPAIR TABLE works with how many of the following?<br>MyISAM, ARCHIVE, CSV
The higher priority is ______________.<br>writes, reads
With only MyISAM tables, how many of the following are for use?<br>mysql, mysqladmin, mysqldump, mysqlisamchk
How many of the following languages can interface to bind to the C API of MySQL?<br>Perl, PHP, Python
CHECK TABLE works with how many of the following?<br>MyISAM, ARCHIVE, CSV
What is the table name in the following?<br><pre class="prettyprint lang-c">INSERT INTO Employee VALUES('Rahul','M',NULL);<br></pre>
What is InnoDB in the following code?<br><pre class="prettyprint lang-c">CREATE TABLE Employee (<br> Emp_name CHAR(30),<br> Emp_id INT,<br> PRIMARY KEY (Emp_id)<br> ) ENGINE = InnoDB;<br></pre>