MYSQL Functions

Which of the following is not a text function?

• TRIM()

• TRUNCATE()

• LEFT()

• MID()

What will be printed by the given query?

SELECT LENGTH( " INFORMATICS PRACTICES");

• 21

• 22

• 23

• 24

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

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 round(153.669, 2);

• 153.6

• 153.66

• 153.67

• 153.7

What will be returned by the given query?

SELECT month('2020-05-11');

• 5

• 11

• May

• November