Mysql Developer Interview Questions and Answers

A stored procedure is a set of SQL statements that are stored in the database and can be called by name to perform a specific task.

• Stored procedures help improve performance by reducing network traffic and improving security.

• They can accept input parameters and return output parameters.

• Stored procedures can be reused across multiple applications.

• Examples: CREATE PROCEDURE, CALL PROCEDURE.

No, the delete command cannot be rolled back in MySQL.

• Delete command permanently removes data from a table.

• Rollback command can only be used with transactions involving insert, update, or alter commands.

• Once a delete command is executed, the data is gone and cannot be recovered.

• To undo a delete operation, you would need to restore the data from a backup.

Triggers are database objects that automatically perform an action when a specified event occurs.

• Triggers are used to enforce business rules, maintain data integrity, and automate repetitive tasks.

• They can be set to execute before or after an INSERT, UPDATE, or DELETE operation on a table.

• Examples of triggers include auditing changes to a table, updating a related table when a record is modified, or enforcing referential integrity.

Insert query is used to add new records into a database table.

• Use INSERT INTO statement followed by table name

• Specify column names in parentheses if not inserting values for all columns

• Values to be inserted are listed after VALUES keyword