MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How many of the following can be used in stored functions?PREPARE, EXECUTE, DEALLOCATE PREPARE |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» E. None of these | |
| 2. |
How many of the following can be used in stored procedures?PREPARE, EXECUTE, DEALLOCATE PREPARE |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» B. 2 | |
| 3. |
A stored procedure is invoked using the statement __________. |
| A. | CALL |
| B. | RETURN |
| C. | INVOKE |
| D. | SEE |
| E. | None of these |
| Answer» B. RETURN | |
| 4. |
When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________. |
| A. | fare |
| B. | good |
| C. | bad |
| D. | illegal |
| E. | None of these |
| Answer» D. illegal | |
| 5. |
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________. |
| A. | fare |
| B. | bad |
| C. | good |
| D. | illegal |
| E. | None of these |
| Answer» D. illegal | |
| 6. |
The creation of a stored program is similar to the definition of a _______________. |
| A. | Event |
| B. | Table |
| C. | Trigger |
| D. | View |
| E. | None of these |
| Answer» E. None of these | |