Informatics Practices
Related Questions
Which of the following is not a valid aggregate function in MYSQL ?
- COUNT()
- SUM()
- MAX()
- LEN()
What will be printed by the given query ?
SELECT LENGTH("WINNER");
- 7
- 6
- 8
- 9
If the substring is not present in a string, the INSTR() returns:
- -1
- 1
- NULL
- 0
What will be returned by the given query ?
SELECT concat("It", "was", "ok");
- "It was ok"
- "It wasok"
- "Itwasok"
- "Itwas ok"