Oracle Autonomous Database Cloud 2020 Specialist — Question 52

Several users continuously use custom-created formulas in Excel to supplement their Planning form inputs.
What is another design alternative to reduce offline Excel maintenance? Choose the best answer.

Answer options

• A. Cell commentary
• B. Reports
• C. Ad hoc forms
• D. Smart forms
• E. Smart push

Correct answer: D

Explanation

The correct answer is D, Smart forms, as they can automate data collection and reduce the reliance on Excel for offline maintenance. Other options, such as Cell commentary and Reports, do not directly address the need for less manual upkeep in Excel. Ad hoc forms and Smart push also do not provide the same level of automation and integration that Smart forms offer.