What is the size of the BIT type?(a) 1(b) 2(c) 3(d) variableThis question was posed to me in class test.I'm obligated to ask this question of Running Multiple Servers topic in section General MySQL Administration of MySQL

What is the size of the BIT type?(a) 1(b) 2(c) 3(d) variableThis quest

1.	What is the size of the BIT type?(a) 1(b) 2(c) 3(d) variableThis question was posed to me in class test.I'm obligated to ask this question of Running Multiple Servers topic in section General MySQL Administration of MySQL
Answer» The CORRECT choice is (d) variable The BEST I can explain: All the numeric datatypes used in MYSQL vary over the fields. However, the MAXIMUM size is fixed. Unlike the other numeric types, the size of the BIT datatype depends on the length of the FIELD.

Discussion

No Comment Found

Related InterviewSolutions

The privilege that must be given to the database to create a stored function or procedure is ____________(a) CREATE ROUTINE(b) CREATE METHOD(c) CREATE FUNCTION(d) CREATE PROCEDUREI had been asked this question by my college professor while I was bunking the class.Enquiry is from Updating MySQL in section General MySQL Administration of MySQL
How would a stored function named PI() written in the database ‘sampdb’ be called?(a) PI()(b) sampdb.PI()(c) MySQL.PI()(d) db.PI()I got this question in quiz.I'd like to ask this question from Updating MySQL in section General MySQL Administration of MySQL
The number of values returned from a stored procedure can be _______________(a) 0(b) 1(c) 2(d) 3The question was posed to me during an internship interview.Enquiry is from Updating MySQL topic in portion General MySQL Administration of MySQL
The mode used to turn on strict mode and all of the additional restrictions is _____________(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) TRADITIONAL(d) ERROR_WHEN_DIVIDE_BY_ZEROThe question was asked in an interview for internship.This interesting question is from Updating MySQL topic in chapter General MySQL Administration of MySQL
What is the SQL mode to check for divide by zero error?(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) ERROR_DIVIDE_BY_ZERO(d) ERROR_WHEN_DIVIDE_BY_ZEROThe question was asked by my school teacher while I was bunking the class.Asked question is from Updating MySQL in chapter General MySQL Administration of MySQL
What is the SQL mode to check for divide by zero error?(a) STRICT_ALL_TABLES(b) ERROR_FOR_DIVISION_BY_ZERO(c) ERROR_DIVIDE_BY_ZERO(d) ERROR_WHEN_DIVIDE_BY_ZEROI had been asked this question in an interview.The above asked question is from Updating MySQL in portion General MySQL Administration of MySQL
The command to see the warning messages is ______________(a) DISPLAY WARNINGS(b) DISP WARNINGS(c) DISP WARNING(d) SHOW WARNINGSThe question was posed to me at a job interview.My query is from Updating MySQL in section General MySQL Administration of MySQL
A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.(a) True(b) FalseThe question was posed to me in an online quiz.This key question is from Updating MySQL in division General MySQL Administration of MySQL
Slow shutdown can be performed by setting innodb_fast_shutdown to _____________(a) 0(b) -1(c) 1(d) 2This question was posed to me in an interview for internship.The doubt is from Updating MySQL in portion General MySQL Administration of MySQL
Which upgrade involves shutting down the old MySQL version and replacing the old binaries?(a) inplace(b) logical(c) illogical(d) systemThe question was asked in a job interview.This key question is from Updating MySQL in chapter General MySQL Administration of MySQL

What is the size of the BIT type?(a) 1(b) 2(c) 3(d) variableThis question was posed to me in class test.I'm obligated to ask this question of Running Multiple Servers topic in section General MySQL Administration of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment