OCP题库

Q2.分析下面的语句和输出:

mysql> SHOW GRANTS FOR jsmith;
+-------------------------------------------------------------------------------------------------------------------+
IGrants for jsmith@% |
+-------------------------------------------------------------------------------------------------------------------+
|GRANT USAGE ON *.* TO ’jsmith'@ ‘%’ |
|GRANT UPDATE (Name) ON ‘world’ ,’ country’ TO ’jsmith'@ ‘%’; |
+-------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
jsmith 可以执行哪两条 SQL 语句?
A) UPDATE world.country SET Name='all' ;
B) UPDATE world. Country SET Name=' new' WHERE Name='old' ;
C) UPDATE world. country SET Name=' one' LIMIT 1 ;
D) UPDATE world. country SET Name=' first' ORDER BY Name LIMIT 1 ;
E) UPDATE world.country SET Name=CONCAT ('New ' ,Name) ;
Answer:AC