Oracle
1Z0-888 · Question #41
1Z0-888 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-888 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Security
Question
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 webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and 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?Options
- AThe user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
- BThe user will get an error because he or she did not put the database name in front of the stored procedure name.
- CThe stored procedure named get_reports will be dropped.
- DThe user will get an error because he or she does not have the permission to drop stored procedures.
Unlock 1Z0-888 to see the answer
You've previewed enough free 1Z0-888 questions. Unlock 1Z0-888 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#stored procedures#privilege grants#object ownership#DROP permissions