Oracle Application Express 5: Developing Web Applications — Question 19

What is the least error-prone way to split a long list into two lists?

Answer options

• A. Create an empty second list, copy selected list items from the first list to the second list, and then remove the copied list items from the first list.
• B. Create two new lists, copy list items from the initial list to the first list, copy the remaining list items from the initial list to the second list, and then delete the initial list.
• C. Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.
• D. Copy the entire list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries that are now in the second list.

Correct answer: C

Explanation

Option C is the least error-prone method because it allows for careful selection and verification of the entries being moved. The other options introduce higher risks of accidentally deleting or misplacing entries during copying or editing processes, which can lead to data loss or inconsistencies.