Oracle Exam 1Z0-1034-20 Topic 8 Question 12 Discussion

Actual exam question for Oracle's 1Z0-1034-20 exam

Question #: 12
Topic #: 8

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 REPORT; SELECT id. C.Name.First, C.Name.Last FROM Contact C WHERE C.Name.First = 'A%' ORDER BY Contact.Name.First;

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

CString 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;

DString queryString = 'USE OPERATIONAL; SELECT id, C.Name.First, C.Name.Last FROM Contact C WHERE

EName.First like 'A%* ORDER BY Contact.Name.First;

Show Suggested Answer

Suggested Answer: E

by Belen at May 03, 2022, 05:51 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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