Which one of the following operators cannot be used to test whether a value is NULL ?
ISNULL()
<=>
IS NULL
=
The call strcmp('fred', 'Fred') returns
-1
1
2
Which of the following functions would you use to retrieve the name of a month from a date?
dayname()
extract()
subdate()
now()
Which of the following functions does MySQL use to encrypt its own internal user passwords?
password()
encrypt()
md5()
sha()
If we use a grouping function in a SELECT statement with no GROUP BY clause,
we will get a syntax error
the entire table will be treated as one group
the entire result set will be treated as one group
each row will be treated as one group