Q10.Which of the following statements about stored procedures are true?*2 pointsProviding a parameter list to CREATE PROCEDURE is optionalStored procedures are case-sensitiveStored procedures cannot be imported from one database system to anotherStored procedures are saved in the table mysql.proc

Which of the following can a stored procedure use?1 pointA stored procedure cannot accept parameters.Input parametersInput and output parametersOutput parameters

The benefits of stored procedures include which of the following? 1 pointReduction in network trafficImprovement in performanceReuse of codeAll of the above

Q8.Stored procedures with which of the following option have access privileges that are same as the MySQL user who defined the stored procedure?*1 pointSQL SECURITY DEFINERSQL SECURITY USERSQL SECURITY INVOKERSQL SECURITY CREATOR

Which of the following is not true about SQL statements?1.0 MarksSQL statements are not case sensitive.SQL statements can be written on one or more lines.Keywords cannot be split across lines.Clauses must be written on separate lines.

1.Question 1You can use MySQL stored procedures and functions to call a code block to perform a specific operation by invoking the identifier name.1 pointTrueFalse2.Question 2Your MySQL database contains a stored procedure called GetProductDetails(). What keyword can you use to invoke this stored procedure in the following statement?1________ GetProductDetails();1 point3.Question 3Which of the following statements is true of MySQL functions? Select all that apply.1 pointA function can only have input parameters.A function can have both input and output parameters.A function can only have output parameters.A function always returns a value.4.Question 4What’s the correct syntax to create a user-defined variable in MySQL?1 pointvar variable_name = value;variable_name = value;@variable_name = value;5.Question 5What does the DETERMINISTIC keyword do in the following syntax?123CREATE FUNCTION function_name()RETURNS datatype DETERMINISTICRETURN1 pointIt makes sure that the function always returns the same result for the same input parameters.It makes sure that the function returns different results for different input parameters.It makes sure that the function returns different results for the same input parameters.6.Question 6What type of parameter is the following syntax an example of?1SET @y_number = 10; 1 pointINOUT parameterOUT parameterIN parameter7.Question 7Which of the following events or SQL operations can MySQL triggers be invoked on? Select all that apply.1 pointINSERTUPDATESELECTDELETECREATE8.Question 8You need to impose a business rule that checks values before they’re added to a table. What type of trigger can you use to implement this rule?1 pointBEFORE UPDATEAFTER INSERTBEFORE INSERTAFTER UPDATE9.Question 9Which of the following options are examples of Scheduled Events that can be created in MySQL? Select all that apply.1 pointUPDATE eventsDELETE eventsRecurring eventsINSERT eventsOne-time events10.Question 10You are creating an event in MySQL using the following syntax. However, MySQL should only create the event if it doesn't already exist in the database. What keyword can you use to complete this syntax?1234CREATE EVENT _______________ event_nameON SCHEDULE schedule_logicDOEvent_body1 point