[May 27, 2024] Download Free Oracle 1Z0-770 Real Exam Questions
Pass Your Exam With 100% Verified 1Z0-770 Exam Questions
Oracle 1Z0-770 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
NEW QUESTION # 42
What three are the result of the following QuickSQL shorthand notation do?
departments /insert 4
name /nn
location
country
- A. Create the departments table with 3 columns
- B. Create the departments table with 4 columns
- C. Creates an id column as a primary key
- D. Inserts 4 rows of random data into the departments table
Answer: B,C,D
Explanation:
Explanation
The QuickSQL shorthand notation departments /insert 4 name /nn location country will do the following:
Create the departments table with 4 columns: The first word in the notation is the table name, followed by a slash and the number of rows to insert. The subsequent words are the column names, separated by spaces. QuickSQL will generate a SQL script to create the table with the specified columns and data types.
Creates an id column as a primary key: QuickSQL will automatically add an id column as a primary key to the table, unless the /no_pk modifier is used. The idcolumn will be of type NUMBER and will use an identity constraint to generate unique values.
Inserts 4 rows of random data into the departments table: QuickSQL will use the /insert modifier to insert random data into the table, based on the column names and data types. The number after the modifier indicates how many rows to insert.
The other option is incorrect because:
Create the departments table with 3 columns: This is not what the notation will do. The notation will create the table with 4 columns, not 3.
Verified References: [Using Quick SQL] [About Quick SQL Shorthand Syntax]
NEW QUESTION # 43
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 FALSE.
- B. It will restrict acceptable values to TRUE or FALSE.
- C. It will restrict acceptable values to Y or N.
- D. It will default to TRUE.
Answer: B
Explanation:
Explanation
The commission yn column will restrict acceptable values to TRUE or FALSE because of the /check modifier in the column name. This modifier adds a check constraint to the column based on the values specified after it.
The yn suffix indicates that the column is of type VARCHAR2(1). The other options are incorrect because they do not reflect the effect of the /check modifier or the yn suffix. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax
NEW QUESTION # 44
Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called?
- A. Lists
- B. Navigation Bar List
- C. Breadcrumbs
- D. Navigation Menu
Answer: D
Explanation:
Explanation
The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application. The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.
NEW QUESTION # 45
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?
- A. Popup LOV
- B. Date Picker
- C. Checkbox Group
- D. Range
Answer: C,D
Explanation:
Explanation
In a faceted search page, facets can be displayed as different UI types depending on the data type and cardinality of the facet column or expression. The facet item types are the UI components that are used to render the facets in the faceted search region. The supported facet item types are Range, Checkbox Group, Radio Group, List, Star Rating, and Switch. Date Picker and Popup LOV are not valid facet item types.
Verified References: [Faceted Search Attributes - Oracle Help Center], [Facet Item Types - Oracle APEX]
NEW QUESTION # 46
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. Interactive Report
- B. Side by Side Master Detail
- C. Stacked Master Detail
- D. Cards
Answer: C
Explanation:
Explanation
A stacked master detail is a form type that displays two editable interactive grids based on two related tables or views on the same page. Users select a row in the master grid to update the detail grid6. In this scenario, the departments names with location on the left is the master grid and the employees details on the right is the detail grid. A cards report is not a form type, but a report type that displays data in cards with an image and text7. A side by side master detail is a form type that displays two editable interactive grids based on two related tables or views side by side on the same page. Users select multiple rows in the master grid to update multiple detail grids6. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
NEW QUESTION # 47
Which two statements are true about the APEX MAIL API?
- A. You can send emails using the APEX MAIL package from an Oracle APEX application.
- B. The APEX_MAIL package supports sending emails only to Oracle database users.
- C. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- D. You can add files as attachments to your emails using the APEX_MAIL package.
Answer: A,D
Explanation:
Explanation
The APEX_MAIL package is an API for the APEX mail system that enables developers to send emails from PL/SQL code. Some of the statements that are true about the APEX_MAIL package are:
You can add files as attachments to your emails using the APEX_MAIL package. You can use the APEX_MAIL.ADD_ATTACHMENT procedure to add one or more files as attachments to your emails.
The files can be in various formats, such as PDF, DOCX, XLSX, etc.
You can send emails using the APEX_MAIL package from an Oracle APEX application. You can use the APEX_MAIL.SEND procedure or function to send an outbound email message from your application. You can also specify various parameters for your email, such as sender, recipients, subject, body, priority, etc. The APEX_MAIL package does not support sending emails only to Oracle database users or receiving emails in an Oracle APEX application. You can send emails to any valid email address or use other tools or services to receive emails. Verified References: [APEX_MAIL - Oracle Help Center], [APEX_MAIL : Send Emails from PL/SQL - ORACLE-BASE]
NEW QUESTION # 48
Which component in SQL Workshop allows you to build queries graphically without manual SQLcoding?
- A. Data Workshop
- B. Query Builder
- C. Quick SQL
- D. SQL commands
Answer: B
Explanation:
Explanation
Query Builder is a component in SQL Workshop that allows you to build queries graphically without manual SQL coding. You can use Query Builder to select tables and views from your schema, join them using drag-and-drop operations, add filters andgroupings, and view the results in a grid or chart format. You can also switch to the SQL mode to view or edit the generated SQL statement.
The other options are incorrect because:
Quick SQL is a component in SQL Workshop that allows you to generate SQL scripts for creating tables and other database objects using shorthand syntax. You cannot use Quick SQL to build queries graphically.
SQL Commands is a component in SQL Workshop that allows you to run individual SQL statements or PL/SQL blocks interactively. You cannot use SQL Commands to build queries graphically.
Data Workshop is a component in SQL Workshop that allows you to load or unload data from the database using various file formats. You cannot use Data Workshop to build queries graphically.
Verified References: [About Query Builder] [Using Query Builder]
NEW QUESTION # 49
The APEX engine uses which component as a key for tracking each user's session state?
- A. APEX_USER
- B. LDAP_USER
- C. APP_USER
- D. HTTP_USER
Answer: C
Explanation:
Explanation
APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user's session state.
As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.
NEW QUESTION # 50
Which two are true about Oracle APEX?
- A. Requires no additional client software. A web browser is the app development IDE.
- B. Requires developers to be proficient in Java, Python and other programming languages.
- C. Is declarative. It requires no code generation.
- D. Performs the data processing in a middle-tier server
Answer: A,C
Explanation:
Explanation
Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:
Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications.
You do not need to install or configure any additional software or tools on your client machine.
Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.
The other options are incorrect because:
Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.
Verified References: [About Oracle APEX] [Oracle APEX Architecture]
NEW QUESTION # 51
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?
- A. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
- B. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
- C. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- D. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
Answer: C
Explanation:
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. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]
NEW QUESTION # 52
When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?
- A. Help Page
- B. Modal Dialog
- C. Normal Page
- D. Non-Modal Dialog
Answer: B
Explanation:
Explanation
A modal dialog is a type of page mode that displays an overlay window within the viewport when a button is pressed. A modal dialog is a stand-alone page that does not interact with the base page where it was launched.
A modal dialog blocks access to the base page until it is closed by the user. A modal dialog can be used for various purposes, such as displaying additional information, confirming an action, or collecting user input.
NEW QUESTION # 53
Which two are true when the Edit option is NOT enabled for an Interactive Grid?
- A. The end user cannot edit the underlying data in the database
- B. The end user can edit the underlying data in the database
- C. The end user can customize the report
- D. The end user cannot create charts
Answer: A,C
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 # 54
Which three statements are TRUE about Search Configuration?
- A. Only one Search Configuration can be used in a Search Page.
- B. One or more Search Configurations can be configured in a Search Page.
- C. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
- D. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
Answer: B,C,D
Explanation:
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
NEW QUESTION # 55
Select the two places from where you can access the Shared Components Page?
- A. Page Designer
- B. SQL Workshop
- C. Gallery
- D. Application homepage
Answer: A,D
Explanation:
Explanation
You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page. In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5. In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.
NEW QUESTION # 56
Which two statements are true about creating and managing an APEX Workspace?
- A. A workspace enables multiple users to work within the same Oracle APEX installation.
- B. A workspace can be associated with only one schema.
- C. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
- D. During workspace creation, you can associate the workspace with an existing databaseschema.
- E. New schemas cannot be created during workspace creation.
Answer: A,D
Explanation:
Explanation
A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:
During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.
Verified References: Managing WorkspacesAbout Workspaces
NEW QUESTION # 57
Which statement is true about using the App Gallery?
- A. You cannot install Sample Apps and Starter Apps directly from the Gallery.
- B. Custom Apps are only available if your instance administrator has enabled them.
- C. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
- D. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
Answer: B
Explanation:
Explanation
Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References: Using the App Gallery and Configuring the Application Gallery
NEW QUESTION # 58
Choose the three requirements for creating a REST Enabled SQL Reference.
- A. Set up any remote database
- B. Activate REST Enabled SQL for the target schema on the remote database
- C. Configure and enable the REST Enabled SQL service feature
- D. Install Oracle REST Data Services (ORDS) 19.x or later.
Answer: B,C,D
Explanation:
Explanation
To create a REST Enabled SQL Reference, you need to meet the following requirements:
Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.
Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2.
Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3.
You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.
NEW QUESTION # 59
Which two tasks can you perform using App Builder?
- A. Create join queries using drag and drop.
- B. Generate data definition language (DDL) statements from the Oracle data dictionary.
- C. Create and manage database objects.
- D. Create and manage apps.
- E. Import previously exported apps.
Answer: D,E
Explanation:
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]
NEW QUESTION # 60
......
1Z0-770 Dumps 100 Pass Guarantee With Latest Demo: https://braindumps.getvalidtest.com/1Z0-770-brain-dumps.html