For your EmployeesVO view object, you want to return only those employees who have a salary greater than
1000.
Which two options would you use to achieve this declaratively in ADF Business Components?
A.
Change the Order By clause in the view object.
B.
Change the Where clause in the view object to be: Salary > 1000.
C.
Create a bind variable called Salary and set the value to 1000.
D.
In the view object definition, create a view criteria that defines Salary > 1000.
E.
In the view object definition, create a view criteria that defines Salary > 1000 and add the view criteria to the
view object instance.
F.
Create an entity object validation rule on the Salary attribute: Salary > 1000.
Explanation:
B: The setWhereClause method sets a WHERE clause bind value of the View Object’s query statement.
E: The createViewCriteria method creates a new view criteria (that is, “Query by Example”) object for this View
Object. A view criteria object is an alternative to using an arbitrary SQL statement. A view criteria is a list of row
criteria for a View Object’s WHERE clause, where a row criteria is an array containing criteria for the individual
attributes.
A view criteria is a more structured way of creating a SQL query WHERE clause. After setting various
conditions for the view criteria object, the application can call the applyViewCriteria method, which applies theview criteria to this View Object.
https://docs.oracle.com/cd/B14099_19/web.1012/b14022/oracle/jbo/ViewObject.html