Oracle APEX Cloud Developer Professional (1Z0-771) - Practice Exam 1

1. A browser item changes, but a server process triggered through AJAX reads the old value. Why?
2. A button should refresh a report after updating a search item without submitting the entire page. Which APEX mechanism fits?
3. A calculation should populate a default tax estimate on page load but must be recalculated during Save. What distinction matters?
4. A CSV import contains duplicate business keys. The target table has a unique constraint on that key. What should the developer do?
5. A deployment must be repeatable and reviewable by the team. What practice helps most?
6. A detail page receives an employee ID in a URL. Which two checks are required for secure data access? Select TWO.
7. A developer hides the Delete button for nonmanagers. What additional protection is necessary?
8. A developer needs a small lookup table and sample values before building a page. Which APEX tool is appropriate?
9. A developer stores a derived total in a hidden page item and trusts it when charging the customer. What is safer?
10. A developer writes a report query containing a page-item value. Which pattern is appropriate for the value predicate?
11. A development team needs APEX applications that access tables in its assigned database schema. What relationship should it understand?
12. A form needs a department selector displaying department names while storing department IDs. What should the developer use?
13. A form should reject an end date earlier than its start date and show an actionable message. What should the developer add?
14. A form's successful Save should return to the report while Cancel should discard edits. Which configuration is appropriate?
15. A logout flow should prevent another person using the same device from resuming the prior authenticated session. What should be validated?
16. A modal dialog updates an employee, and the parent report should show the change after the dialog closes. What should be configured?
17. A new form accepts a monetary amount. Which two layers help maintain reliable data? Select TWO.
18. A numeric chart displays categories in an unsuitable order for business review. What should the developer adjust?
19. A page has a repeated address section used across the application. Which approach reduces inconsistent rendering?
20. A page has both a rendering condition and an authorization scheme. What is the useful distinction?
21. A page process catches every database exception and reports a generic success message. What should be changed?
22. A page should show employees for the department selected in P20_DEPT. An AJAX refresh runs, but it still uses the previous department. What should be checked?
23. A region should hide on small screens while retaining its data and process logic. Which concern is being configured?
24. A release changes a table column used by an APEX form. What should the deployment validation include?
25. A report displays comments entered by users. What prevents stored script from executing in the browser when ordinary text is expected?
26. A report joins order headers and lines. Each order total is repeated for every line, then summed. What should be corrected?
27. A REST endpoint returns a large paginated collection. The report shows only the first server page. What should the developer investigate?
28. A REST integration works in development but fails with unauthorized responses in production. What should be checked first?
29. A save process performs related header and line updates. What transactional goal should guide its design?
30. A shared component provides a list of values used by many pages. What is an advantage of changing it centrally?
31. A table has a generated primary key, and a form needs to edit exactly one record. What should the page configuration identify?
32. A team enables debug output while investigating a production problem. What should it do?
33. A team wants accessible navigation and consistent styling across pages. What is the best starting point?
34. A user successfully authenticates but must not access the payroll administration page. What should enforce that restriction?
35. An APEX application export is imported into a clean environment, but its tables are missing. What should the release process include?
36. An application needs reusable database logic for approving expenses across several pages and integrations. What design is strongest?
37. An application needs to display and paginate data from an external HTTP service. Which APEX facility should be considered?
38. An application passes protected item values in URLs. Which APEX feature helps detect unauthorized changes to those values?
39. An application requires each purchase order to reference an existing customer, regardless of whether updates come from APEX or another client. Where should this integrity rule primarily reside?
40. An application sends customer data to an external service. Which two practices are appropriate? Select TWO.
41. An application stores sensitive values in session state. Which design principle is appropriate?
42. An expense page has Save and Delete buttons. Delete logic should run only for the Delete request. What should the process use?
43. An external API times out during a form submission. What should the application design account for?
44. An interactive grid accepts edited rows, but users see no database changes after Save. Which configuration should be investigated?
45. Developers need isolated development and production data while deploying the same application definition. What is a suitable plan?
46. Several environments use the same REST API but different hosts and credentials. What is a sound configuration approach?
47. Two users load the same record. The second saves after the first and unknowingly overwrites changes. What protection is relevant?
48. Users must edit multiple line items in a spreadsheet-like region and save the changes. Which component is appropriate?
49. Users need to filter, sort, and personalize a query result without editing multiple rows inline. Which region is a strong starting point?
50. Users report that saving a form returns them to a list before a validation message appears. What should be reviewed?

Comments — 0