Oracle Oracle Database 1Z0-750 Questions & Answers

• Question 1:

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

  Correct Answer: D

• Question 2:

  Robert has a form page. Page 5, on the EMPtable. He has defined two validations.

  Validation l checks that P5_MGRIs not null.

  Validation 2 checks that the employee selected in p5_MGRhas a Job of president or manager.

  How can Robert prevent the employee Job validation (Validation 2) from firing when theP5_MGRis not null

  validation (Validation l) fi.is tailed?

  A. Set stop processing to Yea for theP5_MGRis not null validation (Validation 1).

  B. Ensure Validation 1 is listed before Validation 2.

  C. Add a server-side condition ofP5_MGRis not null to the employee Job validation (Validation 2).

  D. Set Always Execute to No for theP5_MGRemployee Job validation (Validation 2).

  Correct Answer: C

• Question 3:

  Molly has created a multi-series chart on the EMP table that shows the average salary per job in each department.

  The chart below is not showing the data correctly because there are no Analysis or Salesmen In Department 10.

  

  How must Molly update the chart to correctly display the data?

  A. Update the Series Column Mapping for Series Nameto DEPTNO.

  B. Set Fill Gaps in Chart Data to "Yes."

  C. Update group by In the chart SQL Query.

  D. Update the x-axis Baseline Scaling to "Fixed."

  Correct Answer: D

• Question 4:

  Jane" is creatinga new application, users of the application will use SSO to authenticate. SS0 has been defined forthe instance.Which step should Jane perform in the Create Application Wizard?

  A. Under Authentication, select Single Sign On (SSO).

  B. Include a Sign-in page in the list of pages.

  C. Include the Access Control feature.

  D. UpdateAdvanced Settings to specify authentication.

  Correct Answer: A

• Question 5:

  Which is true about interactive reports?

  A. Interactive reports can be either read-only or editable.

  B. All columns defined in the report query must be shown.

  C. You can define only one interactive report on a page.

  D. An interactive report can be based on a PL/SQL function body returning a SQL query.

  Correct Answer: A

  Reference: https://docs.oracle.com/database/apex-5.1/HTMDB/about-making-grids-editable.htm#HTMDBGUID-0A317D17-5B12-4F4A-B5C8-68807DB5A4C1

• Question 6:

  Bob has created an interactive report on the EMP table. Oracle BI Publisher has been configured as the report server in his environment. He has been asked to output a high-fidelity PDF report, which lists all employees.

  How can Bob define the report?

  A. Create a modal page with a classic report on EMP by using the Printer-Friendly template. Add a button to the page to call the new modal page.

  B. Define a report query and report layout based on the EMP table. Add a button to the page to output the report.

  C. Update the Interactive Report attributes and set Download > PDF to "Checked".

  D. Update the Interactive Report attributes and set Download > High Fidelity to "Checked".

  Correct Answer: D

• Question 7:

  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.

  Correct Answer: C

  Reference: https://docs.oracle.com/database/121/AEAPI/apex_debug.htm

• Question 8:

  Kevin has been asked to create a percentage bar chart that shows what percentage of project were over budget and under budget. Initially his chart looks like.

  

  However, he wants the chart to look like.

  

  What chart attribute should Kevin change to fix this display issue?

  A. Combine Series = Yes

  B. Chart Type =Percent

  C. Fill Gaps in Chart Data + Yes

  D. Stack = Yes

  Correct Answer: D

• Question 9:

  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

  Correct Answer: AB

• Question 10:

  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"

  Correct Answer: D

  Reference: http://oracledba.bigresource.com/Application-Express-Session-state-protection-violation-error0RGXXq8b6.html