Accurate & Verified 2024 New 1Z0-770 Answers As Experienced in the Actual Test!
1Z0-770 Certification Sample Questions certification Exam
Oracle APEX Developer Professional certification validates the candidate's expertise in building and deploying robust and scalable applications using APEX. APEX is a low-code development platform that enables developers to build web-based applications quickly and easily. With the increasing demand for web-based applications, the Oracle APEX Developer Professional certification has become a valuable asset for developers who want to advance their careers in the field of web development. Additionally, earning this certification demonstrates the candidate's commitment to staying up-to-date with the latest technologies and industry best practices.
Oracle 1Z0-770 certification exam is suitable for developers, architects, and technical consultants who want to demonstrate their proficiency in building APEX applications. Oracle APEX Developer Professional certification exam is an excellent way to showcase your skills and knowledge to potential employers, clients, and colleagues. With the increasing demand for APEX developers globally, the Oracle APEX Developer Professional certification can help you stand out and gain a competitive edge in the IT job market.
NEW QUESTION # 82
In a Classic Report, an end user can perform which two of the following actions?
- A. Sort the columns of the report
- B. Filter values of a column in the report
- C. Create Control Breaks in the report
- D. Rearrange the columns in the report
Answer: A,B
Explanation:
Explanation
In a Classic Report, an end user can perform the following actions:
Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.
The other options are incorrect because:
Create Control Breaks in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
Rearrange the columns in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.
Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]
NEW QUESTION # 83
Which two are true when the Edit option is NOT enabled for an Interactive Grid?
- A. The end user can customize the report
- B. The end user can edit the underlying data in the database
- C. The end user cannot create charts
- D. The end user cannot edit the underlying data in the database
Answer: A,D
Explanation:
Explanation
An interactive grid is a component that displays data in a tabular format and allows users to perform various actions on the data, such as sorting, filtering, grouping, highlighting, and editing. However, the editing feature is optional and can be enabled or disabled by the developer. When the Edit option is not enabled for an interactive grid, the following statements are true:
The end user cannot edit the underlying data in the database. The interactive grid becomes read-only and does not allow users to add, modify, or delete rows. The Add Row and Save buttons are hidden from the toolbar and the cells are not editable.
The end user can customize the report. The interactive grid still allows users to change the appearance and behavior of the report using the Actions menu. Users can perform actions such as changing column order, resizing column width, hiding or showing columns, applying filters or highlights, creating control breaks or charts, and saving reports.
NEW QUESTION # 84
Which two statements are true about Faceted Search pages?
- A. Multiple charts are not visible in the same region.
- B. A facet's chart can be seen only in a nonmodal dialog.
- C. Facets map to specific database columns.
- D. Faceted Search supports the ability to filter columns storing multiple values as one string.
Answer: C,D
Explanation:
Explanation
Faceted Search is a feature 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. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]
NEW QUESTION # 85
Choose the two correct statements about PWA.
- A. To download the app as PWA, one must visit the App Store
- B. An existing APEX app cannot be made a PWA
- C. Provides a customizable offline page when users areoffline and cannot request thenetwork.
- D. Enables users to install the application on devices
Answer: C,D
NEW QUESTION # 86
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?
- A. Data Workshop
- B. Quick SQL
- C. App Builder
- D. Data Generator
Answer: A
Explanation:
Explanation
Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the database.
You can use Data Workshop to copy data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data. While migrating apps, once the database objects are created in the target environment, you can load the data using Data Workshop by following these steps:
Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
Click Load Data.
Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or Object Store Reference (Autonomous Database only).
Specify a file name or location for your data source.
Select a table name for your data destination.
Map your data columns to your table columns.
Review your data load settings and click Load Data.
NEW QUESTION # 87
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Amazon RDS
- B. Microsoft Azure
- C. Oracle Autonomous Cloud
- D. All of the above
- E. Oracle XE
Answer: D
Explanation:
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure
NEW QUESTION # 88
Which three are the main components of APEX workspace homepage?
- A. App Builder
- B. RESTful Services
- C. Gallery
- D. SQL Workshop
Answer: A,C,D
Explanation:
Explanation
The main components of an APEX workspace homepage are:
Gallery: This component displays various sample applications, blueprints, plug-ins, themes, and learning resources that you can use to get started with Oracle APEX.
SQL Workshop: This component allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to run SQL queries or scripts, load or unload data from the database, generate DDL statements, view object reports, and restore dropped objects.
App Builder: This component allows you to create and edit your applications using the Create Application Wizard or the Page Designer. You can also use this component to import or export applications from files or URLs, run or debug applications, manage application settings, and access various utilities.
The other option is incorrect because:
RESTful Services: This component is not part of the APEX workspace homepage. It is part of the SQL Workshop component. It allows you to create and manage RESTful web services based on your database objects or SQL queries.
Verified References: [About the Workspace Home Page] [About SQL Workshop] [About App Builder]
NEW QUESTION # 89
What are the three features of a calendar in APEX?
- A. Month, Week, Day - Displays a monthly, weekly and daily view.
- B. Previous - Navigates to the previous month.
- C. Next - Navigates to the next month.
- D. Reminders - Displays the reminders set by the users
Answer: A,B,C
Explanation:
Explanation
A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.
NEW QUESTION # 90
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?
- A. columns
- B. Data
- C. Filter
- D. Format
Answer: A
Explanation:
Explanation
To hide a few columns in your interactive report, you should choose Columns from the Actions menu. This option allows you to select which columns to show or hide in your report by using checkboxes. You can also reorder or resize the columns from this option.
The other options are incorrect because:
Filter allows you to filter the data in your report by applying one or more conditions on the columns.
Data allows you to add, modify, or delete data in your report by using inline editing or modal dialog editing.
Format allows you to change the appearance of your report by applying conditional formatting rules or highlighting colors.
Verified References: [Customizing Interactive Reports] [Actions Menu]
NEW QUESTION # 91
Plug-ins can be used declaratively in which of the following components in APEX?
- A. All of them
- B. Dynamic Actions
- C. Process Type
- D. Items
- E. Regions
Answer: A
Explanation:
Explanation
Plug-ins can be used declaratively in all of the following components in APEX: Dynamic Actions, Regions, Items, Process Type, and Authentication and Authorization Schemes. Plug-ins are shared components that enable developers to extend the native functionality of APEX with custom components1. Plug-ins can be created or imported from the Shared Components page or the App Gallery1.
NEW QUESTION # 92
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
- A. End user can save the report
- B. End user can rearrange the report interactively using the mouse.
- C. End user can add, modify, and refresh data directly on the report.
- D. End user can customize how and what data is displayed.
Answer: C,D
Explanation:
Explanation
An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:
End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.
The other options are incorrect because:
End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.
Verified References: [About Interactive Reports] [About Interactive Grids]
NEW QUESTION # 93
Select two features of a Smart Filters Page.
- A. Consists of filters at the left side and report on the right side of the page
- B. Each filter represents the text entered by the end user in the search field
- C. Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs.
- D. Consists of a single search field with filters at the top of the page and a report at the bottom
Answer: C,D
Explanation:
Explanation
A smart filters page is a type of component that features a single search field at the top of the page and a search results report (classic report, cards, map, or calendar) at the bottom. A smart filters page behaves similarly to faceted search, but it features a more space efficient layout. Two of the features of a smart filters page are:
Consists of a single search field with filters at the top of the page and a report at the bottom. This feature provides a simple and compact user interface that allows users to enter text in the search field and see suggested filters based on their input. Users can also see and modify applied filters at any time.
Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. This feature provides useful information to users about how many records match each filter value. Users can also choose between different types of suggestions, such as dynamic, static, or SQL query.
NEW QUESTION # 94
Choose the two statements that are TRUE about the Universal Theme in APEX.
- A. Not designed to work on tablets
- B. Responsive UI
- C. Easy customization
- D. The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.
Answer: B,C
Explanation:
Explanation
The Universal Theme is a responsive user interface design for Oracle APEX applications. It has the following features:
Responsive UI: The Universal Theme uses responsive design techniques to adapt to different screen sizes and orientations. It ensures that your applications look great and work well on any device, such as desktops, laptops, tablets, or smartphones.
Easy customization: The Universal Theme allows you to customize the appearance and behavior of your applications using various tools and options. You can use Theme Roller to change the colors, fonts, icons, and styles of your applications. You can also use Template Options to modify the layout and functionality of your components.
The other options are incorrect because:
Not designed to work on tablets: The Universal Theme is designed to work on tablets as well as other devices. It uses responsive design techniques to adapt to different screen sizes and orientations.
The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme: The developers do not need to have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. They can use declarative tools such as Theme Roller and Template Options to customize their applications without coding.
Verified References: [About Universal Theme] [Using Theme Roller] [Using Template Options]
NEW QUESTION # 95
Which statement is true about creating and using an interactive grid?
- A. For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
- B. End users cannot rearrange columns by dragging and dropping.
- C. An interactive grid supports Pivot View and Group By View features.
Answer: A
Explanation:
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 References: Using an Interactive Grid - Oracle Help Center, Example Interactive Grid - Oracle Help Center
NEW QUESTION # 96
Which two among the following are TRUE about Low Code Apps?
- A. Provide Rich Functionality with Less Code
- B. Expensive
- C. Scalable
- D. Not Mobile Friendly
Answer: A,C
Explanation:
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
NEW QUESTION # 97
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You cannot modify the report source query
- B. You can customize the pagination
- C. You can modify the data in the report after running the app
- D. You can customize the Actions menu to include or exclude certain options.
Answer: B,C
NEW QUESTION # 98
You must create a single master detail page where users can select a row in the master grid to update the detail grids.
Users must also interact with the master or the detail without leaving the page.
Which type of master detail implementation should you use?
- A. Side by Side
- B. Drill Down
- C. Stacked
Answer: C
Explanation:
Explanation
A stacked master detail is a type of master detail implementation that features two editable interactive grids based on two related tables or views. Users can select a row in the master grid to update the detail grid. Users can also interact with the master or the detail without leaving the page. A stacked master detail is suitable for scenarios where you want to display and edit data from a one-to-many relationship in a single page. You can create a stacked master detail using either the Create Application Wizard or the Create Page Wizard. Verified References: [Managing Master Detail Forms - Oracle Help Center], [Creating a Single Page Master Detail Using the Create Application Wizard - Oracle Help Center]
NEW QUESTION # 99
You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?
- A. Column Toggle Report
- B. Interactive Grid
- C. Interactive Report
- D. Classic Report
Answer: D
Explanation:
Explanation
When you use the Create Page Wizard to create a faceted search page on any table or SQL query, such as EMP table, APEX generates a classic report region as default report type for this page. A classic report region displays data from a SQL query or PL/SQL function returning a SQL query in tabular format. A faceted search page also contains a region of Faceted Search type, which holds one or more facets that allow end users to filter data by applying one or more facets. Verified References: Creating Faceted Search Pages - Oracle Help Center, Creating Classic Reports - Oracle Help Center
NEW QUESTION # 100
From SQL Workshop, you can perform which two of the following actions?
- A. Delete database
- B. Create and view database objects
- C. Run SQL commands and scripts
- D. Create an APEX user
Answer: B,C
Explanation:
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]
NEW QUESTION # 101
Choose the three types of page items that can be placed on a page.
- A. Date Picker
- B. Checkbox
- C. Select List
- D. Global variable
Answer: A,B,C
Explanation:
Explanation
A page item is a component that is part of an HTML form and can accept user input or display output. There are many types of page items that can be placed on a page in APEX, such as text fields, text areas, radio groups, checkboxes, date pickers, select lists, popup LOVs, shuttles, and so on. Each type of page item has different properties and attributes that affect its appearance and functionality. Three of the types of page items that can be placed on a page are:
Checkbox: A checkbox is a page item that displays one or more options that can be selected or deselected by the user. A checkbox can have either static values or dynamic values based on a list of values (LOV). A checkbox can also have different display styles, such as pill button or switch.
Date Picker: A date picker is a page item that displays a text field with an icon that opens a calendar popup when clicked. A date picker allows users to enter or select a date value in a specific format. A date picker can also have different attributes, such as minimum or maximum date, display format, or time picker.
Select List: A select list is a page item that displays a drop-down list of options that can be selected by the user. A select list can have either static values or dynamic values based on a list of values (LOV). A select list can also have different attributes, such as multiple selection, null value display text, or cascading LOV.
NEW QUESTION # 102
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?
- A. As Private and public only
- B. As Primary only
- C. As Private only
- D. As Public only
Answer: A
Explanation:
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 References: Managing Interactive Grids
- Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]
NEW QUESTION # 103
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?
- A. Page Processing
- B. Page rendering and processing
- C. Page compilation
- D. Page Rendering
Answer: B
Explanation:
Explanation
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.
NEW QUESTION # 104
Which two of the following types can an end user save the customized Interactive report as?
- A. Default report
- B. Cannot save the report
- C. A private report
- D. A Public report
Answer: C,D
NEW QUESTION # 105
......
Oracle 1Z0-770 exam measures the candidate's knowledge and skills in various areas of APEX development. 1Z0-770 exam covers topics such as APEX architecture, application design, security, data modeling, SQL, PL/SQL, and APEX APIs. Candidates are required to demonstrate their ability to design, develop, test, and deploy APEX applications. 1Z0-770 exam also includes scenario-based questions that test the candidate's ability to solve real-world problems.
Certification Topics of 1Z0-770 Exam PDF Recently Updated Questions: https://www.prep4pass.com/1Z0-770_exam-braindumps.html
1Z0-770 Exam Prep Guide: Prep guide for the 1Z0-770 Exam: https://drive.google.com/open?id=1gZPo-4bf2LTu52-tUeihqcWQXbt1XzU8
