Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-770

Oracle 1Z0-770 Exam (page: 1)
Oracle APEX Developer Professional
Updated on: 11-Nov-2025

Viewing Page 1 of 30
1Z0-770 PDF 142 Questions

Which statement is true about creating and using an interactive grid?

  1. For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
  2. An interactive grid supports Pivot View and Group By View features.
  3. End users cannot rearrange columns by dragging and dropping.

Answer(s): A

Explanation:

An interactive grid is a customizable report that allows end users to modify the data and layout of the report. End users can change the report layout by using the Actions menu or by dragging and dropping columns. They can also create private reports that save their personal preferences for the report. These features are available for both editable and noneditable interactive grids. Verified


Reference:

Using an Interactive Grid - Oracle Help Center, Example Interactive Grid - Oracle Help Center



You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?

  1. As Primary only
  2. As Public only
  3. As Private only
  4. As Private and public only

Answer(s): D

Explanation:

When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified


Reference:

Managing Interactive Grids - Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]



Which two statements are true about creating and using an interactive report?

  1. You can specify an Authorization Scheme at the column level.
  2. You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
  3. You cannot customize the Search Button Label.
  4. You cannot restrict users from saving private reports by using the Authorization Scheme.

Answer(s): A,C



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

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

Answer(s): C

Explanation:

A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. You can create a faceted search page by using the Create Page Wizard or by adding a faceted search region to an existing page. If you create a faceted search page based on a table, view, or SQL query, the facets are auto-discovered by analyzing the data source. The Search Results region can be displayed as a Classic Report or Cards, but not as an interactive report. You can also customize the appearance and behavior of the facets and the search results by using various attributes. Verified


Reference:

[Creating Faceted Search Pages - Oracle Help Center], [Faceted Search Attributes - Oracle Help Center]



Which is a valid method of logging messages to the execution log in APEX automation?

  1. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
  2. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
  3. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification ) ;

Answer(s): A

Explanation:

APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified


Reference:

[Using APEX Automation - Oracle Help Center], [APEX_DEBUG - Oracle Help Center]



Viewing Page 1 of 30



Share your comments for Oracle 1Z0-770 exam with other users:

User123 10/8/2023 9:59:00 AM

good question
UNITED STATES


vinay 9/4/2023 10:23:00 AM

really nice
Anonymous


Usman 8/28/2023 10:07:00 AM

please i need dumps for isc2 cybersecuity
Anonymous


Q44 7/30/2023 11:50:00 AM

ans is coldline i think
UNITED STATES


Anuj 12/21/2023 1:30:00 PM

very helpful
Anonymous


Giri 9/13/2023 10:31:00 PM

can you please provide dumps so that it helps me more
UNITED STATES


Aaron 2/8/2023 12:10:00 AM

thank you for providing me with the updated question and answers. this version has all the questions from the exam. i just saw them in my exam this morning. i passed my exam today.
SOUTH AFRICA


Sarwar 12/21/2023 4:54:00 PM

how i can see exam questions?
CANADA


Chengchaone 9/11/2023 10:22:00 AM

can you please upload please?
Anonymous


Mouli 9/2/2023 7:02:00 AM

question 75: option c is correct answer
Anonymous


JugHead 9/27/2023 2:40:00 PM

please add this exam
Anonymous


sushant 6/28/2023 4:38:00 AM

please upoad
EUROPEAN UNION


John 8/7/2023 12:09:00 AM

has anyone recently attended safe 6.0 certification? is it the samq question from here.
Anonymous


Blessious Phiri 8/14/2023 3:49:00 PM

expository experience
Anonymous


concerned citizen 12/29/2023 11:31:00 AM

52 should be b&c. controller failure has nothing to do with this type of issue. degraded state tells us its a raid issue, and if the os is missing then the bootable device isnt found. the only other consideration could be data loss but thats somewhat broad whereas b&c show understanding of the specific issues the question is asking about.
UNITED STATES


deedee 12/23/2023 5:10:00 PM

great help!!!
UNITED STATES


Samir 8/1/2023 3:07:00 PM

very useful tools
UNITED STATES


Saeed 11/7/2023 3:14:00 AM

looks a good platform to prepare az-104
Anonymous


Matiullah 6/24/2023 7:37:00 AM

want to pass the exam
Anonymous


SN 9/5/2023 2:25:00 PM

good resource
UNITED STATES


Zoubeyr 9/8/2023 5:56:00 AM

question 11 : d
FRANCE


User 8/29/2023 3:24:00 AM

only the free dumps will be enough for pass, or have to purchase the premium one. please suggest.
Anonymous


CW 7/6/2023 7:37:00 PM

good questions. thanks.
Anonymous


Farooqi 11/21/2023 1:37:00 AM

good for practice.
INDIA


Isaac 10/28/2023 2:30:00 PM

great case study
UNITED STATES


Malviya 2/3/2023 9:10:00 AM

the questions in this exam dumps is valid. i passed my test last monday. i only whish they had their pricing in inr instead of usd. but it is still worth it.
INDIA


rsmyth 5/18/2023 12:44:00 PM

q40 the answer is not d, why are you giving incorrect answers? snapshot consolidation is used to merge the snapshot delta disk files to the vm base disk
IRELAND


Keny 6/23/2023 9:00:00 PM

thanks, very relevant
PERU


Muhammad Rawish Siddiqui 11/29/2023 12:14:00 PM

wrong answer. it is true not false.
SAUDI ARABIA


Josh 7/10/2023 1:54:00 PM

please i need the mo-100 questions
Anonymous


VINNY 6/2/2023 11:59:00 AM

very good use full
Anonymous


Andy 12/6/2023 5:56:00 AM

very valid questions
Anonymous


Mamo 8/12/2023 7:46:00 AM

will these question help me to clear pl-300 exam?
UNITED STATES


Marial Manyang 7/26/2023 10:13:00 AM

please provide me with these dumps questions. thanks
Anonymous