Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

101.

The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________(a) 32(b) 64(c) 65(d) 16The question was posed to me in unit test.I would like to ask this question from Data Value Categories topic in section Data Types of MySQL

Answer»

The correct ANSWER is (c) 65

For explanation I would say: In MySQL, for the expressions containing only exact VALUES and where one or more values have a fractional PART, the DECIMAL arithmetic is used with digits of precision EQUAL to 65.
Discussion
102.

The BIGINT precision is of bit _________(a) 32(b) 64(c) 128(d) 16This question was addressed to me in an interview.My question is taken from Data Value Categories topic in portion Data Types of MySQL

Answer»

The correct option is (B) 64

Explanation: In MySQL, for the EXPRESSIONS containing only EXACT values that are all integers, the evaluation uses BIGINT (64 – bit) precision. MySQL evaluates expressions using exact/approximate MATH.
Discussion
103.

The mantissa in -1.58E5 is __________(a) -1.58(b) 1.58(c) E(d) 5The question was asked in a national level competition.I'd like to ask this question from Data Value Categories in chapter Data Types of MySQL

Answer» CORRECT ANSWER is (a) -1.58

Explanation: In MySQL, the scientific notation for REAL numbers is possible. Some values are represented as FLOATING point numbers in scientific notation consisting of a mantissa and exponent.
Discussion
104.

Hexadecimal numbers cannot be used in scientific notation.(a) True(b) FalseThis question was addressed to me in an online interview.My question is based upon Data Value Categories in division Data Types of MySQL

Answer»

Right option is (a) True

For explanation: The scientific NOTATION for real numbers is possible in MySQL. Approximate values are REPRESENTED as floating point numbers in scientific notation. It CONSISTS of a mantissa and exponent.
Discussion
105.

Numbers prefixed with ‘0x’ are in base __________(a) 8(b) 16(c) 32(d) 64The question was asked in homework.My doubt stems from Data Value Categories topic in division Data Types of MySQL

Answer»

The CORRECT choice is (b) 16

The best I can EXPLAIN: In MYSQL, there are many numeric datatypes. They include integers and floating points. For example, 34, 12.3, -1.3E11. The numbers that are prefixed with ‘0x’ are in HEXADECIMAL.
Discussion