1Z0-888 Exam Dumps | The following grants were executed: GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%'; GRANT ALTER ON

<< Prev Question Next Question >>

Question 4/15

The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand wants to delete the stored procedure named get_reports,and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?

A. The user will get an error because he or she did not put the database name in front of the stored procedure name.

B. The user will get an error because he or she did not use the ALTERstatement to drop the stored procedure.

C. The user will get an error because he or she does not have the permission to drop stored procedures.

D. The stored procedure named get_reportswill be dropped.

Question 4/15

LEAVE A REPLY

Download PDF File