Page: 1
/ 5
Total 71 questions
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.
Answer : D
Reference:
https://docs.oracle.com/en/database/oracle/application-express/19.2/htmdb/understanding-url-syntax.html#GUID-D5510BFC-AF94-4AAD-8B82-
FF780A47601D -
Which processing point is enabled for computations during page processing?
- A. Processing
- B. After Submit
- C. After Processing
- D. Validating
Answer : A
Reference:
https://docs.oracle.com/database/apex-5.1/HTMDB/understanding-page-computations.htm#HTMDB04017
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".
Answer : B
Reference:
https://software.databasedevelop.com/article/10410432/APEX+-+ORA-01400%3a+cannot+insert+NULL+into
In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS-based RESTful
Services?
- A. Install the Sample REST Services packaged application.
- B. Navigate to the Shared Components section and configure a REST Enabled SQL resource.
- C. Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.
- D. Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes".
Answer : C
Reference:
https://docs.oracle.com/en/database/oracle/application-express/19.1/aeutl/accessing-RESTful-services.html#GUID-DE5D8763-A650-4FBA-9CC5-
17E141C8406C
Which four Oracle APEX region types can be created on top of a Web Source module? (Choose four.)
- A. Classic Report
- B. Interactive Report
- C. Chart
- D. Static Content
- E. List View
- F. Interactive Grid (non-editable)
- G. List
- H. Interactive Grid
- I. Tree
- J. PL/SQL Dynamic Content
Answer : BCHI
Reference:
https://blogs.oracle.com/apex/web-source-modules-and-the-interactive-grid-part-1
Which is a predefined authentication scheme in Oracle Application Express?
- A. Universal Authentication Framework (UAF)
- B. HTTP Header Variable
- C. SAML 2.0 Sign-On
- D. OpenID Connect Sign-On
- E. Client Certificate Authentication
Answer : B
Reference:
https://docs.oracle.com/database/apex-18.1/HTMDB/establishing-user-identity-through-authentication.htm#HTMDB25774
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
Answer : B
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.
Answer : D
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.
Answer : C
Reference:
https://software.databasedevelop.com/article/11088364/add+multiple+schemas+in+one+workspace
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
Answer : A
Reference:
https://docs.oracle.com/database/apex-18.1/HTMDB/understanding-session-state-management.htm#HTMDB03009
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
Answer : ACE
Reference:
https://docs.oracle.com/html/E39147_04/sec_authorization.htm
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 &APEX$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.
Answer : E
Rick has created an "editable" interactive grid on a table that includes four audit columns: CREATED, CREATED_BY, UPDATED, and UPDATED_BY.
The four audit columns are included in the report with read-only type set to Always.
How can Rick update all four audit columns when a user inserts a row, and the UPDATED and UPDATED_BY columns when a user updates a row?
- A. using "Enable" Dynamic Actions
- B. using default values on the report columns
- C. using After Header Computations
- D. defining an After Submit process
Answer : A
Which two actions can be done by a Page Process of type Automatic Row Processing (DML)? (Choose two.)
- A. Perform automatic detection of lost updates.
- B. Perform CRUD operations on multiple tables.
- C. Log a user-defined message when an exception is raised.
- D. Apply a SQL WHERE clause to append to all generated INSERT, UPDATE, and DELETE statements at run time.
- E. generate a primary key column value on a SQL INSERT statement.
- F. Invoke PL/SQL code to perform the inserts, updates, and deletes.
Answer : DF
Reference:
https://docs.oracle.com/html/E39147_04/app_forms004.htm
Jane is creating a new application. Users of the application will use SSO to authenticate. SSO has been defined for the instance.
Which step should Jane perform in the Create Application Wizard?
- A. Under Authentication, select Single Sign On (SSO).
- B. Include a Sign-In page in the list of pages.
- C. Include the Access Control feature.
- D. Update Advanced Settings to specify authentication.
Answer : A
Reference -
https://docs.oracle.com/database/apex-18.1/HTMDB/establishing-user-identity-through-authentication.htm#HTMDB12003
30 days access 