The stored-routine privileges are contained in . . . . . . . .

Solution (By Examveda Team)

This question asks about where MySQL stores the permissions for stored routines, like procedures and functions. Stored routines are powerful tools that allow you to create reusable blocks of code within your database.

Let's look at the options:

Option A: user – This refers to individual users and their access privileges. It doesn't directly store routine permissions.

Option B: db – This refers to the database itself. While the database holds the routines, it doesn't store the specific permissions for executing them.

Option C: tables_priv – This table stores permissions related to tables, like INSERT, UPDATE, and DELETE. It doesn't handle stored routine permissions.

Option D: procs_priv – This is the correct answer! The procs_priv table specifically stores permissions for stored routines, including who can execute them.

So, the procs_priv table holds all the information about which users are allowed to create, modify, and execute stored procedures and functions in a MySQL database.