Multiple choice technology

50)If we have four MVGs (without primaries) for each parent record and 10 parent records are displayed in the list applet,what is the total number of queries run to populate the list applet?

  1. a) 41

  2. b) 44

  3. c) 45

  4. d) 48

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

With 4 MVGs without primaries and 10 parent records displayed: 1 initial query fetches the 10 parent records. Each MVG field requires one query per parent record to fetch its child records (no primary means no optimized join). Total = 1 + (10 parents × 4 MVGs) = 1 + 40 = 41 queries. If MVGs had primaries, all 4 primary children would join in the initial query, reducing to just 1 query total.