Oracle Exam 1Z0-888 Topic 12 Question 37 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 37
Topic #: 12

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?

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.

Show Suggested Answer

Suggested Answer: C

by Lenna at May 06, 2022, 06:11 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-888 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!