AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-898





Question ID 4610

Which statement is correct about the Java Persistence API support for the SQL queries?
 

Option A

A.    SQL queries are NOT allowed to use parameters.
 

Option B

B.    The result of an SQL query is not limited to entities.
 

Option C

C.    Only SELECT SQL queries are required to be supported.
 

Option D

D.    SQL queries are expected to be portable across databases.
 

Correct Answer C
Explanation


Question ID 4611

A user entity is in a one-to-many relationship with a Book entity. In other words, a developer reach the collection of books that a user instance myUser has by using the path expression-“myuser - books".
A developer wants to write a Java Persistence query that returns all users that have only two books.
Which two are valid queries that return this information? (Choose two.)
 

Option A

A.    SELECT u FROM User U WHERE SIZE (u.books) = 2
 

Option B

B.    SELECT u FROM User WHERE COUNT (u.books) = 2
 

Option C

C.    SELECT u FROM User u (WHERE COUNT (b) FROM u.books b) = 2
 

Option D

D.    SELECT u FROM user u WHERE (SELECT SIZE (b) FROM u.books b) = 2
 

Correct Answer A,C
Explanation

Send email to admin@getfreedumps for new dumps request!!!