nerdexam
Oracle

1Z0-419 · Question #41

Your database has a strict security requirement that whenever users select from any table in the database schema, they must append the select statement with an additional where predicate that…

The correct answer is C. Create a complete set of custom ADF Business Component framework classes for your business. See the full explanation below for the reasoning.

Question

Your database has a strict security requirement that whenever users select from any table in the database schema, they must append the select statement with an additional where predicate that returns only records WHERE owner = :pUserName. This restricts users to seeing only records that they own. When you design and develop the ADF Business Components in your ADF application, there will be more than 100 view objects that select against this database. You want to build a solution that not only ensures all your developers, when writing view objects, meet the database's strict security requirement, but takes the least amount of development effort for your entire team and is easy to maintain in the long term. Identify the correct solution. (Choose the best answer.)

Options

  • ADefine a view criteria on each view object at design time to apply the predicate to the
  • BOverride each view object's ViewObjectlmpI class methods to programmatically modify each view
  • CCreate a complete set of custom ADF Business Component framework classes for your business
  • Din each view object, simply type the predicate into the WHERE clause of the View Object Editor

How the community answered

(47 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    83% (39)
  • D
    11% (5)

Community Discussion

No community discussion yet for this question.

Full 1Z0-419 Practice