Oracle Application Express 5: Developing Web Applications — Question 1

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.)

Answer options

• A. Define a Data Loading page in the Create Application Wizard.
• 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.
• C. Create an application by using the Create Application Wizard, and then add a table for the spreadsheet data.
• D. Use the Create Application Wizard and select "From a Spreadsheet."
• 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.

Correct answer: A, C

Explanation

The correct actions are A and C. Defining a Data Loading page in the Create Application Wizard allows you to import data directly, and creating an application and adding a table for the spreadsheet data enables you to utilize that data effectively. Options B, D, and E are incorrect as they either focus on data loading methods that do not align with the requirement or do not involve directly establishing an application based on a spreadsheet.