MySQL Functions

Which of the following is not a text function?

• TRIM()

• TRUNCATE()

• LEFT()

• MID()

Which of the following is not a numeric function?

• MOD

• SIGN

• MID

• POW

Which of the following is not a date function?

• Month

• Year

• Now

• Pow

Which of the following functions returns the substring from a given string?

• MID

• INSTR

• SUBSTR

• CHAR

Which of the following functions returns the position of a substring in a given string?

• MID

• INSTR

• SUBSTR

• CHAR

What will be printed by the given query?

SELECT LENGTH("WINNER");

• 7

• 6

• 8

• 9

What will be returned by the given query?

SELECT INSTR("INDIA", "DI");

• 2

• 3

• -2

• -3

What will be returned by the given query?

SELECT concat("It", "was", "ok");

• "It was ok"

• "Itwasok"

• "Itwas ok"

• "Tt wasok"

What will be returned by the given query?

SELECT round(153.669, 2);

• 153.6

• 153.66

• 153.67

• 153.7

What will be returned by the given query?

SELECT sign(26);

• 1

• -1

• 0

• none