adplus-dvertising
frame-decoration

Question

Which variable is set to zero when automatic privilege granting is not needed?

a.

automatic_sp_privileges

b.

automatic_ps_privileges

c.

automatic_pg_privileges

d.

automatic_gp_privileges

Posted under Stored Programs MySQL Database

Answer: (a).automatic_sp_privileges

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which variable is set to zero when automatic privilege granting is not needed?
Add Comment

Similar Questions

Discover Related MCQs

Q. Which procedure parameter enables the caller to pass in a value and get back a value?

View solution

Q. The IN, OUT and INOUT keywords do not apply to stored functions.

View solution

Q. For the same input parameters, if the stored function returns the same result, it is called _____________

View solution

Q. Triggers enable to enforce data integrity constraints.

View solution

Q. Which statement is used to create a trigger?

View solution

Q. For which of the following are triggers not supported?

View solution

Q. Which statement is used to remove a trigger?

View solution

Q. Before MySQL 5.1.6 which privilege was required to create and drop triggers?

View solution

Q. The TRIGGER privilege is used for the table to be able to create and drop triggers for it.

View solution

Q. Which of these is a stored program associated with a schedule?

View solution

Q. The event scheduler does not run by default.

View solution

Q. Which of the following lines is used to turn on the event scheduler?

View solution

Q. Which statement is used to check the status of the event scheduler at runtime?

View solution

Q. Which value of event_scheduler enables checking status but not changing it at runtime?

View solution

Q. If the scheduler is stopped, no events run.

View solution

Q. Which log does the event scheduler log to?

View solution

Q. Which clause specifies periodic execution at fixed intervals?

View solution

Q. To create or drop events for a database, which privilege should be granted?

View solution

Q. The default definer of an event is the user who _______________

View solution

Q. The creation of a stored program is similar to the definition of a _______________

View solution
View All MCQs on Stored Programs

Suggested Topics

Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Neural Networks

Dive into the world of Artificial Intelligence with our Neural Networks MCQs. Uncover...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...