1Z0-750 Online Practice Questions and Answers

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. Add a control break on Department

B. Add a filter to the report

C. Save the report as a named report

D. Save the report as the primary report

E. Download the report to a CSV or HTML file

George used to Create Page Wizard to create a calendar on the DEMO_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. Select the End Date Column

B. Set Show Time to "Yes"

C. Set Maximum Events / Day to greater than 1

D. Select Week and Day under Calendar Views and Navigation

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.

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. Set the Server-side Condition to "Never"

B. Set the Road Only condition to "Always"

C. Delete the region

D. Set the Read Only condition to "Never"

E. Set the Parent Region to "Null"

Which three sources can be used for a classic report? (Choose three.)

A. RESTful Web Source module

B. CSV (comma separated values) file

C. PL/SQL function returning a SQL query

D. PL/SQL function returning a single value variable

E. SQL Query

F. PL/SQL stored procedure with the OUT parameter

G. Excel spreadsheet

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.

Francisco has been tasked with creating a Frequently Asked Questions (FAQ) page. The page security requirements are defined as:

Anyone who can access the application, in any capacity, shall also be able to view the new FAQ page. Which page level Authorization Scheme and Authentication options should Francisco choose?

A. Authorization Scheme: Reader Rights; Authentication: Page Requires Authentication

B. Authorization Scheme: Null; Authentication: Page is Public

C. Authorization Scheme: {Not Reader Rights}; Authentication: Page Is Public

D. Authorization Scheme: Must Not Be Public User; Authentication: Page Requires Authentication

A City Administration app has two select lists (LOVs). P1_STATE is based on "STATE" and P1_CITY is based on "CITY".

The CITIES table includes both the STATE and CITY columns. When a state is selected, the application should display only cities within the selected state, not all cities.

How can you limit the cities to display only those for the selected state?

A. Write a Set Value dynamic action against P1_STATE to require the P1_CITY based on the selected STATE.

B. Add P1_STATE to the "Page Items to Submit" property in P1_CITY.

C. In P1_CITY, set the "Cascading LOV Parent Item(s)" to P1_STATE.

D. Write an Execute PL/SQL Code dynamic action against P1_CITY to select the correct cities based on P1_STATE.

Nancy has an application that is performing unexpectedly. She has turned on debug for the page and reviewed the debug messages and still can't determine the cause of the inconsistent behavior. She believes it may be an APEX bug.

What action should Nancy take to identify the issue?

A. Review the browser console output.

B. Review the application error log.

C. Set Debug Level to 9 and review the debug messages.

D. View the page source.

Lucy' created an interactive report on the EMP table. She wants to filter the report to show employees with JOB = SALESMAN'.

Which two options could Lucy perform to add an equals filter on the Job column?

A. Click Actions > Filter and select Job as column, equal sign (=) as operator, SALESMAN as Expression, and then click Apply.

B. Enter salesman in the search bar text box.

C. Click the Search icon (magnifying glass) on the search bar, and enter SALESMAN in the search bar text box.

D. Add a where clause to the SQL Query to restrict the records returned.

E. Click the Job column and select salesman from the column filter list of values