Exit 1Z0-874 MySQL 5.0 Database Administrator Certified Professional Exam, Part II
Question 2 of 5
0% complete
Q2 Multiple choice

Which of the following are true regarding the usage of the IDENTIFIED BY clause in the GRANT statement used to create a new user account?

Select all that apply.

  • A

    There is no IDENTIFIED BY clause for the GRANT statement

  • B

    The IDENTIFIED BY clause is always optional

  • C

    The IDENTIFIED BY clause is always mandatory

  • D

    The IDENTIFIED BY clause may be mandatory depending on the current SQL mode

  • E

    The IDENTIFIED BY clause specifies the password to be used with the account

  • F

    The IDENTIFIED BY clause specifies an alternate user name for the account

Previous Next