Quiz


1:

Which table in the mysql database is checked to see whether a user may connect?

  1. tables_priv

  2. db

  3. columns_priv

  4. user

2:

Which table is checked first to see whether a user may execute any particular query?

  1. user

  2. host

  3. db

  4. tables_priv

3:

If MySQL finds multiple rows in the user table with the same username, which row is used for authentication?

  1. The row with the most specific host value.

  2. The row with the most general host value.

  3. Any row that has the right password.

  4. None of the above.

4:

Which of the following privileges should you probably not grant to users?

  1. FILE

  2. PROCESS

  3. WITH GRANT OPTION

  4. All of the above

5:

Which user should mysqld run as?

  1. A low-privilege user

  2. Root

  3. Either a) or b)

  4. Neither a) nor b)




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