Oracle Oracle Database 1Z0-750 Questions & Answers

• Question 41:

  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

  Correct Answer: C

  Reference: https://docs.oracle.com/database/apex-5.1/HTMDB/creating-breadcrumbs.htm#HTMDB25538

• Question 42:

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

  Correct Answer: C

  Reference: https://docs.oracle.com/cd/E10513_01/appdev.310/e10497/rprt_query.htm#BABGAFID

• Question 43:

  Penny has created a special survey page, Page 8, where she wants to hide the standard navigation menu.

  Which two ways can Penny hide the navigation menu only for Page 8? (Choose two.)

  A. Update the navigation menu and set condition of Never for Page 8.

  B. Change Page Template to Minimal (No Navigation) for Page 8.

  C. Go to Page Shared Components. Right-click the navigation menu entry and select Delete.

  D. Delete the Navigation Menu region from Page 8.

  E. Set Override User Interface Level to Yes.

  F. Do not include Page 8 in the list of pages in the navigation menu.

  Correct Answer: AB

• Question 44:

  Which best describes how Session State Protection works?

  A. saves sensitive data in Oracle Application Express session state tables in encrypted form, stopping users from tampering with the data

  B. adds checksums to Page Access Protection attributes and Session State Protection item attributes to prevent alteration of session state

  C. saves data in Oracle Application Express session state tables in encrypted form and uses the Page Access Protection attributes and the Session State Protection item attributes with checksums to prevent alteration of session state

  D. encrypts the values supplied in the URL to prevent reading of the values

  Correct Answer: B

  Reference: https://docs.oracle.com/database/121/HTMDB/sec_dev.htm#HTMDB12002

• Question 45:

  Which is true about the Button Name attribute?

  A. When the page is submitted by clicking the button, the value of REQUEST is set to the button name.

  B. The button name is a unique identifier on a page. No other buttons or page items on the page can have the same name.

  C. The button name defines what database action is done on page submit.

  D. The button name serves as a static ID, which is useful when developing custom JavaScript functionality for the button.

  Correct Answer: A

  Reference: https://docs.oracle.com/database/121/HTMDB/bldapp_but.htm#HTMDB25447

• Question 46:

  When testing the Data Load Wizard pages, you realize that you forgot to add a transformation rule. What should you do to add the transformation rule?

  A. Update the existing generated pages.

  B. Update Data Load Definition.

  C. Delete Data Load Definition and re-create it manually.

  D. Use the Create Page Wizard to re-create the pages.

  Correct Answer: B

  Reference: https://docs.oracle.com/en/database/oracle/application-express/18/data_load_wizard/

• Question 47:

  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

  Correct Answer: A

  Reference: https://docs.oracle.com/html/E39147_04/bldapp_cal.htm

• Question 48:

  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.

  Correct Answer: AC

• Question 49:

  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.

  Correct Answer: D

• Question 50:

  Phil has been given the responsibility for an application that was developed years ago, because the original developer has left the company. End users have complained about accessibility because not all

  pages have titles.

  How can Phil ensure that he corrects all pages in the app without page titles?

  A. Run a query on the APEX_PAGE_DETAILS view where PAGE_TITLE is null

  B. Use Application Advisor to perform a check

  C. Ask end users to identify the problem pages

  D. Bring up each page in Page Designer and review the Page Name

  Correct Answer: B