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. |
In_which_scenario_would_you_use_the_ROLLUP_operator_for_expression_or_columns_within_a_GROUP_BY_clause?$ |
| A. | To find the groups forming the subtotal in a row |
| B. | To create group-wise grand totals for the groups specified within a GROUP BY clause |
| C. | To create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals |
| D. | To create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals |
| Answer» D. To create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals | |
| 2. |
__________ are used to ensure that transactions access each data item in order of the transactions’ ____ if their accesses conflict.$ |
| A. | Zone |
| B. | Relay |
| C. | Line |
| D. | Timestamps |
| Answer» E. | |
| 3. |
A concurrency-control policy such as this one leads to ______ performance since it forces transactions to wait for preceding transactions to finish before they can start. |
| A. | Good |
| B. | Average |
| C. | Poor |
| D. | Unstable |
| Answer» D. Unstable | |
| 4. |
In concurrency control policy the lock is obtained on |
| A. | Entire database |
| B. | A particular transaction alone |
| C. | All the new elements |
| D. | All of the mentioned |
| Answer» B. A particular transaction alone | |