Which four Oracle APEX region types can be created on top of a Web Source module?

• A.List View
• B.Interactive Grid (non-editable)
• C.List
• D.Classic Report
• E.Interactive Report
• F.Static Content
• G.Tree
• H.PL/SQL Dynamic Content
• I.Interactive Grid
• J.Chart

Comment: *

Name: *

Email: *

Verification: *

Martin has a text field on a page that the wants to protect with session Satate protecton.
Select the four valid protection levels available to Martin.

• A.Checksum Required: Session Level
• B.Hidden Item
• C.Checksum required: Application Level
• D.Checksum Required: User Level
• E.Unrestricted
• F.Restricted: may not be set from browser
• G.Checksum NOT Required
• H.Checksum Required: Workspace Level

Comment: *

Name: *

Email: *

Verification: *

Maurice wants to have a report on employees, which shows only employees tor the department selected in a select list Item.
He has created a report, called report_1, based on the EMP table. Above the region, he has defined a select list called p6_deptno.
Maurice has added the correct Where clause for report_1 and defined an "on change" dynamic action on p6_deptno to refresh the report_1 region.
When he runs the page, no data is displayed. Irrespective of the department selected.
What must Maurice do to get the page to work correctly?

• A.In the "on change" dynamic action, set page Items to submit to p6_DEPTNO.
• B.On the report_1 region, set page Items to submit to p6_deptno.
• C.In the "on change" dynamic action, set event scope to "dynamic."
• D.Add a set value action, before the refresh action, of type PL/SQL Expression with code of
  :P6_DEPTNO and items to submit to P6_DEPTNO.

Comment: *

Name: *

Email: *

Verification: *

John is evaluating an old APEX application that has over 20 tabular forms. Ho wants to update the application and replace all of the tabular forms with interactive grids.
What is the fastest way for John to replace the old reports?

• A.Go to each page with a tabular form, copy the SQL Source from the Tabular Form region, and use it to create a new Interactive grid.
• B.Go to each report and change the type from Tabular Form to Interactive Grid.
• C.Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.
• D.Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid," select all, and then click Upgrade.

Comment: *

Name: *

Email: *

Verification: *

What is the least error-prone way to split a long list into two lists?

• A.Copy the entire list, grid edit the copied list and remove entries that are not needed, and then grid edit the first list and remove the entries that are now in the second list.
• B.Create an empty second list, copy selected list items from the first list to the second list, and then remove the copied list items from the first list.
• C.Create two new lists, copy list items from the initial list to the first list, copy the remaining list items from the initial list to the second list, and then delete the initial list.
• D.Create an empty second list, manually re-create the needed list entries, and then remove the matching list entries from the first list.

Comment: *

Name: *

Email: *

Verification: *