Oracle Exam 1Z0-1037-22 Topic 2 Question 16 Discussion

Actual exam question for Oracle's 1Z0-1037-22 exam

Question #: 16
Topic #: 2

[All 1Z0-1037-22 Questions]

Your Customer wants to fetch specific contact details using an ROQL query. Their requirements are:

1. Fetch Contact ID, Contact First name, and Contact Last name details.

2. Contact first name should start with ''A''.

3. Query should run against the report database.

4. All contacts must be sorted in ascending order by Contact first name.

Which query will meet all the requirements?

AString queryString = ''USE OPERATIONAL; SELECT id, C.Name.First, C.Name.Last FROM Contact C WHERE C.Name.First like 'A%' ORDER BY Contact.Name.First;

BString queryString = ''USE REPORT; SELECT id, C.First, C.Last FROM Contact C WHERE C.Name.First like 'A%' ORDER BY Contact.First;

CString queryString = ''USE REPORT; SELECT id, C.Name.First, C.Name.Last FROM Contact C WHERE C.Name.First = 'A%' ORDER BY Contact.Name.First;

DString queryString = ''USE REPORT; SELECT id, C.Name.First, C.Name.Last FROM Contact C WHERE C.Name.First like 'A%' ORDER BY Contact.Name.First;

Show Suggested Answer

Suggested Answer: D

Chaining is always used together with batching. A batch operation includes multiple target operations that each can take a homogeneous or heterogeneous list of business objects.

https://docs.oracle.com/en/cloud/paas/integration-cloud-service/cccdg/batch-and-bulk-operations.html

by Tarra at Feb 03, 2023, 02:59 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-1037-22 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!