问题描述：
[单选]
You inherit a legacy database system when the previous DBA， Bob， leaves the company．You are notified that users are getting the following error:（）当上一个DBA Bob离开公司时，您将继承一个遗留数据库系统。系统会通知您，用户收到以下错误：mysql> CALL film_in_stock （40， 2， @count）;ERROR 1449 （HY000）: The user specified as a definer （‘bob’@’localhost’） does not exist指定为定义者的用户（“bob”@“localhost”）不存在How would you identify all stored procedures that pose the same problem？如何识别所有引起相同问题的存储过程？
A．Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.
B．Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.
C．Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE DEFINER=’bob@localhost’;.
D．Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER=’bob’ and HOST=’ localhost’;.
E．Examine the Mysql error log for other ERROR 1449 messages.
参考答案：查看无
答案解析：无
☆收藏
答案解析：无
☆收藏
上一篇：When designing an InnoDB table， identify an advantage of using the BIT datatype Instead of one of the integer datatypes．（）在设计InnoDB表时，确定使用BIT数据类型而不是integer数据类型的优点。
下一篇：A simple master-to-slave replication is currently being used． The following information is extracted from the SHOW SLAVE STATUS output( )目前正在使用简单的主从复制。从显示从属状态输出中提取以下信息( )The table mytable on the slave contains the following( )从属服务器上的表mytable包含以下内容( )…You have issued a STOP SLAVE command． One or more statements are required before you canissue a START SLAVE command to resolve the duplicate key error．Which statement should be used？您已发出停止从属命令。您需要一个或多个语句才能执行此操作发出START SLAVE命令以解决重复密钥错误。哪个是否应该使用语句？
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.大门制作中，可在门上开设小门 2.2018年8月，“中国建筑工 3.中建集团企业愿景为：最具有国