OCP题库

我才是真的封不觉

于 2024-05-21 00:04:14 发布

阅读量381

点赞数 4

CC 4.0 BY-SA版权

文章标签：开闭原则

本文链接：https://blog.csdn.net/JavaCoder_juejue/article/details/139051295

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