MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 3 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The functions which construct histograms and use buckets for ranking is |
| A. | Rank() |
| B. | Newtil() |
| C. | Ntil() |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 2. |
If there are n tuples in the partition and the rank of the tuple is r, then its ________ is defined as (r 1)/(n 1). |
| A. | Ntil() |
| B. | Cum_rank |
| C. | Percent_rank |
| D. | rank() |
| Answer» D. rank() | |
| 3. |
Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query. |
| A. | Base, recursive |
| B. | Recursive, Base |
| C. | Base, Redundant |
| D. | View, Base |
| Answer» B. Recursive, Base | |