What is the minimum value stored by signed TINYINT?(a) -256(b) -128(c) 0(d) 128The question was posed to me in an interview for job.I want to ask this question from String Data Types in section Data Type Reference, Operators and Functions of MySQL

What is the minimum value stored by signed TINYINT?(a) -256(b) -128(c)

1.	What is the minimum value stored by signed TINYINT?(a) -256(b) -128(c) 0(d) 128The question was posed to me in an interview for job.I want to ask this question from String Data Types in section Data Type Reference, Operators and Functions of MySQL
Answer» Right option is (b) -128 For EXPLANATION I would SAY: MySQL supports the SQL standard integer types INTEGER, or INT, and SMALLINT. As an extension to this standard, MySQL also supports the integer types TINYINT, MEDIUMINT and BIGINT.

Discussion

No Comment Found

Related InterviewSolutions

The facility that allows nesting one select statement into another is ______________(a) nesting(b) binding(c) subquerying(d) encapsulatingI got this question in an interview for job.The origin of the question is Functions in section Data Type Reference, Operators and Functions of MySQL
The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ______________(a) CARTESIAN JOIN(b) CROSS JOIN(c) INNER JOIN(d) RIGHT JOINI had been asked this question in examination.My doubt is from Functions in portion Data Type Reference, Operators and Functions of MySQL
What does the AUTO_INCREMENT sequences begin at by default?(a) 0(b) 1(c) -1(d) 2The question was posed to me by my school teacher while I was bunking the class.My question is from Functions in section Data Type Reference, Operators and Functions of MySQL
There cannot be more than one column per table with the AUTO_INCREMENT attribute.(a) True(b) FalseI got this question by my college professor while I was bunking the class.The origin of the question is Functions in portion Data Type Reference, Operators and Functions of MySQL
CGI.pm does not support an object oriented style of use.(a) True(b) FalseThe question was asked in a national level competition.Question is from Functions topic in division Data Type Reference, Operators and Functions of MySQL
The string function that returns the index of the first occurrence of substring is _____________(a) INSERT()(b) INSTR()(c) INSTRING()(d) INFSTR()I got this question in examination.The origin of the question is Functions topic in section Data Type Reference, Operators and Functions of MySQL
The operator that compares sounds is _____________(a) MATCH SOUNDS(b) CHECK SOUNDS(c) SOUNDS LIKE(d) SOUNDS SIMILARThe question was asked in exam.The question is from Functions topic in division Data Type Reference, Operators and Functions of MySQL
Which function returns NULL if expr1 = expr2?(a) CASE(b) IF()(c) IFNULL()(d) NULLIF()I had been asked this question during a job interview.I would like to ask this question from Functions topic in portion Data Type Reference, Operators and Functions of MySQL
The server is told to accept spaces after function names by _____________(a) –sql-mode=SKIP_SPACE(b) –sql-mode=IGNORE_SPACE(c) –sql-mode=SPACE_IGNORE(d) –sql-mode=SPACE_SKIPI have been asked this question by my college director while I was bunking the class.Origin of the question is Functions topic in portion Data Type Reference, Operators and Functions of MySQL
The maximum non zero value for FLOAT is ______________(a) 3.402823466E+38(b) 3.402823466E+37(c) 3.402823466E+39(d) 3.402823466E+35This question was addressed to me in an online quiz.I would like to ask this question from Operators in chapter Data Type Reference, Operators and Functions of MySQL

What is the minimum value stored by signed TINYINT?(a) -256(b) -128(c) 0(d) 128The question was posed to me in an interview for job.I want to ask this question from String Data Types in section Data Type Reference, Operators and Functions of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment