Oracle Oracle Database 1Z0-750 Questions & Answers

• Question 11:

  You created an application where the home page looks like:

  

  You now want to change the page to look like:

  

  What do you need to do to change the appearance of the page?

  A. Update the region Type to "List View"

  B. Update the list Template to "Media List"

  C. Update the list Template Options > Style to "Basic"

  D. Update the region Template Options > Icons to "No Icons"

  Correct Answer: B

  Reference: https://apex.oracle.com/pls/apex/apex_pm/r/ut/lists

• Question 12:

  Mary is using an APEX Interactive Grid report that has many columns and wants to see the most important

  information while minimizing horizontal scrolling.

  Which three actions will help her to best accomplish this goal? (Choose three.)

  A. Define a filter

  B. Freeze the first few columns

  C. Reset report settings

  D. Hide the columns that are not important to see

  E. Reduce the width of columns

  F. Order the columns so that the most important columns are first

  G. Collapse the report settings area

  Correct Answer: BFG

• Question 13:

  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.

  Correct Answer: A

• Question 14:

  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.

  Correct Answer: ADE

  Reference: https://docs.oracle.com/cd/E11882_01/appdev.112/e12511/obj_brows.htm#AEUTL185

• Question 15:

  Jason has developed an app for maintaining customers. He has a navigation menu for customers that he needs to associate with multiple pages.

  How can Jason associate one list entry with multiple pages?

  A. Set List Entry Current for Pages Type to "Comma Delimited Page List."

  B. Update the list entry User Defined Attribute 01 to "MULTIPLE", and User Defined Attribute 02 to the list of pages.

  C. Update each page and set Current Navigation Menu Entry to "Customers".

  D. Add additional list entries labeled Customers.

  E. Update list entry Condition Type to "Current Page Is Contained Within Expression 1 (comma delimited list of pages)."

  Correct Answer: E

• Question 16:

  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

  Correct Answer: B

• Question 17:

  Trillian wants to pass an item value, which includes a comma, such as the value Donuts, Coffee, in the URL when calling another page.

  How can Trillian escape the item value so that the comma is interpreted correctly?

  A. /Donuts,Coffee/

  B. \Donuts,Coffee\

  C. Donuts\,Coffee

  D. "Donuts,Coffee"

  Correct Answer: D

• Question 18:

  Jane is creating a new application. Users of the application will use SSO to authenticate. SSO has been defined for the 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. Update Advanced Settings to specify authentication.

  Correct Answer: A

  Reference https://docs.oracle.com/database/apex-18.1/HTMDB/establishing-user-identity-throughauthentication.htm#HTMDB12003

• Question 19:

  Rick has created an "editable" interactive grid on a table that includes four audit columns: CREATED, CREATED_BY, UPDATED, and UPDATED_BY.

  The four audit columns are included in the report with read-only type set to Always.

  How can Rick update all four audit columns when a user inserts a row, and the UPDATED and UPDATED_BY columns when a user updates a row?

  A. using "Enable" Dynamic Actions

  B. using default values on the report columns

  C. using After Header Computations

  D. defining an After Submit process

  Correct Answer: A

• Question 20:

  Which two actions can be done by a Page Process of type Automatic Row Processing (DML)? (Choose two.)

  A. Perform automatic detection of lost updates.

  B. Perform CRUD operations on multiple tables.

  C. Log a user-defined message when an exception is raised.

  D. Apply a SQL WHERE clause to append to all generated INSERT, UPDATE, and DELETE statements at run time.

  E. generate a primary key column value on a SQL INSERT statement.

  F. Invoke PL/SQL code to perform the inserts, updates, and deletes.

  Correct Answer: DF

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