X’61626364′ and X’61626364′ are respectively __________(a) abcd and 1633837924(b) abcd and 4297383361(c) dcba and 1633837924(d) dcba and 4297383361I had been asked this question during an internship interview.Question is taken from Data Value Categories topic in division Data Types of MySQL

X’61626364′ and X’61626364′ are respectively __________(a) abc

1.	X’61626364′ and X’61626364′ are respectively __________(a) abcd and 1633837924(b) abcd and 4297383361(c) dcba and 1633837924(d) dcba and 4297383361I had been asked this question during an internship interview.Question is taken from Data Value Categories topic in division Data Types of MySQL
Answer» Right choice is (a) ABCD and 1633837924 The EXPLANATION is: In the numeric contexts, each hexadecimal number constant is treated as a number. WITHOUT adding a zero to it, a hexadecimal literal is treated as a STRING. Hence it is DISPLAYED as abcd.

Discussion

No Comment Found

Related InterviewSolutions

INT3 maps to MySQL type _____________(a) TINYINT(b) SMALLINT(c) MEDIUMINT(d) BIGINTI have been asked this question in a job interview.This is a very interesting question from Choosing Data Types topic in division Data Types of MySQL
INT2 maps to MySQL type _____________(a) TINYINT(b) SMALLINT(c) MEDIUMINT(d) BIGINTThis question was addressed to me in quiz.My question is based upon Choosing Data Types topic in portion Data Types of MySQL
If an integer column is used for the values in range 1 to 99999, the best suitable datatype is ____________(a) MEDIUMINT SIGNED(b) MEDIUMINT UNSIGNED(c) SMALLINT SIGNED(d) SMALLINT UNSIGNEDThe question was posed to me at a job interview.This key question is from Choosing Data Types topic in section Data Types of MySQL
Which of these values is not valid as an AUTO_INCREMENT value?(a) 0(b) 1(c) 2(d) 3I have been asked this question by my school principal while I was bunking the class.The question is from Choosing Data Types in chapter Data Types of MySQL
AUTO_INCREMENT columns must be NOT NULL.(a) True(b) FalseThis question was posed to me at a job interview.This intriguing question comes from Choosing Data Types in chapter Data Types of MySQL
Which of these types store the longest length of strings?(a) CHAR(b) VARCHAR(c) TINYTEXT(d) TEXTI had been asked this question in an online interview.This is a very interesting question from Choosing Data Types in division Data Types of MySQL
If a column is expected to store values up to 2 million, the best datatype for it is _____________(a) SMALLINT(b) TINYINT(c) MEDIUMINT(d) BIGINTI got this question by my school principal while I was bunking the class.The query is from Choosing Data Types topic in portion Data Types of MySQL
MySQL provides a date type that has an optional time part.(a) True(b) FalseI got this question in an online interview.The query is from Choosing Data Types in division Data Types of MySQL
Which datatype is best suited to store currency values?(a) INT(b) FLOAT(c) DOUBLE(d) DECIMALThe question was asked during an online interview.The origin of the question is Choosing Data Types in division Data Types of MySQL
The AUTO_INCREMENT column attribute is best used with which type?(a) FLOAT(b) INT(c) CHARACTER(d) DOUBLEI had been asked this question in semester exam.My question is taken from Choosing Data Types in section Data Types of MySQL

X’61626364′ and X’61626364′ are respectively __________(a) abcd and 1633837924(b) abcd and 4297383361(c) dcba and 1633837924(d) dcba and 4297383361I had been asked this question during an internship interview.Question is taken from Data Value Categories topic in division Data Types of MySQL

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment