Explore topic-wise InterviewSolutions in .

Correct answer is (a) True

The best I can explain: The DEFAULT def_value clause can be specified for every data type except the BLOB and TEXT TYPES, spatial types, or columns with the AUTO_INCREMENT ATTRIBUTE. The def_value HOLDS the default.

Correct choice is (a) True

The explanation: For EVERY DATA TYPE except the BLOB and TEXT types, spatial types, or columns with the AUTO_INCREMENT attribute, a DEFAULT def_value clause can be SPECIFIED to KEEP a default value for a column.

The CORRECT option is (c) LINESTRING

To EXPLAIN I would say: In MySQL, there are many spatial DATATYPES available for use. Some EXAMPLES are GEOMETRY, POINT, LINESTRING and POLYGON. The LINESTRING TYPE is used to represent a curve.

Correct CHOICE is (b) TIME

For explanation I WOULD say: MYSQL has some variety of date and time datatypes. These datatypes are crucial for representing records in a table. The ‘TIME’ type represents a time value, STORED in the ‘hh:mm:ss’ FORMAT.

Right answer is (a) VARCHAR

Explanation: In MySQL, there are a wide variety of string datatypes for use. STRINGS can even hold image and sound DATA. All the four OPTIONS are string type NAMES. VARCHAR represents a variable LENGTH non binary string.

Right answer is (b) BINARY

Easiest explanation: MySQL has a VARIETY of string datatypes for use. Strings can hold arbitrary binary DATA. All the four options are string type NAMES. BINARY is used for a FIXED length binary string.

Correct answer is (a) FLOAT

To elaborate: There are various numeric datatypes in MySQL. Some of them are TINYINT, SMALLINT, BIGINT, FLOAT, DOUBLE and BIT. ‘FLOAT’ is for SINGLE precision floating point numbers unlike DOUBLE.

The correct answer is (a) Yes

The explanation is: “TIMESTAMP” column will AUTOMATICALLY be populated with current Date/time by the Mysql SERVER, when any row MODIFIED.

Correct ANSWER is (a) YYYY

To ELABORATE: Default MEANS VALUES that are assumed by the SERVER.

Right answer is (a) YYYY-MM-DDHH:MI:SS

To EXPLAIN I WOULD say: DEFAULT MEANS values that are assumed by the server.

Right answer is (c) Temporal data type

To explain I WOULD say: Temporal data are used for storing DATE, Time, TimeStamp or DATETIME.

Correct ANSWER is (a) TOTAL of 1 digit

The best I can explain: NONE.

The correct ANSWER is (c) 12345

For explanation I would SAY: “float(5,0) says there should be total of five DIGIT, in which no digit should be at the RIGHT of the decimal.

The CORRECT OPTION is (C) Int

To ELABORATE: NONE.

The CORRECT CHOICE is (d) Both Whole and Natural numbers

The BEST EXPLANATION: None.

Right answer is (d) LONG TEXT

Explanation: Long text store 4, 294, 967, 295.

The CORRECT ANSWER is (a) VARCHAR(20) character set utf8;

To explain: None.

Right answer is (a) SHOW CHARACTER SET;

The best I can explain: NONE.

The CORRECT OPTION is (C) Varchar2

Easiest EXPLANATION: NONE.

The CORRECT CHOICE is (a) 255 bytes

The best EXPLANATION: None.

The CORRECT OPTION is (a) Varchar

The EXPLANATION: NONE.

The CORRECT option is (c) Either FIXED or Variable length string

For explanation: To STORE character data we can use two definitions

Char(20)/*fixed length */

VARCHAR(20) /* variable length */

Correct answer is (a) character_set_system

For explanation: The server is RESPONSIBLE for maintaining VARIOUS system variables INVOLVED in the character set support. The system VARIABLE ‘character_set_system’ indicates the character set used for STORING identifiers.

The CORRECT choice is (b) LENGTH()

The best EXPLANATION: The LENGTH() OPERATOR is used to measure the length of a MySQL STRING in terms of bytes. To measure the length of the string in terms of number of characters, CHAR_LENGTH() is used.

The CORRECT answer is (b) 2

The BEST explanation: In MySQL, the HEXADECIMAL values are case sensitive. The leading 0X is what makes it case sensitive. Not the lowercase ‘x’ notation is USED here. Numbers prefixed with ‘0X’ are illegal.

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.

Right choice is (c) 65536

For EXPLANATION I would say: In MySQL, string values are SPECIFIED using the standard SQL notation x’val’. Here, val is pairs of hexadecimal digits (‘0’ through ‘ 9 ’ and ‘ a ’ through ‘ f ’). x’ffff’ is 65536 in DECIMAL.

Right answer is (c) NO_BACKSLASH_ESCAPES

Best explanation: To turn off the SPECIAL meaning of backslash in MYSQL, and TREAT it as an ordinary character, the SQL mode named NO_BACKSLASH_ESCAPES is enabled. The escape sequence is TREATED as characters.

Right choice is (b) ‘\r’

To explain I WOULD say: MySQL provides the facility to use a wide range of escape SEQUENCES. They are special CHARACTERS. They begin with the backslash character. For example, ‘\r’ specifies carriage RETURN.

Right option is (B) False

Best explanation: MYSQL RECOGNIZES many escape sequences like other programming languages. An escape sequence begin with a backslash CHARACTER. The ‘\0’ is different from NULL. It is a zero valued byte.

Right answer is (d) string

The explanation: In MySQL, the string values are written by ENCLOSING them within quotes. Values LIKE ‘Alexander’, ‘Kolkata, INDIA’ and ‘2341’ are STRINGS. ‘2341’ looks like an integer but is a string.

Correct ANSWER is (a) True

For explanation I would say: In MySQL, the BIT values in the result set are DISPLAYED as binary STRINGS. In order to CONVERT them to integers, either a zero is added or the ‘CAST()’ operator is USED to cast them.

The CORRECT OPTION is (a) 0b

The best explanation: In MySQL, the bit-field values can be EITHER WRITTEN as b’VALUE’ or 0bvalue. Here, value is a sequence of digits zero or/and one. For example, b’1010′ and 0b1010 are decimal value 10.

Right answer is (a) double PRECISION FLOATING point

Easy explanation: When there is a need to convert a string to a NUMBER to EVALUATE an expression, it is first CONVERTED to a double precision floating point value. Then, it can be used to do arithmetic.