Database - MySQL Grade 12 CBSE - Informatics Practices

Front

What will the following command in MySQL return? monthname('2020-05-06');

Back

May

Front

What would be the output of following:
round(2536.2265, 2);

Back

2536.23

Front

What will be the output of following MySQL statement? mod(1023, 100)

Back

23

Front

While of the following function would return today's name of the day: dayname (now()), today(), day(now()), today(date())?

Back

dayname (now())

Front

What would the following command return in MySQL: select power(5,4)?

Back

625

Front

What would the following MySQL function return? substring("mouse pad", 3,3)

Back

use

Front

What would be the output of following function? substr("Informatics Practices", -4,3)

Back

ice

Front

What would be the output of following command
select length(Practice makes perfect);

Back

This command is with error

Front

What is the output of the following function? instr("project work", 'work')

Back

9

Front

What would the following return?
right("elephant",3)

Back

ant