A: user1是一个组
B: user1组的GID是500
C: user1组的密码是X
D: user1组成员有user2，user3
举一反三
- 下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';
- A user named User1 uses a computer that runs Windows XP Professional. You need to enable User1 to create local user accounts. You must minimize the rights assigned to the User1 account. Which group should you add User1 to?（） A: Administrators B: Power Users C: Users D: Network Configuration Operator
- A user named User1 uses a computer that runs Windows XP Professional. You need to enable User1 to create local user accounts. You must minimize the rights assigned to the User1 account. Which group should you add User1 to?（） A: Administrators B: Power Users C: Users D: Network Configuration Operators
- 如果要删除user数据库中的user1表，可以使用下列哪个命令______ A: ALERT TABLE user1 B: DROP TABLE user1 C: DELETE TABLE user1 D: TRUNCATE TABLE user1
- Your network contains an Active Directory domain. A user named User1 takes a leave of absence for one year. You need to restrict access to the User1 user account while User1 is away. What should you do（） A: From the Default Domain Policy， modify the account lockout settings. B: From the Default Domain Controller Policy， modify the account lockout settings. C: From the properties of the user account， modify the Account options. D: From the properties of the user account， modify the Session settings.
内容
- 0
使用CREATE USER语句创建一个新用户,用户名为user2、密码为123 下面选项中,能实现上述功能的语句是 A: CREATE USER 'user2'@'localhost' IDENTIFIED BY '123'; B: CREATE USER user2@localhost IDENTIFIED BY 123; C: CREATE USER 'user2'@'localhost' IDENTIFIED TO '123'; D: CREATE USER user2@localhost IDENTIFIED TO '123';
- 1
使用GRANT语句创建用户名为user1、密码为123,并授予该用户对chapter08.student表有查询权限。 下面选项中,能实现上述功能的语句是 A: GRANT SELECT ON chapter08.student FOR 'user1'@'localhost' IDENTIFIED BY '123'; B: GRANT USER SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123'; C: GRANT USER SELECT ON chapter08.student 'user1'@'localhost' IDENTIFIED BY '123'; D: GRANT SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123';
- 2
下面使用DROP USER语句删除用户user1的语句中，正确的是（）
- 3
【多选题】下面语句可以实现查询user表中“zhangsan”的user,password,logins信息的是 A. select logins,user,password from user where name like ’%zhangsan%’; B. select user,password,logins, from user where name like ’zhangsan’; C. select password,logins,user from user where name=’zhangsan’ limit 1; D. select user,password,logins from user where name=’zhangsan’;
- 4
以下可以正确运行的查询语句有( ) A: select * from user ; B: select * from user where username =’李四’; C: select * from user where 1=1; D: select distinct * from user;