删除用户账户命令是( )
A: DROP USER
B: DROP TABLE USER
C: DELETE USER
D: DELETE FROM USER
A: DROP USER
B: DROP TABLE USER
C: DELETE USER
D: DELETE FROM USER
A
举一反三
- 哪个能实现删除用户的命令( )。 A: delete from MySQL.user B: delete user C: drop root D: truncate user
- 在 MySQL 中,删除用户的命令是( ) A: DROP USER B: REVOKE USER C: DELETE USER D: REMOVE USER
- 删除用户的同时删除用户所拥有的全部对象的正确命令是() A: drop user username cascade B: drop user username C: delete user username D: delete user username cascade
- hive中清空表user的HQL语句为( ) A: delete from user; B: remove table user; C: drop table user; D: truncate table user;
- 下列选项中,可以删除表user中所有记录的SQL语句是( )。 A: DELETE TABLE `user` B: DELETE FROM `user` C: DELETE `user` D: ALTER TABLE DELETE `user`
内容
- 0
删除用户账号lisi,且lisi账号存储在其他表中的权限也一并被删除,相对应的命令是( )。 A: drop user 'lisi'@'%'; B: drop 'lisi'@'%'; C: delete 'lisi'@'%'; D: delete from user where user='lisi' and host='%';
- 1
下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';
- 2
删除数据库user的命令为drop database user
- 3
【单选题】如何删除students表中的所有记录() A. Drop table students; B. Delete from students; C. Alter table students; D. delete user students;
- 4
以下不是修改表操作的是( ) A: drop table user; B: alter table user add remark varchar(20); C: alter table user character set utf8; D: alter table user drop remark;