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
Question
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
Solution
- True
- CALL
- A function can only have input parameters, A function always returns a value.
- @variable_name = value;
- It makes sure that the function always returns the same result for the same input parameters.
- IN parameter
- INSERT, UPDATE, DELETE
- BEFORE INSERT
- Recurring events, One-time events
- IF NOT EXISTS
Similar Questions
3.Question 3Fill in the blank: A _____ is a coding technique that executes SQL statements before passing them onto the database.1 pointprepared statementSQL injectionbotnetphishing kit
Which function in PHP can be utilised to query an MySQL database with an SQL statement?a. sql()b. mysql()c. query()d. mysqli_query()e. None of the above.
________ is a program that performs some common action on database data and also stored in the database.Stored ProcedureTriggerStored FunctionNone of the above
SELECT operation of SQL is a: A. data manipulation language B. data definition language C. data control language. D. data query language
give short definition for procedures in pl sql
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.