Multiple choice

JOHN is developing a form for customers to order tickets to events. There is a Date item in the Tickets block of the form that has a LOV whose record group uses the following query:

SELECT event_name, event_date

FROM events

ORDER BY event_date;

In the Choose_Event block of the form, he wants users to be able to select an event name into an Event_Name item.

The event name will be selected from a LOV that is sorted by the name of the event.

He does not want to modify either LOV or record group at run time. Which of the following statements is correct with regard to LOV and record group as specified at design time?

  1. He must define a new LOV for the Choose_Event.Event_Name item that uses a different record group.

  2. He must define a new LOV for the Choose_Event.Event_Name item, but he can base it on the same record group.

  3. He can use the same LOV and record group for the Choose_Event.Event_Name item that he used for the Tickets.Date item.

  4. He can use the same LOV for both items, but he should specify that each item must use a different record group for the LOV.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The two LOVs require different sorting - one by event_date (for the Date item) and one by event_name (for the Event_Name item). Since record groups contain the query including the ORDER BY clause, each LOV needs its own record group with the appropriate ORDER BY. They cannot share a record group because the sorting requirements are different.

Keep practicing — related questions