Oracle Oracle Database 1Z0-750 Questions & Answers

• Question 21:

  John has a form page with an email item and a status item.

  What must John do to ensure that the email item is populated before users can enter any value into the status item on the form page?

  A. dynamic action on the email item

  B. validation on the email item

  C. plug-in for the status item

  D. server-side condition on the status item

  Correct Answer: B

• Question 22:

  David has created Page 10 as a form page using an Automatic Row Fetch process. A column named LOCATION has been added to the underlying table, and the form needs to include this new column.

  You decide to copy an existing page item :P10_DEPTNO and use that to represent the LOCATION column.

  Which is the minimum action required on the copied item to get the form working correctly?

  A. Update the item label.

  B. Set value required to No.

  C. Update the item name.

  D. Change the source type to NULL.

  E. Set the source database column to LOCATION.

  Correct Answer: D

• Question 23:

  Which is true about a workspace in Oracle APEX?

  A. It can be associated only with one schema.

  B. It can be associated with multiple schemas from different databases.

  C. It can be associated with the multiple schemas in the same database.

  D. It is not associated with any schemas.

  Correct Answer: C

  Reference: https://software.databasedevelop.com/article/11088364/add+multiple+schemas+in+one +workspace

• Question 24:

  Where is Oracle APEX session state stored between calls from the browser?

  A. in the browser in the form of cookies

  B. in the workspace schema

  C. in the APEX metadata schema

  D. is passed back and forth between the database and browser with each call

  Correct Answer: A

  Reference: https://docs.oracle.com/database/apex-18.1/HTMDB/understanding-session-statemanagement.htm#HTMDB03009

• Question 25:

  You can control when an authorization scheme is validated by using the Evaluation Point. Select three valid Evaluation Points. (Choose three.)

  A. once per session

  B. once per region

  C. once per page view

  D. once per day

  E. always (no caching)

  F. once per user

  Correct Answer: ACE

  Reference: https://docs.oracle.com/html/E39147_04/sec_authorization.htm

• Question 26:

  Mark has created a modal form page to enter new calendar events. Mark now wants to call the form when an end user clicks an empty calendar spot.

  How can Mark update the calendar region to call the form?

  A. Define a dynamic action of type Click in the calendar region.

  B. Use the create link attribute and the andAPEX$NEW_START_DATE. placeholder.

  C. In the rendering tree, right-click the calendar region and select the Link Form to Calendar option.

  D. Use the create link attribute and use the :APEX$NEW_START_DATE bind variable.

  E. Use the view/edit link attribute to display the selected calendar entry.

  Correct Answer: E

• Question 27:

  Robin develops many apps in his workspace that use various APEX plug-ins. Some apps use the same plug-in as other apps. When a newer version of a plug-in is available, Robin has to update the plug-in in multiple apps.

  How can Robin upgrade a plug-in once and have all other apps that use the same plug-in get updated at the same time?

  A. Run a SQL command to update the plug-in definition in each application.

  B. Write a PL/SQL package that he can reuse to update the plug-in definitions in each application.

  C. Update one of the plug-ins, and then click Push Update to update the other apps.

  D. Create a "Plug-ins Master" app where he stores all plug-ins and then subscribes the plug-ins in all of his other apps to the plug-ins in the "Plug-ins Master" app.

  Correct Answer: B

• Question 28:

  You want to refer to a page by a name (or alias) instead of page number in the application URL.

  Which step most accurately helps you achieve this?

  A. Go to Application Properties and set "Refer to page by name (or alias)" to "Yes".

  B. Set the Built-in substitution string PAGE_ALIAS on page load.

  C. Enter an alphanumeric name in the Page Title attribute.

  D. Enter an alphanumeric alias in the Page Alias attribute.

  Correct Answer: D

  Reference: https://docs.oracle.com/en/database/oracle/application-express/19.2/htmdb/understanding-urlsyntax.html#GUID-D5510BFC-AF94-4AAD-8B82-FF780A47601D

• Question 29:

  Which processing point is enabled for computations during page processing?

  A. Processing

  B. After Submit

  C. After Processing

  D. Validating

  Correct Answer: A

  Reference: https://docs.oracle.com/database/apex-5.1/HTMDB/understanding-pagecomputations.htm#HTMDB04017

• Question 30:

  Michael created a report and form on a table to maintain customers.

  When Michael tested the new form and entered a new record, he got this error:

  

  What should Michael do to resolve this issue?

  A. Select Managed by Database (ROWID) for the Primary Key type.

  B. Add a trigger on the table to populate the CUSTOMER_ID column when null.

  C. Create a sequence.

  D. Set the Customer ID item to text field with Read-Only set to "Always".

  Correct Answer: B

  Reference: https://software.databasedevelop.com/article/10410432/APEX+-+ORA-01400%3a+cannot +insert+NULL+into