The best datatype for a column that is expected to store values up to 2 million is _________(a) SMALLINT(b) TINYINT(c) MEDIUMINT(d) BIGINTI had been asked this question in a national level competition.My doubt is from Database Copies topic in portion Nulls and Conditions and Miscellaneous of MySQL

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

1.	The best datatype for a column that is expected to store values up to 2 million is _________(a) SMALLINT(b) TINYINT(c) MEDIUMINT(d) BIGINTI had been asked this question in a national level competition.My doubt is from Database Copies topic in portion Nulls and Conditions and Miscellaneous of MySQL
Answer» The correct choice is (d) BIGINT The best explanation: The DIFFERENT numeric types used in MySQL are used to STORE different range of VALUES. To store values of the order of a MILLION, the MEDIUMINT or BIGINT datatype is sufficient.

Discussion

No Comment Found

Related InterviewSolutions

The MySQL server is configurable.(a) True(b) FalseThe question was asked at a job interview.This is a very interesting question from Secure Connections in portion Nulls and Conditions and Miscellaneous of MySQL
Is the following statement is true/false?(a) “An expression can be NULL,but can never equal to NULL”(b) True(c) FalseThe question was asked in an online quiz.The above asked question is from Null: the Four Letter Word in division Nulls and Conditions and Miscellaneous of MySQL
Which among the following operators is/are belongs to “Equality conditions”?(a) (b) !=(c) =(d) >/
Select odd one out?(a) Equality Conditions(b) Inequality Conditions(c) Range condition(d) BetweenI have been asked this question in an internship interview.The above asked question is from Condition Types topic in section Nulls and Conditions and Miscellaneous of MySQL
Which of the following statements is/are correct?(a) True OR true =true(b) True OR false= true(c) False OR false= false(d) All of the mentionedI got this question in my homework.This question is from Conditional Evaluation in division Nulls and Conditions and Miscellaneous of MySQL
What is the TLS protocol?(a) transparent layer security(b) transport layer security(c) transparent level security(d) transport level securityI had been asked this question in an interview for job.The query is from Secure Connections in section Nulls and Conditions and Miscellaneous of MySQL
The number of files that each end of a client/server connection including SSL support use to set up secure communications is __________(a) 0(b) 1(c) 2(d) 3The question was posed to me by my college director while I was bunking the class.Question is taken from Secure Connections in section Nulls and Conditions and Miscellaneous of MySQL
Is the following statement is true/false?(a) “Two NULL values are equal to each other”(b) True(c) FalseThis question was addressed to me by my school principal while I was bunking the class.This interesting question is from Null: the Four Letter Word topic in division Nulls and Conditions and Miscellaneous of MySQL
Which operator is used to check the expression is not “NULL”?(a) IS NULL(b) NOT NULL(c) ON(d) None of the mentionedThis question was addressed to me during an online exam.Asked question is from Null: the Four Letter Word topic in section Nulls and Conditions and Miscellaneous of MySQL
What is the meaning of “NULL” in Mysql?(a) Not applicable(b) Value not yet known(c) Value undefined(d) All of the mentionedI got this question during an interview.My doubt stems from Null: the Four Letter Word in portion Nulls and Conditions and Miscellaneous of MySQL

The best datatype for a column that is expected to store values up to 2 million is _________(a) SMALLINT(b) TINYINT(c) MEDIUMINT(d) BIGINTI had been asked this question in a national level competition.My doubt is from Database Copies topic in portion Nulls and Conditions and Miscellaneous of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment