MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
For the same input parameters, if the stored function returns the same result, it is called _____________ |
| A. | deterministic |
| B. | non deterministic |
| C. | regular |
| D. | monotonous |
| Answer» B. non deterministic | |
| 2. |
The IN, OUT and INOUT keywords do not apply to stored functions. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 3. |
Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called? |
| A. | PI() |
| B. | sampdb.PI() |
| C. | MySQL.PI() |
| D. | db.PI() |
| Answer» C. MySQL.PI() | |
| 4. |
FOR_THE_SAME_INPUT_PARAMETERS,_IF_THE_STORED_FUNCTION_RETURNS_THE_SAME_RESULT,_IT_IS_CALLED______________?$ |
| A. | deterministic |
| B. | non deterministic |
| C. | regular |
| D. | monotonous |
| Answer» B. non deterministic | |
| 5. |
What_is_abc_in_the_following_statement?$ |
| A. | |
| B. | action |
| C. | condition value |
| Answer» B. action | |
| 6. |
The IN, OUT and INOUT keywords do not apply to stored functions? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
Which procedure parameter enables the caller to pass in a value and get back a value? |
| A. | IN |
| B. | OUT |
| C. | INOUT |
| D. | GETINOUT |
| Answer» D. GETINOUT | |
| 8. |
Which variable is set to zero when automatic privilege granting is not needed? |
| A. | automatic_sp_privileges |
| B. | automatic_ps_privileges |
| C. | automatic_pg_privileges |
| D. | automatic_gp_privileges |
| Answer» B. automatic_ps_privileges | |
| 9. |
Which privilege must be given to the database to create a stored function or procedure? |
| A. | CREATE ROUTINE |
| B. | CREATE METHOD |
| C. | CREATE FUNCTION |
| D. | CREATE PROCEDURE |
| Answer» B. CREATE METHOD | |
| 10. |
Suppose a stored function named PI() is written in the database ‘sampdb’. How would it be called?$ |
| A. | PI() |
| B. | sampdb.PI() |
| C. | MySQL.PI() |
| D. | db.PI() |
| Answer» C. MySQL.PI() | |
| 11. |
How many values can be returned from a stored procedure? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» B. 1 | |
| 12. |
How many values can be returned from a given stored function? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» C. 2 | |
| 13. |
To produce a stored function, which statement is used? |
| A. | PRODUCE FUNCTION |
| B. | CREATE FUNCTION |
| C. | PRODUCE PROCEDURE |
| D. | CREATE PROCEDURE |
| Answer» C. PRODUCE PROCEDURE | |