MySQL - Stored Procedures MCQ

MySQL – Stored Procedures MCQ

1 / 25

1. What is a stored procedure in MySQL?

A precompiled set of SQL statements

A table

A database trigger

A database schema

2 / 25

2. What is one of the primary benefits of using stored procedures in MySQL?

Data duplication

Data normalization

Code redundancy

Performance optimization

3 / 25

3. Which SQL statement is used to create a stored procedure in MySQL?

CREATE PROCEDURE

CREATE INDEX

CREATE FUNCTION

CREATE TRIGGER

4 / 25

4. What role do input parameters play in stored procedures?

They store data in tables

They allow passing values into the procedure

They enforce data constraints

They retrieve data from tables

5 / 25

5. What keyword is used to specify an input parameter in a MySQL stored procedure?

OUT

VAR

PARAMETER

6 / 25

6. How do you call a stored procedure in MySQL?

RUN

CALL

SELECT FROM

EXECUTE

7 / 25

7. Which MySQL statement allows you to alter an existing stored procedure?

UPDATE PROCEDURE

ALTER PROCEDURE

ALTER FUNCTION

MODIFY PROCEDURE

8 / 25

8. What is the purpose of using output parameters in stored procedures?

To return values from the procedure

To pass values into the procedure

To store data in tables

To retrieve data from tables

9 / 25

9. How can you drop a stored procedure in MySQL?

DROP PROCEDURE

DELETE PROCEDURE

DROP FUNCTION

REMOVE PROCEDURE

10 / 25

10. Which of the following is NOT a benefit of using stored procedures in MySQL?

Enhanced modularity

Code reusability

Improved security

Reduced performance

11 / 25

11. What is the purpose of the DELIMITER statement when creating stored procedures in MySQL?

To set the procedure name

To separate SQL statements

To define input parameters

To specify the database name

12 / 25

12. Which keyword is used to mark the beginning of a stored procedure’s body in MySQL?

START

PROCEED

BEGIN

EXECUTE

13 / 25

13. What is the primary benefit of using stored procedures in terms of security?

Reducing authentication requirements

Enabling direct table access

Exposing sensitive data

Preventing SQL injection

14 / 25

14. What role do output parameters play in a MySQL stored procedure?

They store data in tables

They return values from the procedure

They allow passing values into the procedure

They retrieve data from tables

15 / 25

15. Which statement is used to execute the body of a stored procedure in MySQL?

EXECUTE

BEGIN

CALL

RUN

16 / 25

16. What is the primary purpose of using the OUT keyword when defining parameters in a stored procedure?

To enforce data constraints

To pass values into the procedure

To return values from the procedure

To specify the input parameters

17 / 25

17. How can you modify the code of an existing stored procedure in MySQL?

MODIFY PROCEDURE

UPDATE PROCEDURE

ALTER PROCEDURE

CREATE PROCEDURE

18 / 25

18. Which MySQL statement is used to list all the stored procedures in a database?

LIST PROCEDURES

DESCRIBE PROCEDURES

SHOW PROCEDURES

SHOW FUNCTIONS

19 / 25

19. What is the purpose of using the CALL statement in MySQL?

To list all stored procedures

To create a new stored procedure

To drop a stored procedure

To call a stored procedure

20 / 25

20. Which of the following SQL statements is used to remove a stored procedure from a MySQL database?

TRUNCATE PROCEDURE

DROP PROCEDURE

DELETE PROCEDURE

REMOVE PROCEDURE

21 / 25

21. What is the primary role of input parameters in MySQL stored procedures?

To pass values into the procedure

To store data in tables

To return values from the procedure

To retrieve data from tables

22 / 25

22. What is the primary benefit of using the DELIMITER statement in MySQL stored procedures?

To define input parameters

To specify the database name

To separate SQL statements

To set the procedure name

23 / 25

23. Which keyword marks the end of a stored procedure’s body in MySQL?

TERMINATE

END

FINISH

STOP

24 / 25

24. Which statement is used to execute a stored procedure in MySQL?

BEGIN

RUN

CALL

EXECUTE

25 / 25

25. What is the primary benefit of using the OUT keyword when defining parameters in a stored procedure?

To return values from the procedure

To enforce data constraints

To specify the input parameters

To pass values into the procedure

Your score is