Oracle Application Express 4: Developing Web Applications (1Z0-450) Free Practice Test

Question 1

Which three statements are true about a wizard-generated tabular form?

A. You can drill down to a detail record view.

B. Only allows you to update one record at a time.

C. Only allows you to change the updateable columns.

D. Allows you to add and update multiple records at a time.

E. Allows you to add more than one record at a time.

Correct Answer: C,D,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

ABC Company manager wants his employees to create/load spreadsheets on every page using the web sheet application? How to do that using the APEX websheet application? (Choose two)

A. Create a section navigation

B. Use a SQL query

C. Create a data grid

D. Add a text section to a page

E. Create a data section based on data from a data grid

F. Create a page navigation

Correct Answer: C,E

Question 3

An Order Processing form retrieves order details from the user on page 21. The order details should be displayed in a summarized format on page 22 for confirmation. View the Exhibit and identify the correct syntax to be used to retrieve the session state.

A. V ('P21_ORDERDATE . and V (P21_ORDERTOTAL)

B. :P21_ORDERDATE and: P21_ORDERTOTAL

C. NV ('P21_ORDERDATE') and NV ('P21_ORDERTOTAL')

D. &P21_QRDERDATE . And &P21_ORDERTOTAL

Correct Answer: D

Question 4

You are testing a customer entry form that is part of an Order Processing application. When you open the form the first time, enter data, and click 'Submit", a message "Action Processed" is displayed and data is inserted into the underlying table. However, when you open the page again, it displays old data In place of a blank new form. How do you ensure that a blank form is displayed so that you can enter new customer data?

A. Set Caching to "Not Cached" for the region that hosts the customer entry form.

B. Select "Always, replacing any existing value in session state" from Source Used field for each form item on the page.

C. Set the "Maintain session state* item property to "Per Session".

D. Modify the branch for the "Submit" button to clear the cache for the page or items on the page.

E. Set Caching to "Not Cached" for the page that hosts the customer entry form.

Correct Answer: B

Question 5

Which two actions are true about creating lists?

A. All list templates support hierarchical lists.

B. you can edit multiple list entries simultaneously.

C. Once created; you cannot update the parents of list entries.

D. You can add to a list directly from the page definition page.

E. you can track clicks on list entries.

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Application Express 4: Developing Web Applications (1Z0-450) Free Practice Test