Free 1Z0-874 Web TestEngine Demo

Q7 Single choice

As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement:

GRANT SELECT, UPDATE, DELETE ON world.

* TO 'joe'@'example.com' Which of the following best describe the effects of issuing this statement?

A
The account is not created, as you must always specify a password for new users
B
Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.
C
An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.
D
Since no password is specified, the account is created with an empty password that must be changed by the user on first login
E
There is not enough information provided to determine the outcome of executing that statement.

1Z0-874 Web TestEngine demo