As a project manager, you use spreadsheets to keep track of multiple projects. As you took-responsibility of more projects, you become tired of managing them in spreadsheets.
You have collected all of your project data in one single spreadsheet. You also want to maintain the data in an Oracle Database table by using an Oracle Apex application.
Which two action can you take?

• A.Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.
• B.Use the Create Application Wizard and select ''From a Spreadsheet.''
• C.Create a new table by using SQL Workshop > Object Browser .Create Table, and then use the Create Application Wizard to Create an application based on the new table.
• D.Use SQL Workshop >Utilities > Data Workshop to load the data into a new table, and then use the Create Application wizard to create an application on the new table.
• E.Define a Data Loading page in the Create Application Wizard.

Comment: *

Name: *

Email: *

Verification: *

Robin develops many apps In her workspace that use various APEX plug ins. Some apps use the same plug-In as other apps. When a newt* version of a plug-in is available, Robin has to update the plug-in in multiple apps.
How can Robin upgrade a plug-In once and have all other apps that use the same plug-in get updated at the same time?

• A.Create a "Plug-ins Master" app where she stores all plug-ins and then subscribes the plug-Ins in all of her other apps to the plug-Ins In the "Plug-has Master" app.
• B.Update one of the plug-ins, and then click Push Update to update the other apps.
• C.Write a PL/SQL package that she can reuse to update the plug-In definitions in each application.
• D.Run a SQL command to update the plug-In definition in each application.

Comment: *

Name: *

Email: *

Verification: *

George used the Create Page Wizard to create a calendar on the DEMP_ORDERS table based on the ORDER_TIMESTAMP column However, the calendar shows only the month and list views.
What does George need to do to show week and day views?

• A.Set Show Time to "Yes."
• B.Select Week and Day under Calendar Views and Navigation.
• C.Set Maximum Events / Day to greater than 1.
• D.Select the End Date Column.

Comment: *

Name: *

Email: *

Verification: *

Kyle' is developing a page with an interactive report, called Employees, using this query: - SELECT EMPNO, ENAME, JOB, DEPTMO FROM EMP WHERE DEPTHO = nv1 (: P3_DEPTHO, DEPTNO) On the page. Kyle adds a select list, called p3_deptmo, 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 Employs 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.Set "Page Items to Submit" to p3_deptho in the report.
• C.Add an additional true action of Set Value by using Static Assignment in Dynamic Action.
• D.Set a column on the DEPTNO column.

Comment: *

Name: *

Email: *

Verification: *

David has created page 10 as a form page using an Automatic Row Fetch process. A column named LOCATION has been added to the underlying table, and the form needs to include this new the column.
Which is the minimum action required on the copied item to get the form working correctly.

• A.Set the source database column to LOCATION.
• B.Set value required to No.
• C.Update the item label.
• D.Update the Item name.
• E.Change the source type to Null.

Comment: *

Name: *

Email: *

Verification: *