Online Access Free 1Z0-771 Exam Questions

You must use a Static Content region type to display messages about the employee of the month. Which text, when placed in this region, will display the message correctly?

• A.Join me in congratulating & P1_ENAME. as the new employee of the month!
• B.Join me in congratulating V('P1_ENAME') as the new employee of the month!
• C.Join me in congratulating: P1_ENAME as the new employee of the month!
• D.Join me in congratulating: &P1_ENAME. as the new employee of the month!

Which two statements are true about Oracle APEX?

• A.You can build interactive reporting apps based on data from disparate systems.
• B.Running an APEX app needs client software.
• C.APEX eliminates middle tier application logic.
• D.Application definition is not stored in the database.

There is a validation of type Item is Numeric on the P1_SALARY item. When the page is submitted, this error message is displayed both as a notification and inline with the item. What will cause the validation error to appear only in the Notification area?

• A.Setting Display Location to Inline in Notification
• B.Setting Value Required to Yes on P1_SALARY.
• C.Removing P1_SALARY from the validation Associated Item.

In your application, you want to display data in a searchable, customizable report that supports inline editing at runtime using the mouse or keyboard. Which report type will you create?

• A.Smart Filters
• B.Interactive Report
• C.Classic Report
• D.Interactive Grid

The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value is selected?

• A.Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.
• B.Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.
• C.Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.