MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The size of a _____ is simply V(A,r) where r is the relation and A is a distinct value |
| A. | Projection |
| B. | Outer join |
| C. | Aggregation |
| D. | Inner join |
| Answer» D. Inner join | |
| 2. |
Size estimation can be done for which of the following processes? |
| A. | Projection |
| B. | Aggregation |
| C. | Set operation |
| D. | All of the mentioned |
| Answer» E. | |
| 3. |
State true or false: Estimation of the size of the result of a join is not possible |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
SIZE_ESTIMATION_CAN_BE_DONE_FOR_WHICH_OF_THE_FOLLOWING_PROCESSES??$ |
| A. | Projection |
| B. | Aggregation |
| C. | Set operation |
| D. | All of the mentioned |
| Answer» E. | |
| 5. |
The_size_of_a_______is_simply_V(A,r)_where_r_is_the_relation_and_A_is_a_distinct_value$ |
| A. | Projection |
| B. | Outer join |
| C. | Aggregation |
| D. | Inner join |
| Answer» D. Inner join | |
| 6. |
State true or false: Estimation of the size of the result of a join is not possibl? |
| A. | True |
| B. | False |
| Answer» C. | |
| 7. |
The intersection of all records satisfying the individual simple conditions Oi is called as ________ |
| A. | Conjunctive selection |
| B. | Disjunctive selection |
| C. | Negation |
| D. | None of the mentioned |
| Answer» B. Disjunctive selection | |
| 8. |
The union of all records satisfying the individual simple conditions Oi is called as ________ |
| A. | Conjunctive selection |
| B. | Disjunctive selection |
| C. | Negation |
| D. | None of the mentioned |
| Answer» C. Negation | |
| 9. |
The ________ SQL command generates statistics on a particular relation |
| A. | Statistic |
| B. | Analyze |
| C. | Modify |
| D. | Runstats |
| Answer» C. Modify | |
| 10. |
What kind of a sample must be used for statistical analysis? |
| A. | A random sample |
| B. | A sample having excessive representation of a relation |
| C. | A sample having suppressive representation of a relation |
| D. | None of the mentioned |
| Answer» B. A sample having excessive representation of a relation | |
| 11. |
What is the function of the equi-width histogram? |
| A. | Adjusts boundaries of the ranges such that each range has the same number of values |
| B. | Divides range of values into equal sized ranges |
| C. | Divides the range of values into ideally sized ranges |
| D. | Does not divide the range of values. |
| Answer» C. Divides the range of values into ideally sized ranges | |
| 12. |
Most databases store the distribution of values for each attribute as a __________ |
| A. | Histogram |
| B. | Pie chart |
| C. | Line graph |
| D. | None of the mentioned |
| Answer» B. Pie chart | |
| 13. |
Which of the following information does the database system catalog store? |
| A. | Number of tuples |
| B. | Number of blocks |
| C. | Size of a tuple of a relation |
| D. | All of the mentioned |
| Answer» E. | |