Quiz


1:

Which one of the following operators cannot be used to test whether a value is NULL ?

  1. ISNULL()

  2. <=>

  3. IS NULL

  4. =

2:

The call strcmp('fred', 'Fred') returns

  1. -1

  2. 1

  3. 2

3:

Which of the following functions would you use to retrieve the name of a month from a date?

  1. dayname()

  2. extract()

  3. subdate()

  4. now()

4:

Which of the following functions does MySQL use to encrypt its own internal user passwords?

  1. password()

  2. encrypt()

  3. md5()

  4. sha()

5:

If we use a grouping function in a SELECT statement with no GROUP BY clause,

  1. we will get a syntax error

  2. the entire table will be treated as one group

  3. the entire result set will be treated as one group

  4. each row will be treated as one group




MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net