MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Temporary stored procedures are stored in _________ database. |
| A. | Master |
| B. | Model |
| C. | User specific |
| D. | Tempdb |
| Answer» E. | |
| 2. |
A stored procedure in SQL is a___________ |
| A. | Block of functions |
| B. | Group of Transact-SQL statements compiled into a single execution plan. |
| C. | Group of distinct SQL statements. |
| D. | None of the mentioned |
| Answer» C. Group of distinct SQL statements. | |
| 3. |
The format for compound statement is |
| A. | Begin . end |
| B. | Begin atomic . end |
| C. | Begin . repeat |
| D. | Both Begin . end and Begin atomic . end |
| Answer» E. | |
| 4. |
Which of the following is used to input the entry and give the result in a variable in a procedure? |
| A. | Put and get |
| B. | Get and put |
| C. | Out and In |
| D. | In and out |
| Answer» E. | |