Which two actions can be done by a Page Process of type Automatic Row Processing (DML)?

• A.Apply a SQL where clause to append to all generated INSERT, UPDATE, and delete statements at fun time.
• B.invoke PL/SQL code to perform the Inserts, updates, and deletes.
• C.Log a user-defined message when an exception is raised.
• D.Perform automatic detection of lost updates.
• E.Generate a primary key column value on a SQL INSERT statement.
• F.Perform CRUD operations on multiple tables.

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.Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.
• C.Go to each report and change the type from Tabular Form to Interactive Grid.
• 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: *

Taylor has created a report and form on the STATUS table.
She wants only application administrators to be able to access the report and form.
What must she do to achieve this?

• A.Select authentication of Administrator Only
• B.Add a before header validation
• C.Add a before header process
• D.Select authorization scheme of Administration Rights

Comment: *

Name: *

Email: *

Verification: *

Phil has been given the responsibility an application that was developed years ago, because the original developer has left the company. End users have complained about accessibility because not all pages have titles.
How can Phil ensure that he corrects all pages in the app without page titles?

• A.Ask end users to identify the problem pages.
• B.Bring up each page In Page designee and review the Page Name.
• C.Use Application Advisor to perform a check.
• D.Run a query on the APEX_PAGE_DETAILS view where PAGE_TITLE is null.

Comment: *

Name: *

Email: *

Verification: *

Which three actions can be performed by a workspace administrator?

• A.Add space to a schema.
• B.Monitor workspace activity.
• C.View usage reports for a workspace.
• D.Manage user accounts.
• E.Manage workspace to schema assignments.
• F.Approve workspace requests.

Comment: *

Name: *

Email: *

Verification: *