1Z0-770-23 Practice Test
*You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component. Examine this list: 1. The ID 2. The NEW_START_DATE 3. The NEW_END_DATE How can these be referenced? #APEX.PK_VALUE#, #APEX.NEW_START_DATE# and #APEX.NEW_END_DATE# :APEXSPK_VALUE, APEX$NEW_START_DATE and :APEX$NEW_END_DATE :APEX.PK VALUE, :APEX.NEW_START_DATE and : APEX.NEW_END_DATE #APEX$PK_VALUE, #APEX$NEW_START_DATE# and #APEX$NEW_END_DATE#
:APEXSPK_VALUE, APEX$NEW_START_DATE and :APEX$NEW_END_DATE
*Which two statements are true about loading data from the "Create an Application from a File" wizard? A sample data set from the sample list can be uploaded. Seed data from a SQL script can be uploaded. Data from remote web services can be uploaded. XML and JSON data can be pasted and loaded. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
A sample data set from the sample list can be uploaded. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
Which two statements are true about creating and managing an APEX Workspace? A workspace enables multiple users to work within the same Oracle APEX installation. You can create only two workspaces in an APEX Service (APEX Application Development) instance. New schemas cannot be created during workspace creation. A workspace can be associated with only one schema. During workspace creation, you can associate the workspace with an existing database schema.
A workspace enables multiple users to work within the same Oracle APEX installation. During workspace creation, you can associate the workspace with an existing database schema.
*Which statement is true about session state management in Oracle APEX? Multiple number of sessions cannot exist in the database at the same time. A user cannot run multiple instances of an application simultaneously in different browser programs. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
*You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page? Add Users Assign roles to users Create new application roles Create Authorization schemes
Add Users Assign roles to users
You can create an APEX workspace and build APEX apps on which of the following platforms? Oracle Autonomous Cloud Oracle XE Amazon RDS Microsoft Azure All of the above
All of the above
What you can export by using the Export/Import utility? All the options Application Uploaded cascading stylesheets Uploaded images
All the options
Which statement is true about provisioning an APEX workspace? An APEX workspace is a shared work area where multiple developers can build applications You can create only one workspace in an APEX instance A workspace is not associated with any schema You cannot associate an existing database schema with your workspace
An APEX workspace is a shared work area where multiple developers can build applications
Which statement is true about reports in Oracle APEX? An interactive reports allows end users to customize the report layout and data displayed by selecting options on the Actions menu A classic report page includes the customization capabilities available in interactive reports, as well as the ability to rearrange the report interactively using the mouse and keyboard You can create a report only by using Create Application Wizard, not by using Create Page Wizard An interactive page features colorful blocks, which resemble index cards, laid out on a page.
An interactive reports allows end users to customize the report layout and data displayed by selecting options on the Actions menu
Which three are the main components of APEX workspace homepage? RESTful Services App Builder Gallery SQL Workshop
App Builder Gallery SQL Workshop
Which two statements are true about low code application development with Oracle APEX? Application Development IDE is web browser Data processing is not done in the database Apps cannot natively access Oracle Database capabilities The application definition is not stored in the database Using APEX, you can build mission-critical enterprise apps
Application Development IDE is web browser Using APEX, you can build mission-critical enterprise apps
Which two statements are true about Oracle APEX? Process and data manipulation is not executed in the database. APEX eliminated middle-tier application logic. Running and APEX app needs client software Application definition is not stored in the database You can build interactive reporting apps based on data from disparate systems
Application definition is not stored in the database You can build interactive reporting apps based on data from disparate systems
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type? As Private and Public only As Public only As Primary only As Private only
As Private only
*You created a shopping cart application and added the "Add to Cart" functionality. You are using an APEX Collection named CART to temporarily store the items In the cart. Which PL/SQL Code snippet can be used to add items (PRODUCT_ID) into this APEX collection when the user adds items to the cart? Assume: P2_PRODUCT_ID holds the product id of the item being added to the cart. BEGIN INSERT INTO APEX COLLECTION (id, name, c001) values (1, 'CART' ::P2_PRODUCT_ID); END: BEGIN INSERT INTO CART (id, c001) values (1, P2_PRODUCT_ID); END: BEGIN APEX COLLECTION.ADD_MEMBER ( p collection_name => 'CART', P_c001 P2_PRODUCT_ID ); END;
BEGIN APEX COLLECTION.ADD_MEMBER ( p collection_name => 'CART', P_c001 P2_PRODUCT_ID ); END;
You require a Page Computation to execute before the page is rendered. Which two computation points (Execution Point) will do this? After Submit After Page Processing Before Header After Header
Before Header After Header
Which two types of pages can you create by using the Create Page Wizard? Blank Page Interactive Grid Shared components Utilities Team Development
Blank Page Interactive Grid
Which two actions can you perform using the Object Browser? Browse database objects of the current schema. Export and import SQL scripts. Restore dropped database objects. Create and run SQL scripts. Create a lookup table based on a column in the current table
Browse database objects of the current schema. Create and run SQL scripts.
Which two types of calendars are supported by App Builder? Calendar Global Calendar Regional Calendar Legacy Calendar
Calendar Legacy Calendar
Which statement is true about creating and using a calendar in an APEX application? You can create a calendar only by using the Create Page Wizard, not as a region on an existing page Calendars in APEX are based on a table or SQL query you provide You can create a calendar only by using the Create Application Wizard, not by using the Create Page Wizard The data source for your calendar can only be a local database, not an external datasource
Calendars in APEX are based on a table or SQL query you provide
In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard? Interactive Grid Cards Unified Task List Master Detail
Cards
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? Date Picker Checkbox Group Popup LOV Range
Checkbox Group Range
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? Interactive Grid Classic Report Column Toggle Report Interactive Report
Classic Report
Which is NOT a Preconfigured Authentication Scheme? Database Accounts Application Express Accounts Closed Door Credential No Authentication
Closed Door Credential
Which two tasks can you perform using Quick SQL? Export an application Compare schemas Quickly develop a script for sample tables and views Import an application Easily generate random data
Compare schemas Quickly develop a script for sample tables and views
Which two tasks can you perform using App Builder? Create and manage apps. Create and manage database objects. Generate data definition language (DDL) statements from the Oracle data dictionary. Import previously exported apps. Create join queries using drag and drop.
Create and manage database objects. Import previously exported apps.
What three are the result of the following QuickSQL shorthand notation do? departments /insert 4 name /nn location country Creates an id column as a primary key Inserts 4 rows of random data into the departments table Create the departments table with 4 columns Create the departments table with 3 columns
Creates an id column as a primary key Inserts 4 rows of random data into the departments table Create the departments table with 4 columns
Which client credentials are utilized for authentication during the One-Click Remote Application Deployment process? APEX Developer credentials Database schema credentials APEX Workspace Admin credentials
Database schema credentials
Which two form types can you create in an APEX application? Editable Interactive Grid Rest Data Source Quick Edit Master Detail Smart Filters
Editable Interactive Grid Master Detail
Which statement is true about a Progressive Web Application (PWA)? To make an existing app a PWA, you must verify that the Friendly URLs attribute is off in the Application Definition, Properties section PWA features will be rendered even in an unsecured environment Enabling PWA functionality in your APEX app adds a new navigation bar entry named Install App to your application You can only create a PWA when creating a new app. You cannot make an existing app a PWA
Enabling PWA functionality in your APEX app adds a new navigation bar entry named Install App to your application
*Which two statements are true about a Progressive Web Application (PWA)? You can create a PWA only when creating a new application with the Create Application Wizard. Enabling the PWA functionality optimizes page loading speed on a mobile device. PWA features will be rendered even if the application is served in an unsecured environment. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned off. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
Enabling the PWA functionality optimizes page loading speed on a mobile device. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
*There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned off. Which are two of the actions that you must perform to make an employee's commission editable in the grid? Set EMPNO, ENAME to "Display Only". Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
Which two report types can you create by using the Create Page Wizard? REST Data Sources Faceted Search Quick SQL Smart Filters Build Options
Faceted Search Smart Filters
*Which two feature pages can you create using the Create Page Wizard? Unified Task List Feedback Access Control Search Page
Feedback Access Control
Which statement is true about creating and using an interactive grid? End users cannot rearrange columns by dragging and dropping. For both editable and noneditable interactive grids, end users can change the report layout and create private reports. An interactive grid supports Pivot View and Group By View features
For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
*Which two statements are true about customizing an interactive report by an end user? Standard Oracle functions cannot be added to columns. From the Actions menu, multiple charts can be created. A flashback query can be executed. Mathematical computations can be added to columns.
From the Actions menu, multiple charts can be created. Mathematical computations can be added to columns.
Which two statements are true about REST Data Source Synchronization? You cannot trigger Data Synchronization on a regular schedule using a scheduler job. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
Which two statements are true about creating and customizing Smart Filters pages? If you create a Smart Filters page based on a table, the filters are auto-discovered using the Data Dictionary Cache. The search results report can be displayed as an interactive grid. The search results report can be displayed as an interactive report. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
If you create a Smart Filters page based on a table, the filters are auto-discovered using the Data Dictionary Cache. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
Which two statements are true about the Link Column attribute of an interactive report? It is not possible to exclude Link Column. If you select Link Column, it is always displayed as the last column in the report. It is not possible to include a custom target in Link Column. A Link Column cannot be sorted, hidden, or moved by an end user.
If you select Link Column, it is always displayed as the last column in the report. A Link Column cannot be sorted, hidden, or moved by an end user.
An application includes a report and form on the PRODUCTS table. The form page includes page items P21_PRODUCT_NAME and P21_UNIT_PRICE. P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME. Now, you need to reposition the items and display P21 UNIT PRICE next to P21 PRODUCT NAME. Which two statements are true? In Page Designer, right-click P21_UNIT_PRICE and select Start New Row. In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and drag the item until it is directly next to P21 PRODUCT NAME. In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and drag the item until it is directly next to P21 PRODUCT NAME. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
*Which statement is true about using SQL Commands? You can design and prototype data models using a markdown-like shorthand syntax. You can unload data from the database. In SQL Commands, you can view queries saved in Query Builder. You can search and filter database objects.
In SQL Commands, you can view queries saved in Query Builder.
In your application, you want to display data in a searchable, customizable report that supports inline editing at run time using the mouse or keyboard. Which report type will you create? Classic Report Interactive Report Smart Filters Interactive Grid
Interactive Grid
Which two statements are true about the Create Application Wizard? (Look at phone for Picture) It allows the uploading of JavaScript or CSS files required for an application. It allows application pages to be added or deleted. It allows application pages to be reordered. It allows the application authorization to be changed.
It allows application pages to be added or deleted. It allows the application authorization to be changed.
Which statement is true about Unified Task List in the Approvals component? It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions. It is a shared component used to configure task parameters, participants, actions, and due dates.
It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
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? It will default to FALSE. It will default to TRUE. It will restrict acceptable values to Y or N. It will restrict acceptable values to TRUE or FALSE
It will restrict acceptable values to TRUE or FALSE
Which is NOT a valid Geometry Column Data Type available for maps region? Latitude/Longitude SDO GEOMETRY GeoJSON JSON_OBJECT
JSON_OBJECT
*You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1_ENAME page item. Which text, when placed in Source, will display the message correctly? Join me in congratulating : P1_ENAME as the new employee of the month! Join me in congratulating &P1_ENAME. as the new employee of the month! Join me in congratulating v('P1_ENAME') as the new employee of the month!
Join me in congratulating &P1_ENAME. as the new employee of the month!
*Which two tasks can you perform using SQL Workshop? Load and unload text, DDL, and spreadsheet data. Install and manage Sample Apps. Edit an application page. Track and manage issues in a conversational fashion. Create join queries using drag and drop.
Load and unload text, DDL, and spreadsheet data. Create join queries using drag and drop.
Using Data Workshop, you can perform which three tasks: Load vast amount of data into the database Export vast amount of data from the database into a file Load data using various file formats such as XLSX, CSV, XML, and JSON Delete data from the database
Load vast amount of data into the database Export vast amount of data from the database into a file Load data using various file formats such as XLSX, CSV, XML, and JSON
In a Master-Detail form, what do you need to specify to link the Detail to the Master? Master Block Master Table Master Form Process Master Region
Master Region
Which two functions can be used by an end user when pivoting an interactive report? Rank List aggregate List aggregate Minimum Median
Minimum Median
Which statement is true about creating and using pages in an APEX application? A user cannot interact with a nonmodal dialog and content on the page. You can copy a page only from the current application. Modal and nonmodal dialog pages are supported only if the current application theme contains at least one page template of type Dialog Page.
Modal and nonmodal dialog pages are supported only if the current application theme contains at least one page template of type Dialog Page.
Which two tasks can you perform by using Page Designer? Copy an application Modify a button Create an application Import an application Add a new region or an item
Modify a button Add a new region or an item
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources? A single REST Data Source can use multiple remote servers. The remote server should mandatorily be an APEX instance. Multiple REST Data Sources can reference a single remote server. The remote server determines the base URL of the REST Data Source.
Multiple REST Data Sources can reference a single remote server. The remote server determines the base URL of the REST Data Source.
Which two statements are true about Faceted Search pages? Multiple charts are not visible in the same region. Faceted Search supports the ability to filter columns storing multiple values as one string. Facets map to specific database columns. A facet's chart can be seen only in a nonmodal dialog.
Multiple charts are not visible in the same region. Facets map to specific database columns.
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? 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. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
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.
In your existing Employee Benefits application, you want to determine the most active users, the most used pages, and the performance of pages to better understand how your application is being utilized and areas for improvement. How ran this be achieved? On the Application Home page, click Create Page. In the Create Page Wizard, select the Activity Reporting feature type On the Application Home page, click Create Page. In the Create Page Wizard, select the Master Detail page type. On the Application Home page, from the Tasks list, click the Add Feature Page button Then select the feedback feature type. On the Application Home page, click Create Page. In the Create Page Wizard, select the Email Reporting feature type.
On the Application Home page, click Create Page. In the Create Page Wizard, select the Activity Reporting feature type
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX? On the remote Oracle Database, install ORDS 19.x or later. REST enable the schema in the remote Oracle Database using ORDS. ENABLE_SCHEMA. Install Oracle APEX in the remote Oracle Database. Create a database link to the remote Oracle Database in the local APEX Schema.
On the remote Oracle Database, install ORDS 19.x or later. REST enable the schema in the remote Oracle Database using ORDS. ENABLE_SCHEMA.
*Which two are valid evaluation points for Authorization Schemes? Never Once per user Once per page view Once per session
Once per page view Once per session
Which statements are true about creating applications using Oracle APEX? When creating an application from a file, you can only load data into a new table but not to an existing table. Using the Create Application Wizard, you can only create an application from file Oracle APEX application pages share a common session state and authentication Once an application is created, you cannot create additional pages Using the Create Application Wizard, you can only create an application based on existing tables
Oracle APEX application pages share a common session state and authentication Once an application is created, you cannot create additional pages
Which two self-service tools are available with Autonomous Database? Encryption only in Object Storage Business Objects Oracle Machine Learning Low Code App Dev, APEX
Oracle Machine Learning Low Code App Dev, APEX
*Which search type in search Configurations provides linguistic and fuzzy search capabilities? Standard Oracle Text List
Oracle Text
*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 being used 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? PUT GET POST
PUT
Which statement is true about page components? Pages require one of each component Pages contain user interface elements Items can be regions on a page Regions contain pages and items
Pages contain user interface elements
*An application includes a form on the EMPLOYEES table. You must limit the p5 MANAGER page item so users can select a single employee name EMP_NAME and save the corresponding employee ID EMP_ID to the database. Examine this statement used for the List of Values definition: SELECT emp_name d, emp_id r from employees ORDER BY 1; Which item type can be used to display P5_MANAGER? Popup LOV Switch Check box
Popup LOV
By default, which interactive grid report type can be created by an end user? Public report Alternative report Primary report Private report
Private report
Which component in SQL Workshop allows you to build queries graphically without manual SQL coding? Data Workshop Query Builder SQL commands Quick SQL
Query Builder
Which two spatial geometry objects are supported on a Map page in your APEX application? Range Box Plot Radar Lines Points
Radar Lines Points
Which two Plugin types can be created in Oracle APEX? Region Process Email Template Validation
Region Process
Which two are true about Oracle APEX? Requires no additional client software. A web browser is the app development IDE. Performs the data processing in a middle-tier server Requires developers to be proficient in Java, Python and other programming languages. Is declarative. It requires no code generation.
Requires no additional client software. A web browser is the app development IDE. Is declarative. It requires no code generation.
Which pane in Page Designer allows the editing of a component's properties? Toolbar Right pane Central pane Left pane
Right pane
From SQL Workshop, you can perform which two of the following actions? Run SQL commands and scripts Create and view database objects Create an APEX user Delete database
Run SQL commands and scripts Create and view database objects
*Which two Query Source types can be used to create a dynamic Navigation Bar List? SQL Query Procedure Function Returning SQL Query Select List
SQL Query Function Returning SQL Query
Which two among the following are TRUE about Low Code Apps? Not Mobile Friendly Scalable Expensive Provide Rich Functionality with Less Code
Scalable Provide Rich Functionality with Less Code
Which is a standard for exchanging authentication and authorization information between different security domains, to provide cross-organization single sign-on? Open ID Security Assertion Markup Language Sign-on System Virtual Private Database (VPD)
Security Assertion Markup Language
*Which is a valid Page Process type? Send E-Mail Set Value Execute JavaScript Code
Send E-Mail
*There is a validation of type Item is numeric on the P1 SALARY item. When the page is submitted, this error message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area? Setting Display Location to Inline in Notification Setting the Value Required to Yes on P1_SALARY Removing P1_SALARY from the validation Associated Item
Setting Display Location to Inline in Notification
*Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked? Setting the Hide and Show Behavior attribute value to No rescaling Setting the Hide and Show Behavior attribute value to Rescale Setting the Data Change attribute value to slide to Left Setting the Hide and Show Behavior attribute value to None
Setting the Hide and Show Behavior attribute value to No rescaling Setting the Hide and Show Behavior attribute value to Rescale
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards? Social Sign-In Open Door Credentials SAML Sign-In HTTP Header Variable
Social Sign-In
Now you must extend the functionality of this form so that: (Look at Phone for Picture) • If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayed • If you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date' (P2 HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed? Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM. Create a dynamic action on form load. Specify a client-side condition of type Item = Value and enter SALESMAN for Value. Create a dynamic action on P2_JOB. Create a dynamic action on P2_HIREDATE and P2_COMM.
Specify a client-side condition of type Item = Value and enter SALESMAN for Value. Create a dynamic action on P2_JOB.
*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? Stacked Drill Down Side by Side
Stacked
Which two approaches can be used to create custom stored procedures in SQL Workshop? Quick SQL Data Workshop Standalone SQL commands Procedure Builder SQL scripts
Standalone SQL commands SQL scripts
You created a custom theme for an application. Examine these requirements: 1. The theme must be utilized by another application in the same workspace. 2. The master theme may still require changes. Which solution guarantees that any changes to the master theme are reflected in the copied theme? Subscribing the copied theme to the master theme and refreshing the theme Refreshing the templates Copying the changes made in the master theme to the copied theme Verifying the theme subscription
Subscribing the copied theme to the master theme and refreshing the theme
*Which statement is true about creating and using a report with form? The Create Application Wizard doesn't support the creation of an interactive report and form combination. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source). Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination. The Create Page Wizard doesn't support the creation of a classic report and form combination.
The Create Page Wizard doesn't support the creation of a classic report and form combination.
Which statement is true about creating and using forms in an APEX application? A Stacked Master Detail is a single page master-detail utilizing side-by-side layout and report regions with modal edit windows You can create a form only by using the Create Page Wizard. You can create a form in Page Designer The Master Detail form enables users to insert, update, delete values from two tables or views You can create a form only by using the Create Application Wizard. You cannot create a form in Page Designer
The Master Detail form enables users to insert, update, delete values from two tables or views
*Which statement is true about creating and using a faceted search page? The Search Results region can be displayed as a Classic Report or Cards. If you create a faceted search page based on a table, the facets are not auto-discovered. The Search Results region can be displayed as an interactive report. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
The Search Results region can be displayed as a Classic Report or Cards.
An application was created using the Create Application Wizard which enabled the Access Control feature. Which two components are created when enabling the Access Control feature? The configuration page to set access level of authenticated users The configuration page to enable end users to select various theme styles The configuration page to set roles of workspace users The administrative page region with links to Access Control feature The configuration page to enable Administrators to select default theme.
The configuration page to set roles of workspace users The administrative page region with links to Access Control feature
Which statement is true about the Data Workshop utility? You cannot load data from an XLSX file with multiple worksheets. You can load or unload multiple tables at a time. The wizards load and unload table data only. The wizards load and unload all types of schema objects.
The wizards load and unload table data only.
Which statement is true about Theme Styles in Oracle APEX? You can only enable the Is Curre nt attribute when the Theme Style has the Read Only attribute disabled. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment. Theme Styles in Oracle APEX determine the layout and structure of a webpage.
Theme Styles in Oracle APEX determine the layout and structure of a webpage.
*Which two layout options are available for Page Designer under Utilities? Four Pane Mode Single Pane Mode Three Pane Mode Two Pane Mode
Three Pane Mode Two Pane Mode
Which two approaches can be used to create custom stored procedures in SQL Workshop? Using Object Browser Using Quick SQL Using SQL scripts Using Data Workshop
Using Object Browser Using SQL scripts
Which statement is true about implementing security in your APEX application? Authentication refers to restricting access to specific pages and components in your application based on your privileges Once created, you cannot change the authentication scheme associated with an application Confirming a user's identity before allowing access to the application is known as authorization You can apply an authorization scheme to an entire application or its components
You can apply an authorization scheme to an entire application or its components
Which two statements are true about creating and using dynamic actions? If no client-side condition is defined, true actions will not fire. You can execute JavaScript code by creating a dynamic action. Once you create a dynamic action, you cannot add additional true actions. 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 execute JavaScript code by creating a dynamic action. 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.
Which statement is true about exporting and importing your APEX application? You can export APEX application as zip file Using the Export Application Wizard, you can only export the application but not the supporting object definitions Your application is saved as .txt file You can export an APEX application from an instance running APEX 22.1 and import into APEX 21.1 version
You can export APEX application as zip file
Which two statements are true about the APEX_MAIL API? You can send emails using the APEX_MAIL package from an Oracle APEX application. The APEX_MAIL package supports sending emails only to Oracle database users. You can add files as attachments to your emails using the APEX_MAIL package. You can receive emails using the APEX_MAIL package in an Oracle APEX application.
You can send emails using the APEX_MAIL package from an Oracle APEX application. You can add files as attachments to your emails using the APEX_MAIL package.
Which two statements are true about creating and using an interactive report? You cannot include Form Page when creating an interactive report page using the Create Page Wizard. You cannot customize the Search Button Label. You can specify an Authorization Scheme at the column level. You cannot restrict users from saving private reports by using the Authorization Scheme.
You can specify an Authorization Scheme at the column level. You cannot restrict users from saving private reports by using the Authorization Scheme.
*Which statement is true about importing an APEX application? You cannot import an APEX application exported from a latest APEX version to an old APEX version. The import process does not import the supporting objects defined during the export. You cannot change the application ID during the import process.
You cannot import an APEX application exported from a latest APEX version to an old APEX version.
Which is a valid method of logging messages to the execution log in APEX automation? apex_error.add_error( p_message => 'SAL for||:ENAME|| increased by 1%. ', p_display_location=> apex error.c_inline_in_notification); apex_automation. log_info('SAL for || :ENAME || increased by 1%.'); apex_debug.info ('SAL for'||:ENAME|| increased by 1%.');
apex_automation. log_info('SAL for || :ENAME || increased by 1%.');
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? create table students ( id number generated by default on null as identity constraint students_id_pk primary key, name varchar2 (255 char) not null, roll no number ) ; create table students ( id number generated by default on null as identity constraint students_id_pk primary key, name varchar2 (255 char), roll_no number ) ; An Invalid column definition error message will be displayed.
create table students ( id number generated by default on null as identity constraint students_id_pk primary key, name varchar2 (255 char) not null, roll no number ) ;
Examibe these statements: create table dept ( id number generated by default on null as identity constraint dept_id_pk primary key, name varchar2 (255 char) not null, age number ); create table emp ( id number generated by default on null as identity constraint emp_id_pk primary key, dept id number constraint emp_dept_id_fk references dept on delete cascade, name varchar2 (255 char) not null, email varchar2 (255 char) constraint emp_email_ung unique, position varchar2 (8 char) constraint emp_position_ck check (position in ('MANAGER', 'CLERK', 'ENGINEER')) ); Which Quick SQL code can generate these statements? dept name /nn age num emp name /nn email /unique position /check Manager, Clerk, Engineer dept name /nn age num emp name /nn email /unique position /check Manager, Clerk, Engineer dept name /nn age num emp name /nn email /unique position/check Manager, Clerk, Engineer dept name /nn age num emp name /nn email /unique position /values Manager, Clerk, Engineer
dept name /nn age num emp name /nn email /unique position/check Manager, Clerk, Engineer
You must generate a SQL insert statement for the DEPT table in Quick SQL. Which two statements will do that? dept name /insert 1 dept /insert name dept/insert 1 name dept /insert 1 name
dept/insert 1 name dept /insert 1 name
