Leads4pass > Oracle > Oracle Database > 1Z0-750 > 1Z0-750 Online Practice Questions and Answers

1Z0-750 Online Practice Questions and Answers

Questions 4

Ellie has two related interactive grids on a page. Which two steps must she perform to create a master detail relationship between them? (Choose two.)

A. Include a join clause in the SQL Query attribute of the detail interactive grid region.

B. Enter the name of the foreign key constraint in the Detail Region Foreign Key Relationship attribute.

C. In the master region, select the correct region for the Detail Region attribute.

D. Make the master interactive grid region read-only.

E. Move the detail region below the master region.

F. In the detail region, select the correct region for the Master Region attribute.

G. In one of the columns of the detail region, select the related column of the master region for the Master Column attribute.

Buy Now
Questions 5

Mary wants to add feedback to an application. She uses the Create Page Wizard, selects Features, and then selects Feedback. The wizard adds a feedback entry to the navigation bar and creates new pages, in her application, under Administration to review and disposition the feedback.

Which statement is true about feedback data?

A. Feedback entered into the app can be viewed by developers in Team Development

B. When an administrator updates the feedback status, the person logging the feedback is notified

C. A new table is created in your schema to store the feedback for the app

D. You can invoke the feedback page from a modal dialog page

Buy Now
Questions 6

Kyle is developing a page with an interactive report, called Employees, using this query:

SELECT EMPNO, ENAME, JOB, DEPTNO FROM EMP WHERE DEPTNO = nvl(:P3_DEPTNO, DEPTNO)

On the page, Kyle adds a select list, called P3_DEPTNO, using this query:

SELECT dname, deptno FROM dept;

He creates a dynamic action on change of P3_DEPTNO, with a true action of "Refresh" against the Employees region.

Kyle then runs the page and selects ACCOUNTING in the P3_DEPTNO item. However, the report still shows employees from all departments.

What must Kyle do to correctly display only employees from the department selected?

A. Add a computation set to P3_DEPTNO

B. Add an additional true action of Set Value by using Static Assignment in Dynamic Action

C. Set a column on the DEPTNO column

D. Set "Page Items to Submit" to P3_DEPTNO in the report

Buy Now
Questions 7

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

Buy Now
Questions 8

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

Buy Now
Questions 9

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.

Buy Now
Questions 10

Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, in the URL when calling another page.

How can Trillian escape the item value so that the comma is interpreted correctly?

A. /Donuts,Coffee/

B. \Donuts,Coffee\

C. Donuts\,Coffee

D. "Donuts,Coffee"

Buy Now
Questions 11

Nancy has an application that is performing unexpectedly. She has turned on debug for the page and reviewed the debug messages and still can't determine the cause of the inconsistent behavior. She believes it may be an APEX bug.

What action should Nancy take to identify the issue?

A. Review the browser console output.

B. Review the application error log.

C. Set Debug Level to 9 and review the debug messages.

D. View the page source.

Buy Now
Questions 12

Jane" is creatinga new application, users of the application will use SSO to authenticate. SS0 has been defined forthe 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. UpdateAdvanced Settings to specify authentication.

Buy Now
Questions 13

You'have created this chart:

However, you want to display this chart:

How should you update the chart?

How should you update the chart?

A. Update the value aggregation to `'Percentage.''

B. Update the query to calculate the value divided by the total value.

C. Update the y-axis format to percent.''

D. Update the show as percentage to `'yes.''

Buy Now
Exam Code: 1Z0-750
Exam Name: Oracle Application Express 18: Developing Web Applications
Last Update: Nov 16, 2024
Questions: 77
10%OFF Coupon Code: SAVE10

PDF (Q&A)

$49.99

VCE

$55.99

PDF + VCE

$65.99