1Z0-750 Online Practice Questions and Answers

Which three are true about using REST Enabled SQL to access a remote database? (Choose three.)

A. Authentication must be done using the OAuth2 Client Credentials flow.

B. REST Enabled SQL must be enabled in the remote databases' ORDS configuration.

C. A wallet must be defined and configured on the remote database.

D. A REST Enabled SQL Reference must be created in Shared Components.

E. Authentication can be done using the remote database username and password.

F. The application parsing schema must be REST enabled.

Betty has created a zip file, app100_files.zip, to include all of her static application files that she references in her application. The files are divided into different subdirectories for JavaScript and CSS.

How can Betty upload the static files, so they can be referenced, and maintain the subdirectory structure?

A. Unzip app100_files.zip, and upload each directory individually.

B. Upload app100_files.zip to the file server and unzip the file. In User Interface Properties, edit the Theme, and set JavaScript File URLs.

C. In Shared Components, create the required subdirectories. Unzip app100_files.zip, and upload each file into their subdirectories.

D. Upload app100_files.zip, and set Unzip File to Yes.

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

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.

Which set of components do you need to add breadcrumb navigation to an existing application?

A. navigation list, breadcrumb region, and breadcrumb entries

B. navigation list, breadcrumb, and breadcrumb entries

C. breadcrumb, breadcrumb entries, and breadcrumb regions

D. breadcrumb, breadcrumb entries, and navigation regions

Maurice wants to have a report on employees, which shows only employees or the department selected in a select list item. He has created a report, called REPORT_1, based on the EMP table. Above the region, he has defined a select list called P6_DEPTNO. Maurice has added the correct Where clause for REPORT_1 and defined an "on change" dynamic action on P6_DEPTNO to refresh the REPORT_1 region. When he runs the page, no data is displayed, irrespective of the department selected.

What must Maurice do to get the page to work correctly?

A. Add a set value action, before the refresh action, of type PL/SQL Expression with code of :P6_DEPTNO and items to submit to P6_DEPTNO.

B. On the REPORT_1 region, set page items to submit to P6_DEPTNO.

C. In the "on change" dynamic action, set page items to submit to P6_DEPTNO.

D. In the "on change" dynamic action, set event scope to "dynamic".

You want to refer to a page by a name (or alias) instead of page number in the application URL.

Which step most accurately helps you achieve this?

A. Go to Application Properties and set "Refer to page by name (or alias)" to "Yes".

B. Set the Built-in substitution string PAGE_ALIAS on page load.

C. Enter an alphanumeric name in the Page Title attribute.

D. Enter an alphanumeric alias in the Page Alias attribute.

Which four Oracle APEX region types can be created on top of a Web Source module? (Choose four.)

A. Classic Report

B. Interactive Report

C. Chart

D. Static Content

E. List View

F. Interactive Grid (non-editable)

G. List

H. Interactive Grid

I. Tree

J. PL/SQL Dynamic Content

Which three actions can be performed in Object Browser? (Choose three.)

A. Enable and disable constraints.

B. Write a SQL statement to update data in a table.

C. Review the storage clause for a table or view.

D. Enable and disable indexes.

E. Truncate a table.

F. Download table data to XML.

G. Review the SQL statement for an existing table.

You have defined a form page on the ORDERS table and changed page item :P5_ORDER_TOTAL to type Hidden.

You also created a dynamic action to update the value of :P5_ORDER_TOTAL when any order items are added, updated, or deleted on the page.

However, when you submit the page, you get this error:

Session state protection violation: This may be caused by manual alteration of protected page item P5_ORDER_TOTAL. If you are unsure what caused this error, please contact the application administrator for assistance.

How should you update :P5_ORDER_TOTAL page item to prevent this error?

A. Set Value Protected to "No"

B. Set Session State Protection to "Unrestricted"

C. Change the item type to "Display Only"

D. Set Store value encrypted in session state to "Yes"

You'have created this chart:

However, you want to display this chart:

How should you update the chart?

How should you update the chart?

A. Update the value aggregation to `'Percentage.''

B. Update the query to calculate the value divided by the total value.

C. Update the y-axis format to percent.''

D. Update the show as percentage to `'yes.''