首页 试题详情
多选题


Choose two.
Examine this statement, which executes successfully:
CREATE USER mary@192.0.2.100 IDENTIFIED BY ‘P@SSw0rd‘ REQUIRE NONE PASSWORD EXPIRE;
Which two are true?

AMary must connect using the username ‘mary@192.0.2.100‘.

BMary requires no password to connect to the MySQL server.

CMary must connect from the client machine 192.0.2.100.

DMary cannot connect to the MySQL server until the DBA resets her password.

EMary cannot query data until she changes her password.

查看答案
正确答案：A （备注：此答案有误）

相似试题

  • 多选题

    Choose two.Examine this command and output:

    答案解析

  • 多选题

    Choose two.Examine this statement:Mysql> DROP ROLE r_role1, r_role2; Which two are true?

    答案解析

  • 多选题

    Choose two.Examine this command and output:Select * from table_lock_waits_summary_by_table where COUNT_STAR > 0 limit 1 GWhich two are true?

    答案解析

  • 多选题

    Choose two.Examine this statement, which executes successfully:CREATE USER mary@192.0.2.100 IDENTIFIED BY ‘P@SSw0rd‘ REQUIRE NONE PASSWORD EXPIRE;Which two are true?

    答案解析

  • 单选题

    Choose the best answer. Examine this output:

    答案解析

热门题库