MySQL Functions

Front

Which of the following is not a text function? Options: TRIM(), LEFT(), MID(), TRUNCATE()

Back

TRUNCATE()

Front

Which of the following is not a numeric function?

MOD

,

SIGN

,

MID

,

POW

Back

MID

Front

Which of the following is not a date function?

Month

,

Year

,

Now

,

Pow

Back

Pow

Front

Which of the following functions returns the substring from a given string? Options: MID, INSTR, SUBSTR, CHAR

Back

MID, INSTR, SUBSTR

Front

Which function returns the position of a substring in a given string? Options: MID, INSTR, SUBSTR, CHAR

Back

INSTR

Front

What will be printed by the given query? SELECT LENGTH("WINNER");

Back

6

Front

What will be returned by the query: SELECT INSTR("INDIA", "DI");

Back

3

Front

What will be returned by the query: SELECT concat("It", "was", "ok");

Back

"Itwasok"

Front

What will be returned by the given query? SELECT round(153.669, 2);

Back

153.67

Front

What will be returned by the given query? SELECT sign(26);

Back

1