You are designing a database for a web-based ticket reservation application. There might be 500 or more tickets available for any single event. Most users of the application will view fewer than 50 of the available tickets before purchasing tickets. However, it must be possible for a user to view the entire list of available tickets. As the user scrolls through the list, the list should be updated to reflect that tickets have been sold to other users. The user should be able to select tickets from the list and purchase the tickets. You need to design a way for the user to view and purchase available tickets. What should you do?

39.

You are designing a database for a web-based ticket reservation application.
There might be 500 or more tickets available for any single event.
Most users of the application will view fewer than 50 of the available tickets before purchasing tickets.
However, it must be possible for a user to view the entire list of available tickets.
As the user scrolls through the list, the list should be updated to reflect that tickets have been sold to other users.
The user should be able to select tickets from the list and purchase the tickets.
You need to design a way for the user to view and purchase available tickets.

What should you do?

Use a scrollable static cursor to retrieve the list of tickets. Use positioned updates within the cursor to make purchases.

Use a scrollable dynamic cursor to retrieve the list of tickets. Use positioned updates within the cursor to make purchases

Use a stored procedure to retrieve the list of tickets.
Use a second stored procedure to make purchases.

Use a user-defined function to retrieve the list of tickets.
Use a second stored procedure to make purchases

View Description

No description found.