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.Use the Create Page Wizard to create new pages with interactive grids, and then delete the old pages with tabular forms.
• B.Go to each report and change the type from Tabular Form to Interactive Grid.
• C.Use the Upgrade Application utility and select the candidate objects listed for "Upgrade Tabular Form to Interactive Grid," select all, and then click Upgrade.
• D.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.

Comment: *

Name: *

Email: *

Verification: *

ABC Company developed an employee directly by using an interactive report.
The HR manager (an end user) has customized his or her report to show only employees in the HR department, and wants to review the same report weekly.
How can the HR manager achieve this?

• A.Save the report as the primary report
• B.Add a filter to the report
• C.Add a control break on Department
• D.Save the report as a named report
• E.Download the report to a CSV or HTML file

Comment: *

Name: *

Email: *

Verification: *

Fred created a parent/child relationship between the Employees and Departments.

Fred wants to hide the Departments region.
What should Fred do to achieve this?

• A.Delete the region.
• B.Set the Parent Region to "Null."
• C.Set the Read Only condition to "Always."
• D.Set the Server-side Condition to "Never."
• E.Set the Read Only condition to "Never."

Comment: *

Name: *

Email: *

Verification: *

Which is true about interactive reports?

• A.Interactive reports can be either read-only or editable.
• B.All columns defined in the report query must be shown.
• C.You can define only one interactive report on a page.
• D.An interactive report can be based on a PL/SQL function body returning a SQL query.

Comment: *

Name: *

Email: *

Verification: *

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.Set "Page Items to Submit" to p3_deptho in the report.
• B.Set a column on the DEPTNO column.
• C.Add an additional true action of Set Value by using Static Assignment in Dynamic Action.
• D.Add a computation set to p3_ DEPTNO

Comment: *

Name: *

Email: *

Verification: *