Oracle Exam 1Z0-1037 Topic 7 Question 8 Discussion

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

Question #: 8
Topic #: 7

Which three statements are true bout the limitations of Connect Web Services? (Choose three.)

AWhen executing a query against a report database, a maximum of 20,000 rows can be returned.

BWhen executing a query against an operational database, a maximum of 20,000 rows can be returned in a single request.

CThe server enforces a maximum of 10,000 objects when invoking any one of the Create, Get, Update or Destroy operations.

DWhen executing a query against a report database, a maximum of 100,000 rows can be returned.

EWhen executing a query against an operational database, a maximum of 100,000 rows can be returned in a single request.

FThe combination of the multi-object Create, Get, Update & Destroy operations and the Batch operations is limited to 10,000 total input objects per SOAP request.

Show Suggested Answer

Suggested Answer: D, E, F

D (not A): If the report is pre-configured for deferred execution, then depending on how large the data set to be processed is estimated to be, the report will either run right away or be prompted for queuing. In most cases, the user will be prompted to place the report in the queued state. Only where the report is estimated to run very quickly by not exceeding the deferred report threshold of 200,000 rows will the report be run immediately.

E: In Oracle Service Cloud, the maximum row export threshold is 100,000 rows.

F (not C): 10,000 total input objects per SOAP request. The combination of the multi-object Create, Get, Update and Destroy operations and the Batch operation is limited to 10,000 total input objects per SOAP request.

References:

https://docs.oracle.com/cloud/latest/soa121300/TKRDP/GUID-ED7B0E34-2D5E-40DF-A7ED-001581E2ACCA.htm#TKRDP2778

ORACLE SERVICE CLOUD GUIDE: HOW TO IMPROVE REPORTING PERFORMANCE, Best Practices to Scale Oracle Service Cloud Analytics for High Performance, ORACLE WHITE PAPER | MARCH 2015

by Ty at May 05, 2022, 11:32 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-1037 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!