Free Oracle 1z1-770 Exam Dumps Questions & Answers

Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?

• A.Side by Side Master Detail
• B.Cards
• C.Stacked Master Detail
• D.Interactive Report

Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?

• A.It will default to TRUE.
• B.It will restrict acceptable values to Y or N.
• C.It will default to FALSE.
• D.It will restrict acceptable values to TRUE or FALSE.

Which statement is true about creating and using a faceted search page?

• A.The Search Results region can be displayed as a Classic Report or Cards.
• B.The Search Results region can be displayed as an interactive report.
• C.If you create a faceted search page based on a table, the facets are not auto-discovered.
• D.If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.

Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?

• A.Session
• B.Quick Edit
• C.Debug
• D.Customize

You have defined a REST Data Source with ORDS as the REST Data Source Type. This REST Data Source is based on an AutoREST-enabled EMP table on a remote Oracle Database. This REST Data Source is beingused as source for an editable interactive grid. When a user updates an employee record in this interactive grid, which operation (HTTP Method) defined in the REST Data Source is utilized to update a record in the EMP table on the remote Oracle Database?

• A.POST
• B.PUT
• C.GET