Oracle Oracle Certifications 1Z0-860 Questions & Answers

• Question 301:

  Which Java Persistence query uses the aggregate function correctly, assuming that chairs field is of type int?

  A. SELECT ANY(r. chairs) FROM Room r

  B. SELECT NEW Integer(MAX(r. chairs)) FROM Room r

  C. SELECT r FROM Room r WHERE r.chairs > AVG(r.chairs)

  D. SELECT c FROM Chair c WHERE LOCATE (c.type, lazyboy) > -1

  Correct Answer: B

• Question 302:

  Click the Task button.

  A Department entity is in a one-to-many relationship with an Employee entity. A developer has been asked to write a Java Persistence query to update the set of employees who are in the department 'HR' by setting their department to null.

  Construct a query using the Java Persistence query language to perform this task. Construct a valid Java Persistence query by dragging and dropping the syntax fragements.

  Select and Place:

  

  Correct Answer:

  

• Question 303:

  Click the Task button.

  Place the EJB 3.0 JMS Message-Driven Bean class code snippets on their corresponding locations.

  Select and Place:

  

  Correct Answer:

  

• Question 304:

  Click the Task button.

  A Department entity is in a one-to-many relationship with an Employee entity. A developer has been asked to write a Java Persistence query to update the set of employees who are in the department 'HR' by setting their department to null.

  Construct a query using the Java Persistence query language to perform this task. Construct a valid Java Persistence query by dragging and dropping the syntax fragements.

  Select and Place:

  

  Correct Answer:

  

• Question 305:

  Click the Task button.

  Place the EJB 3.0 JMS Message-Driven Bean class code snippets on their corresponding locations.

  Select and Place:

  

  Correct Answer: