As a project manager, you use spreadsheets to keep track of multiple projects.
As you took responsibility of more projects, you became tired of managing them in spreadsheets.
You have collated 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 actions can you take? (Choose two.)
Click on the arrows to vote for the correct answer
A. B. C. D. E.AC.
The task is to maintain project data from a spreadsheet into an Oracle Database table using Oracle APEX application. Here are the two actions that can be taken:
A. Define a Data Loading page in the Create Application Wizard: This action involves creating a new APEX application and defining a data loading page. The data loading page can be designed using the APEX page designer to upload the spreadsheet data into a new or existing table in the Oracle database. This option requires manually creating a database table to hold the project data before designing the data loading page.
C. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data: This action involves creating a new APEX application using the Create Application Wizard and adding a table to the application for the spreadsheet data. This option automates the process of creating a table to hold the project data in the Oracle database.
The other options are not the correct actions to take:
B. 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: This option involves loading the spreadsheet data into a new table using the Data Workshop in SQL Workshop and then creating an APEX application based on the new table. While this approach is possible, it requires an additional step to load the data into the database before creating the APEX application.
D. Use the Create Application Wizard and select "From a Spreadsheet": This option is not available in Oracle APEX 18. It is available in later versions of APEX.
E. 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: This option involves creating a new database table using the Object Browser in SQL Workshop and then creating an APEX application based on the new table. While this approach is possible, it requires an additional step to create the table before creating the APEX application.