You create a view object “CustomersVO“ based on an entity object “CustomerEO”. How would you declaratively
change the result set returned from the view object so that the records are sorted by customer name? (Choose
the best answer.)
A.
Add ORDER BY CustomerName to the query in CustomersVO.
B.
Add ORDER BY CustomerName to the query in CustomerEO.
C.
Change the CustomersVO query mode to “Expert” and define the query using the ORDER BY clause as
required.
D.
Re-order the attributes in the CustomersVO editor such that the CustomerName attribute is listed first.
E.
Create a view criteria on CustomersVO to order by the CustomerName attribute.
Explanation:
The setOrderByClause method sets the ORDER BY clause of the view object’s query statement. Bind variables
can be specified using ‘?’ as a place-holder for the value. The new ORDER BY clause does not take effect until
RowSet.executeQuery() is called.
http://docs.oracle.com/cd/E12839_01/apirefs.1111/e10653/oracle/jbo/ViewObject.html