Oracle 1Z0-419 Exam Questions & Answers

Which two statements are true about the Key Exists validator? (Choose two.)

A. it always issues a select to the database to ensure all data is up to date.

B. it first checks the cache for match and then goes to the database only if necessary.

C. it cannot validate any data changes that happened in the current transaction that have not yet been committed to the database.

D. it can validate any data changes that happened in the current transaction that have not yet been committed to the database.

E. it can be used only with attributes that are defined as primary keys in the database.

Which two statements are true about unbounded task flows? (Choose two.)

A. They must have a defined entry point.

B. They must have a defined exit point

C. They may pass parameters to bounded task flows.

D. They can use method calls but not routers to control navigation.

E. Parameters cannot be passed to an unbounded task flow.

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.)

A. Define a view criteria on each view object at design time to apply the predicate to the corresponding view object, ensuring the view criteria is defined against the view object instance in the Application Module Editor

B. Override each view object's ViewObjectlmpI class methods to programmatically modify each view object's where clause at run time to add the predicate to the select clause regardless of the query executed.

C. Create a complete set of custom ADF Business Component framework classes for your business components and then override your custom ViewObjectlmpI class to programmatically modify each view object's where clause at run time to append the predicate.

D. in each view object, simply type the predicate into the WHERE clause of the View Object Editor query page.