删除用户的同时删除用户所拥有的全部对象的正确命令是()
A: drop user username cascade
B: drop user username
C: delete user username
D: delete user username cascade
A: drop user username cascade
B: drop user username
C: delete user username
D: delete user username cascade
举一反三
- 删除用户账户命令是( ) A: DROP USER B: DROP TABLE USER C: DELETE USER D: DELETE FROM USER
- 在 MySQL 中,删除用户的命令是( ) A: DROP USER B: REVOKE USER C: DELETE USER D: REMOVE USER
- 用户表user中存在一个名字字段username,现查询名字字段中包含"凤"的用户,下列SQL语句中,正确的是() A: select * from user where username = '凤'; B: select * from user where username like '%凤%'; C: select * from user where username like '_凤_'; D: select * from user where username like '凤';
- 下面哪个表达式不能获取user对象的username属性( )。 A: ${user['username'] } B: ${user[username] } C: ; D: ${user.username }
- 哪个能实现删除用户的命令( )。 A: delete from MySQL.user B: delete user C: drop root D: truncate user