Free Preparation Discussions
MENU
Oracle 1Z0-770 Exam Questions
- Topic 1: Load and Unload data using the Data Workshop Utility/ Managing Application Attributes with App Builder Concepts
- Topic 2: Create and use an authentication scheme for your application/ Migrating Application Development Between Environments
- Topic 3: List and describe the major components of Oracle APEX/ Create an APEX application based on existing tables
- Topic 4: Create and attach an authorization scheme to your application, page, or components/ Describe and Implement Plug-ins in your application
- Topic 5: Create a progressive web application (PWA)/ Getting Started with Oracle APEX on the Oracle Autonomous Database
- Topic 6: Adding Additional Pages to Your Application/ Adding Computations, Processes, Validations, and Branches
- Topic 7: Create and customize a faceted search page/ Create and customize the interactive report
- Topic 8: Implementing Security in Your Application/ Perform One-click Remote Application Deployment
- Topic 9: Create different page types and regions/ Create an APEX application from a file
- Topic 10: Implementing Navigation in Your Application/ Use Theme Roller and Live Template Options Create different types of master-detail forms/ Create and customize the interactive grid
Free Oracle 1Z0-770 Exam Actual Questions
Note: Premium Questions for 1Z0-770 were last updated On Jun. 15, 2025 (see below)
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]
Examine this code used in Quick SQL:
students
name
roll no num
Quick SQL is using default settings.
Which table creation script or other output is produced?
The table creation script produced by Quick SQL is:
create table emp_salary ( id number generated by default on null as identity constraint emp_salary_id_pk primary key, name varchar2 (255 char) not null, salary number, commission_yn varchar2 (1 char) check (commission_yn in ('Y','N')) default 'N' not null );
When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user
with pagination. The two types of pagination available are:
When you click a Customer Name in the Customers report, the Customer Details form dialog
page is displayed. What are the events that occur in this scenario?
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.
Which two statements are true about creating and using dynamic actions?
Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:
You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Lynda
14 days agoTanja
2 months agoTemeka
3 months agoCordelia
4 months agoFlo
5 months agoIlda
5 months agoKris
6 months agoElsa
6 months agoStanford
6 months agoLashaunda
7 months agoMira
7 months agoRhea
7 months agoLing
8 months agoMadelyn
8 months agoFrancene
8 months agoTasia
9 months agoJill
9 months agoBrinda
9 months agoNaomi
9 months agoLawanda
9 months agoLetha
10 months agoLynelle
10 months agoAnnita
11 months agoJaime
1 years agoMarge
1 years agoStephanie
1 years ago