SQL Functions Quiz

Which of the following is not a text function?

• TRIM()

• LEFT()

• MID()

• MOD()

Which of the following is not a numeric function?

• MOD()

• SIGN()

• MID()

• POW()

Which of the following is not a date function?

• Month()

• MID

• NOW()

• YEAR()

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

• UPPER()

• LENGTH()

• MID

• INSTR()

Which one of the following is not an aggregate function?

• ROUND()

• SUM()

• COUNT()

• AVG()

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

• INSTR()

• SUBSTR()

• TRIM()

• MID()

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

• 3

• 2

• 0

• Error

Which of the following is not a valid aggregate function in MYSQL?

• SUM()

• COUNT()

• COUNT(*)

• AVERAGE()

Which of the following SQL functions does not belong to the Math functions category?

• ROUND()

• SUBSTR

• POW()

• ROUND()

If the substring is not present in a string, the INSTR returns:

(a)