‏Linux系统命令提示符为[user1@localhost root]$，当然用户所在目录为（ ）‏ A: user B: localhost C: root D: $

下面使用DELETE语句删除用户user2的语句中,正确的是 A: DELETE FROM mysql.user WHERE Host='localhost' AND User='user2'; B: DELETE FROM mysql.user WHILE Host='localhost' AND User='user2'; C: DELETE FROM mysql.user WHERE Host='localhost' OR User='user2'; D: DELETE FROM mysql.user WHILE Host='localhost' OR User='user2';

如果要删除user数据库中的user1表，可以使用下列哪个命令______ A: ALERT TABLE user1 B: DROP TABLE user1 C: DELETE TABLE user1 D: TRUNCATE TABLE user1

假设需要导出某个表table1，只导出表结构，不导出数据，可以使用如下（）命令。 A: EXP user/pwd tables=（name,table1）file=export.dmp Rows=y B: EXP user1/pwd table table1 file=extable1.dmp C: EXP user/pwd tables=（name,table1）file=export.dmp Rows=n D: EXP user1/pwd table=table1 file=extable1.dmp Rows=

使用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';