CC105-Information Management

Which keyword is used to create a stored procedure in MySQL?

• CREATE

• PROCEDURE

• STORED

• BEGIN

What is the purpose of using parameters in stored procedures?

• To pass values into and out of the stored procedure

• To return multiple result sets

• To define the execution order of statements

• To perform transaction control

Which statement is used to call a stored procedure in MySQL?

• CALL

• RUN

• EXECUTE

• PERFORM

What keyword is used to define the beginning of the stored procedure body?

• BEGIN

• OPEN

• START

• INIT

Which clause is used to define the parameters of a stored procedure?

• DECLARE

• SET

• PARAMETERS

• IN / OUT / INOUT

What does the INOUT keyword signify in a stored procedure parameter?

• The parameter can be used for both input and output

• The parameter is for output only

• The parameter is optional

• The parameter is for input only

Which MySQL command is used to drop a stored procedure?

• DROP PROCEDURE

• REMOVE PROCEDURE

• DELETE PROCEDURE

• ERASE PROCEDURE

What does the DELIMITER command do in MySQL stored procedures?

• Changes the statement termination character

• Sets the storage engine for the procedure

• Changes the default comment style

• Defines the data types of variables

What is the maximum number of parameters allowed in a MySQL5.7 stored procedure?

• 100

• 255

• 512

• Unlimited

Which command is used to show the source code of a stored procedure?

• SHOW PROCEDURE CODE

• SHOW CREATE PROCEDURE

• DISPLAY PROCEDURE

• DESCRIBE PROCEDURE