Free 1Z0-770 Exam Braindumps

Which statement is true about the Link Column attribute of an interactive report? A. A Link Column cannot be sorted, hidden, or moved by an end user. B. It is not possible to exclude Link Column. C. If you select Link Column, it is always displayed as the last column in the report. D. It is not possible to include a custom target in Link Column

Answer(s): A Explanation: A Link Column is a special column type that you can define for an interactive report to create a link to another page, URL, or custom target. A Link Column is always displayed as the first column in the report, regardless of the order of the columns in the query. A Link Column cannot be sorted, hidden, or moved by an end user using the Actions menu or the column header. However, a developer can change the position and visibility of a Link Column by editing the report attributes in Page Designer.

Which is a valid method of logging messages to the execution log in APEX automation? A. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.'); B. apex_automation.log_info('SAL for || :ENAME || increased by 18.'); C. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification ) ;

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

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. An interactive grid supports Pivot View and Group By View features. C. End users cannot rearrange columns by dragging and dropping.

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

Which statement is true about importing an APEX application? A. You cannot import an APEX application exported from a latest APEX version to an old APEX version. B. The import process does not import the supporting objects defined during the export. C. You cannot change the application ID during the import process.

Answer(s): A Explanation: As a general rule, you cannot import an application created in a newer release of APEX into an earlier version. This is because the newer release may have features or attributes that are not supported or recognized by the older version. For example, you cannot import an application created in APEX 21.2 into APEX 19.2. However, you can import an application created in an older release into a newer one, as long as the application is compatible with the newer release. For example, you can import an application created in APEX 18.2 into APEX 21.2, but you may need to upgrade or modify some components to use the latest features.

Which statement is true about the Data Workshop utility? A. The wizards load and unload table data only. B. You cannot load data from an XLSX file with multiple worksheets. C. The wizards load and unload all types of schema objects. D. You can load or unload multiple tables at a time.

Answer(s): A Explanation: Data Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards.

Which search type in Search Configurations provides linguistic and fuzzy search capabilities? A. Oracle Text B. Standard C. List

Answer(s): A Explanation: Search Configurations is a feature that allows developers to define how end users can search for data in an application. There are three types of search configurations: Standard, List, and Oracle Text. Oracle Text is a search type that provides linguistic and fuzzy search capabilities by using an Oracle Text index on a table column or view column. Linguistic search enables end users to search for data based on language-specific rules and preferences, such as stemming, stop words, synonyms, etc. Fuzzy search enables end users to search for data based on approximate matches that account for spelling errors, typos, OCR errors, etc.

Which statement is true about Unified Task List in the Approvals component? A. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox. B. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions. C. It is a shared component used to configure task parameters, participants, actions, and due dates.

Answer(s): A Explanation: The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users. The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page.

Which statement is true about creating and using a report with form? A. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination. B. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source). C. The Create Application Wizard doesn't support the creation of an interactive report and form combination. D. The Create Page Wizard doesn

Answer(s): A Explanation: You can create a report with form in Oracle APEX by using either the Create Application Wizard or the Create Page Wizard. The report can be either an interactive report or a classic report, and the form can be either a single row form or a multi row form. The report with form combination enables you to view and edit data from a table or a query in a single page. You can also customize the report and form attributes, such as the columns, regions, buttons, validations, processes, and so on.

Which two statements are true about Faceted Search pages? A. Faceted Search supports the ability to filter columns storing multiple values as one string. B. Facets map to specific database columns. C. Multiple charts are not visible in the same region. D. A facet's chart can be seen only in a nonmodal dialog.

Answer(s): A,B 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.

Which two statements are true about REST Data Source Synchronization? A. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema. B. 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. C. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work. D. You cannot trigger Data Synchroniza

Answer(s): A,B Explanation: REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects.

Which two statements are true about the APEX MAIL API? A. You can add files as attachments to your emails using the APEX_MAIL package. B. You can send emails using the APEX MAIL package from an Oracle APEX application. C. The APEX_MAIL package supports sending emails only to Oracle database users. D. You can receive emails using the APEX_MAIL package in an Oracle APEX application

Answer(s): A,B 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.

Which two statements are true about the Create Application Wizard? A. It allows application pages to be reordered. B. It allows application pages to be added or deleted. C. It allows the uploading of JavaScript or CSS files required for an application. D. It allows the application authorization to be changed

Answer(s): A,B Explanation: The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are: - Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them. Add or delete application pages. - You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. - You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the - Create Application Wizard. You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes.

Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX? A. On the remote Oracle Database, install ORDS 19.x or later. B. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA. C. Create a database link to the remote Oracle Database in the local APEX Schema. D. Install Oracle APEX in the remote Oracle Database.

Answer(s): A,B Explanation: The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are: On the remote Oracle Database, install ORDS 19.x or later. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA. Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX. Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature.

Which two feature pages can you create using the Create Page Wizard? A. Access Control B. Feedback C. Search Page D. Unified Task List

Answer(s): A,B Explanation: The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard.

Which two layout options are available for Page Designer under Utilities? A. Single Pane Mode B. Two Pane Mode C. Three Pane Mode D. Four Pane Mode

Answer(s): A,B - Alt ANSWER: B, C Explanation: Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options: Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts. Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout.

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 4 columns B. Creates an id column as a primary key C. Create the departments table with 3 columns D. Inserts 4 rows of random data into the departments table

Answer(s): A,B,D 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 id column 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.

You can create a report in which of the three following methods? A. Create a report as a new page in an application B. Create a report when you create a new database application C. Create a report from Object Browser D. Create a report region on a page in an application

Answer(s): A,B,D Explanation: You can create a report in any of these three methods: - Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons. - Create a report when you create a new database application by using the Create Application Wizard. This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view. - Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.

Which two statements are true about creating and using an interactive report? A. You can specify an Authorization Scheme at the column level. B. You cannot include Form Page when creating an interactive report page using the Create Page Wizard. C. You cannot customize the Search Button Label. D. You cannot restrict users from saving private reports by using the Authorization Scheme.

Answer(s): A,C

Which two among the following are TRUE about Low Code Apps? A. Scalable B. Not Mobile Friendly C. Provide Rich Functionality with Less Code D. Expensive

Answer(s): A,C 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.

Which two statements are true about the usage of a Remote Server in the context of REST Data Sources? A. The remote server determines the base URL of the REST Data Source. B. The remote server should mandatorily be an APEX instance. C. Multiple REST Data Sources can reference a single remote server. D. A single REST Data Source can use multiple remote servers.

Answer(s): A,C Explanation: A remote server in the context of REST Data Sources is a configuration that defines how to connect to an external server that hosts one or more REST services. The remote server determines the base URL of the REST Data Source, which is used to construct the full URL of each REST operation. Multiple REST Data Sources can reference a single remote server, which simplifies the maintenance and security of accessing external REST services.

Which two statements are true about creating and customizing Smart Filters pages? A. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. B. The search results report can be displayed as an interactive report. C. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. D. The search results report can be displayed as an interactive grid

Answer(s): A,C Explanation: Smart Filters is a component that allows end users to filter data by typing keywords in a single search field. Some of the statements that are true about creating and customizing Smart Filters pages are: If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar.

You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page? A. Assign roles to users B. Create Authorization schemes C. Add Users D. Create new application roles

Answer(s): A,C Explanation: 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.

Which two are valid evaluation points for Authorization Schemes? A. Never B. Once per session C. Once per page view D. Once per user

Answer(s): A,C - ALT: B, C Explanation: An authorization scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authorization scheme can be evaluated at different points in time depending on its evaluation point attribute. The valid evaluation points for authorization schemes are: Never: The authorization scheme is never evaluated and always returns false. Once per session: The authorization scheme is evaluated only once per user session and caches the result for subsequent requests. Once per page view: The authorization scheme is evaluated once per page view and caches the result for subsequent requests within the same page view. On each new page view or partial page refresh: The authorization scheme is evaluated on each new page view or partial page refresh (for example, when using dynamic actions) and caches the result until the next page view or partial page refresh.

Which three of the following options are TRUE about a page in an APEX application? A. A page can contain buttons, page items and regions. B. An APEX application can have only one page. C. To view the rendered version of the page, you run or submit it to the Oracle APEX engine. D. A page can be viewed and edited in the Page Designer.

Answer(s): A,C,D

Using the App Builder component, you can perform which three tasks? A. Edit pages in the page designer B. Run SQL scripts and commands C. Install a sample App D. Create a new App

Answer(s): A,C,D Explanation: - Using the App Builder component, you can perform the following tasks: Edit pages in the page designer: You can use the Page Designer tool to modify the pages in your application using drag-and-drop operations, property editors, and code editors. You can also preview how your pages will look on different devices. - Install a sample app: You can use the Gallery option to install a sample app from a list of pre-built applications that demonstrate various features and best practices of Oracle APEX. You can also use the Packaged Apps option to install a packaged app from a list of ready-to-use applications that provide common functionality and solutions. - Create a new app: You can use the Create App option to create a new app from scratch or from an existing data source using the Create Application Wizard. You can also use the From a File option to create a new app from a file that contains data or metadata.

Choose the three correct options in the given friendly URL syntax: https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 A. Ahr-app is the application alias. B. update-employees is the PL/SQL procedure to update the employee details. C. mycompany is the path-prefix which is by default the workspace name D. 13766599855150 is the session I A new ID is generated for each session.

Answer(s): A,C,D Explanation: The friendly URL syntax https://example.com:5500/ords/r/mycompany/hr- app/updateemployees?session=13766599855150 has the following components: - session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request. hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID. - mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID. - updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.

Which three are the main components of APEX workspace homepage? A. Gallery B. RESTful Services C. SQL Workshop D. App Builder

Answer(s): A,C,D 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.

Choose the two correct statements about PWA. A. Provides a customizable offline page when users are offline and cannot request the network. B. To download the app as PWA, one must visit the App Store C. An existing APEX app cannot be made a PWA D. Enables users to install the application on devices

Answer(s): A,D

Which two Plugin types can be created in Oracle APEX? A. Process B. Validation C. Email Template D. Region

Answer(s): A,D Explanation: A plugin is a component that extends the native functionality of Oracle APEX by allowing developers to create custom components using SQL, PL/SQL, HTML, CSS, and JavaScript. A plugin can be created for any of the following component types: Dynamic Action, Item, Process, Region, Report Layout, Authentication Scheme, Authorization Scheme, or Data Load Method. A process plugin is a custom process type that can be executed when a page is submitted or loaded. A region plugin is a custom region type that can display data or content on a page.

Which two actions can you perform using the Object Browser? A. Browse database objects of the current schema. B. Restore dropped database objects. C. Create and run SQL scripts. D. Create a lookup table based on a column in the current table. E. Export and import SQL scripts.

Answer(s): A,D Explanation: Object Browser is a utility in SQL Workshop that enables developers to browse, create, and edit objects in a database. Some of the actions that you can perform using Object Browser are: - Browse database objects of the current schema. You can view the details of an object by selecting it from the Object Tree and then clicking the different object detail tabs. -Create a lookup table based on a column in the current table. You can use the Create Lookup Table option in the Column Details tab to create a new table that stores the distinct values of the selected column and a foreign key constraint to reference it. You cannot restore dropped database objects, create and run SQL scripts, or export and import SQL scripts using Object Browser. You can use other utilities in SQL Workshop to perform these actions, such as Recycle Bin, SQL Commands, and SQL Scripts.

Which two functions can be used by an end user when pivoting an interactive report? A. Minimum B. list aggregate C. Median D. List aggregate E. Rank

Answer(s): A,E Explanation: When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values.

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? A. Join me in congratulating :P1 ENAME as the new employee of the month! B. Join me in congratulating &P1 ENAME, as the new employee of the month! C. Join me in congratulating v('P1_ENAME') as the new employee of the month!

Answer(s): B Explanation: A Static Content region type is used to display static text or HTML content on a page. To display messages about the employees of the month, you can use a Static Content region type with substitution variables that reference page items. Substitution variables are enclosed in ampersands (&) and can be used to dynamically replace text with values from page items or application items. The correct text to display the message is "Join me in congratulating &P1_ENAME, as the new employee of the month!" The other options are incorrect because they use either colons (:) or v() function, which are not valid ways to reference page items in Static Content regions.

When a button is pressed, an overlay window is positioned within the viewport. What kind of page mode is it? A. Help Page B. Modal Dialog C. Normal Page D. Non-Modal Dialog

Answer(s): B 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.

There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area? A. Setting the value Required to Yes on P1_SALARY B. Removing P1_SALARY from the validation Associated Item C. Setting Display Location to Inline in Notification

Answer(s): B Explanation: A validation is a rule that checks the data entered by end users before processing it. A validation of type Item is numeric checks if a page item value is a valid number. When the page is submitted, if the validation fails, an error message is displayed both in the notification area (at the top of the page) and below the item (next to the item label). To cause the validation error to appear only in the notification area, you need to remove P1_SALARY from the validation Associated Item attribute. The Associated Item attribute specifies which page item is associated with the validation and where to display the error message if the validation fails. Setting the value Required to Yes on P1_SALARY or setting Display Location to Inline in Notification will not affect the validation error display.

Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards? A. HTTP Header Variable B. Social Sign-In C. SAML Sign-In D. Open Door Credentials

Answer(s): B Explanation: An authentication scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authentication scheme type defines how users are authenticated when they access an application. The authentication scheme type that supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards is Social Sign-In. Social Sign-In supports authentication with Google, Facebook, and other social networks that support these standards. The other authentication scheme types do not support authentication with social networks or enterprise identity providers. They are: - HTTP Header Variable: Authenticate users externally by storing the username in a HTTP Header variable set by the web server. - SAML Sign-In: Delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.

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? A. Master Detail B. Cards C. Interactive Grid D. Unified Task List

Answer(s): B Explanation: Cards are a page type that display information in a grid layout of tiles. Each card can contain an image, a title, a subtitle, and an optional link. Cards are suitable for presenting summary or overview information in an attractive and compact way

Which component in SQL Workshop allows you to build queries graphically without manual SQL coding? A. Quick SQL B. Query Builder C. SQL commands D. Data Workshop

Answer(s): B 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 and groupings, 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.

Which statement is true about session state management in Oracle APEX? A. A user cannot run multiple instances of an application simultaneously in different browser programs. B. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. C. Multiple number of sessions cannot exist in the database at the same time

Answer(s): B Explanation: Session state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is: - APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process.

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 default to TRUE. D. It will restrict acceptable values to Y or N.

Answer(s): B 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.

Which is NOT a valid Geometry Column Data Type available for maps region? A. Latitude/Longitude B. JSON_OBJECT C. GeoJSON D. SDO_GEOMETRY

Answer(s): B Explanation: The valid Geometry Column Data Types for maps region are Latitude/Longitude, GeoJSON, and SDO_GEOMETRY. These types represent different ways of storing spatial data in Oracle Database. Latitude/Longitude uses two numeric columns for longitude and latitude values. GeoJSON uses a VARCHAR2 or CLOB column that contains geometry information in GeoJSON format. SDO_GEOMETRY uses an object type that stores spatial data using Oracle Spatial features. JSON_OBJECT is not a valid Geometry Column Data Type for maps region.

Which statement is true about Theme Styles in Oracle APEX? A. Theme Styles in Oracle APEX determine the layout and structure of a webpage. B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment. C. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.

Answer(s): B Explanation: Theme Styles in Oracle APEX are CSS style sheets that are added to the base CSS of a theme to alter the look and feel of an application. A theme can have multiple theme styles with one style set as current. When the Is Public attribute is enabled for a theme style, end users can choose the theme style from the runtime environment by using the Theme Style Switcher component. This allows end users to customize the appearance of the application according to their preferences.

Which is a valid Page Process type? A. Execute JavaScript Code B. Set Value C. Send E-Mail

Answer(s): B - Alt ANSWER: C Explanation: A page process type defines what action the page process performs when it is executed. There are many page process types available in Oracle APEX, such as Execute PL/SQL Code, Data Loading, Branch, etc. One of the valid page process types is Set Value. The Set Value page process type sets session state for an item or items on a page using a computation or PL/SQL expression. You can use this page process type to assign values to items based on logic or conditions. The other options are not valid page process types. Execute JavaScript Code is a dynamic action type, not a page process type. Send E-Mail is an application process type, not a page process type.

Which two statements are true about a Progressive Web Application (PWA)? A. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off. B. Enabling the PWA functionality optimizes page loading speed on a mobile device. C. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app. D. PWA features will be rendered even if the application is served in an unsecured environment. E. You ca

Answer(s): B,C Explanation: A Progressive Web Application (PWA) is a web application that uses modern web technologies and best practices to provide a native app-like experience to users. Enabling the PWA functionality in your APEX app has the following benefits: - It optimizes page loading speed on a mobile device by caching static resources and using service workers to handle network requests. - It adds a new navigation bar entry named Install App to your app, which allows users to install the app on their device's home screen and access it offline. - It enhances the app's appearance and behavior by using a manifest file to specify the app's name, icon, theme color, orientation, and display mode.

Which two statements are true about creating and managing an APEX Workspace? A. New schemas cannot be created during workspace creation. B. During workspace creation, you can associate the workspace with an existing database schema. C. A workspace enables multiple users to work within the same Oracle APEX installation. D. A workspace can be associated with only one schema. E. You can create only two workspaces in an APEX Service (APEX Application Development) instance.

Answer(s): B,C 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 workspace

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. Date Picker B. Range C. Checkbox Group D. Popup LOV

Answer(s): B,C 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.

Which two Query Source types can be used to create a dynamic Navigation Bar List? A. Select List B. SQL Query C. Function Returning SQL Query D. Procedure

Answer(s): B,C Explanation: The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List.

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? A. In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes. B. In Page Designer, use the Middle Pane, click P21 UNIT PRICE

Answer(s): B,C Explanation: To reposition the page items and display P21_UNIT_PRICE next to P21_PRODUCT_NAME, you can use either of these methods: In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and drag the item until it is directly next to P21_PRODUCT_NAME. This method allows you to visually arrange the items on the page layout. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes. This method changes the attribute of the item to start a new row in the grid layout. The other options, A and D, are incorrect because they would not achieve the desired result. Setting Start New Row to Yes for P21_PRODUCT_NAME would move it to a new row, not next to P21_UNIT_PRICE. Right-clicking P21_UNIT_PRICE and selecting Start New Row would not change the attribute of the item, but only move it to a new position in the Layout tab.

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(s): B,C 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.

Using Data Workshop, you can perform which three tasks: A. Delete data from the database B. Load vast amount of data into the database C. Export vast amount of data from the database into a file D. Load data using various file formats such as XLSX, CSV, XML, and JSON

Answer(s): B,C,D Explanation: Using Data Workshop, you can perform the following tasks: - Load vast amount of data into the database: You can use the Data Load option to load data from various file formats such as XLSX, CSV, XML, and JSON into a table or a collection in your database. You can also use the Data Load Wizard to guide you through the steps of loading data. - Export vast amount of data from the database into a file: You can use the Data Unload option to export data from a table or a collection in your database into a file in CSV or JSON format. You can also use the Data Unload Wizard to guide you through the steps of exporting data. - Load data using various file formats such as XLSX, CSV, XML, and JSON: You can use the Data Load option to load data from different file formats into your database. You can choose the file format from a list of supported formats or let Oracle APEX detect it automatically.

Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked? A. Setting the on Data Change attribute value to slide to Left B. Setting the Hide and Show Behavior attribute value to Rescale C. Setting the Hide and Show Behavior attribute value to None D. Setting the Hide and Show Behavior attribute value to No Rescaling

Answer(s): B,D Explanation: A bar chart is a type of chart that displays data as horizontal or vertical bars with lengths proportional to the values they represent. A bar chart can have one or more data series, which are groups of data points that share the same color and legend item. To enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked, you need to set the Hide and Show Behavior attribute value to either Rescale or No Rescaling. The Hide and Show Behavior attribute determines how the chart behaves when a data series is hidden or shown by clicking on its legend item. The possible values are: - None: The chart does not support hiding or showing data series by clicking on legend items. Rescale: The chart supports hiding or showing data series by clicking on legend items, and rescales the axes accordingly. - No Rescaling: The chart supports hiding or showing data series by clicking on legend items, but does not rescale the axes.

Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid? A. End user can rearrange the report interactively using the mouse. B. End user can add, modify, and refresh data directly on the report. C. End user can save the report D. End user can customize how and what data is displayed.

Answer(s): B,D 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.

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? A. Set EMPNO, ENAME to "Display Only". B. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. C. In the Interactive Grid attributes, select COMM for "Allowed Row Operat

Answer(s): B,D Explanation: An interactive grid is a customizable report that allows end users to modify the data and layout of the report. To make an employee's commission editable in the grid, you need to perform two actions: In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. This enables editing for the entire interactive grid region and allows you to specify which columns are editable and which are not. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. This identifies the EMPNO column as the primary key for the EMP table and allows APEX to perform DML operations on the table when end users edit the data in the grid. You do not need to set EMPNO or ENAME to "Display Only" or select COMM for "Allowed Row Operations Column" to make an employee's commission editable in the grid.

From SQL Workshop, you can perform which two of the following actions? A. Create an APEX user B. Run SQL commands and scripts C. Delete database D. Create and view database objects

Answer(s): B,D 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.

Which two are true about Oracle APEX? A. Performs the data processing in a middle-tier server B. Requires no additional client software. A web browser is the app development IDE. C. Requires developers to be proficient in Java, Python and other programming languages. D. Is declarative. It requires no code generation.

Answer(s): B,D 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.

Which two statements are true about loading data from the "Create an Application From a File" wizard? A. Seed data from a SQL script can be uploaded. B. A sample data set from the sample list can be uploaded. C. XML and JSON data can be pasted and loaded. D. CSV, XLSX, XML, TXT, or JSON files can be uploaded. E. Data from remote web services can be uploaded.

Answer(s): B,D Explanation: The "Create an Application From a File" wizard is a tool that allows developers to create an application based on an existing spreadsheet file or sample data set. Some of the statements that are true about loading data from this wizard are: A sample data set from the sample list can be uploaded. You can use the Sample Data Sets option to select a predefined data set from a list of available samples, such as Employees, Products, Projects, etc. CSV, XLSX, XML, TXT, or JSON files can be uploaded. You can use the Upload a File option to upload a spreadsheet file in one of these formats and create an application based on its data. You cannot upload seed data from a SQL script, paste and load XML and JSON data, or upload data from remote web services using this wizard. You can use other features in App Builder or SQL Workshop to perform these actions, such as SQL Scripts, RESTful Services, etc.

The Page Designer Toolbar allows you to perform which two of the following actions? A. Delete the application B. Navigate to Shared Components C. Export the application D. Create a new page

Answer(s): B,D Explanation: The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are: - Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar. - Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.

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? A. GET B. POST C. PUT

Answer(s): C Explanation: A REST Data Source with ORDS as the REST Data Source Type is based on an AutoREST-enabled table or view on a remote Oracle Database. AutoREST enables you to perform CRUD (Create, Read, Update, Delete) operations on a table or view using standard HTTP methods. When a user updates an employee record in an editable interactive grid that uses this REST Data Source as source, the PUT operation defined in the REST Data Source is utilized to update a record in the EMP table on the remote Oracle Database. The PUT operation sends an HTTP PUT request to the REST endpoint with the primary key value of the record and the updated column values in JSON format.

Which statement is true about creating and using a faceted search page? A. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered. B. If you create a faceted search page based on a table, the facets are not auto-discovered. C. The Search Results region can be displayed as a Classic Report or Cards. D. The Search Results region can be displayed as an interactive report.

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

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(s): C 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.

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? A. Refreshing the templates B. Verifying the theme subscription C. Subscribing the copied theme to the master theme and refreshing the theme D. Copying the changes made in the master theme to the copi

Answer(s): C Explanation: A theme is a collection of templates and stylesheets that define the layout and appearance of an application. You can create a custom theme for an application by using the Create Theme Wizard or by copying an existing theme. If you want to use a custom theme for another application in the same workspace, you can copy the theme to that application by using the Copy Theme option in Shared Components. However, if the master theme (the original theme) may still require changes, you need to subscribe the copied theme to the master theme and refresh the theme whenever there are changes in the master theme. This solution guarantees that any changes to the master theme are reflected in the copied theme by using a synchronization process that updates templates and stylesheets based on their subscription status.

Which client credentials are utilized for authentication during the One-Click Remote Application Deployment process? A. Database schema credentials B. PEX Developer credentials C. APEX Workspace Admin credentials

Answer(s): C Explanation: The One-Click Remote Application Deployment feature in Oracle APEX enables developers to deploy an application along with supporting object definitions to another workspace or to remote Oracle APEX instances. To use this feature, you need to provide the client credentials for authentication during the deployment process. The client credentials are utilized for authentication during the One- Click Remote Application Deployment process are the APEX Workspace Admin credentials. You can either specify an existing credential or create a new credential when you create a REST Enabled SQL reference in Shared Components. Optionally, you can create the credentials as empty credentials to prompt for client ID and client secret each time the REST Enabled SQL reference is used.

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? A. An Invalid column definition error message will be displayed. B. 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); C. create table students (id number generated by default on null as identity constraint students_id_pk prim

Answer(s): C Explanation: 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 ); The commission_yn column will default to `N' because of the default clause in the column definition. It will also restrict acceptable values to `Y' or `N' because of the check constraint. The other options are incorrect because they do not match the output of Quick SQL.

I want to hide a few columns in my interactive report. To do so, which option should I choose from the Actions menu? A. Filter B. Data C. columns D. Format

Answer(s): C 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.

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. Interactive Report B. Column Toggle Report D. Classic Report E. Interactive Grid

Answer(s): C 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.

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? A. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE# B. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE C. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE D. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#

Answer(s): C Explanation: d event under the Drag and Drop PL/SQL Code attribute of the Calendar component. This attribute allows you to write PL/SQL code to update the event row in the database after the user drags and drops an event on the calendar. To reference the ID, the new start date, and the new end date of the dragged event, you can use these bind variables: :APEX.PK_VALUE, :APEX.NEW_START_DATE and :APEX.NEW_END_DATE. These variables are automatically populated by APEX when the user performs a drag and drop action on the calendar. For example, you can write something like this: UPDATE events SET start_date = APEX.NEW_START_DATE, end_date = :APEX.NEW_END_DATE WHERE id = :APEX.PK_VALUE;

Which two types of pages behave similarly in functionality? A. Map B. Cards C. Faceted Search D. Smart Filter

Answer(s): C,D Explanation: - A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects: - A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart. - A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.

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. Import previously exported apps. D. Create and manage apps. E. Create and manage database objects.

Answer(s): C,D 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.

Which two statements are true about creating and using dynamic actions? A. Once you create a dynamic action, you cannot add additional true actions. B. If no client-side condition is defined, true actions will not fire. C. You can execute JavaScript code by creating a dynamic action. D. 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

Answer(s): C,D Explanation: 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.

In a Classic Report, an end user can perform which two of the following actions? A. Create Control Breaks in the report B. Rearrange the columns in the report C. Filter values of a column in the report D. Sort the columns of the report

Answer(s): C,D 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.

An Employees App includes a form to enter and update employee details. Examine this Exhibit. Now you must extend the functionality of this form so that:· 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 a

Answer(s): C,E Explanation: To extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows: Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action. Set Name to Show/Hide Hire Date and Commission. Set Event to Change. Set Selection Type to Item(s).Set Item(s) to P2_JOB.Set Condition Type to Equal To. Set Value to SALESMAN. Add two true actions by clicking the Add True Action button twice. For the first true action, set Action to Show. Set Affected Elements > Selection Type to Item(s).Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.For the second true action, set Action to Show. Set Fire On Initialization to Yes. Set Affected Elements > Selection Type to jQuery Selector. Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].

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

Answer(s): D 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.

Choose from the following the different kinds of page components you can create in APEX. A. Search Page B. Faceted Search C. Interactive Grid D. All of them E. Smart Filters

Answer(s): D Explanation: All of the options listed are different kinds of page components that you can create in APEX. A page component is an area of a page that serves as a container for content. Each page component contains a different type of content, such as HTML, a report, a form, a chart, a list, a breadcrumb, PL/SQL, a tree, a URL, or a calendar. You can create page components by using the Create Page Wizard, dragging and dropping from the Gallery pane in Page Designer, or using the context-sensitive menu in the Rendering tree in Page Designer.

Which statement is true about using SQL Commands? A. You can search and filter database objects. B. You can design and prototype data models using a markdown-like shorthand syntax. C. In SQL Commands, you can view queries saved in Query Builder. D. You can unload data from the database.

Answer(s): D Explanation: Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data.

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 Primary only B. As Public only C. As Private only D. As Private and public only

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

Which two statements are true about Oracle APEX? A. Application definition is not stored in the database. B. Processing and data manipulation is not executed in the database. C. Running an APEX app needs client software. D. APEX eliminates middle-tier application logic. E. You can build interactive reporting apps based on data from disparate systems

Answer(s): D,E Explanation: Oracle APEX is a low-code application development platform that enables developers to build scalable, secure, and data-driven web and mobile apps. Some of the statements that are true about Oracle APEX are: APEX eliminates middle-tier application logic. APEX runs entirely within Oracle Database and does not require any additional middleware or application server to function. This simplifies the architecture and reduces the complexity, cost, and security risks of deploying applications. You can build interactive reporting apps based on data from disparate systems. APEX supports various data sources, such as local database, REST Enabled SQL Service, REST Data Source, Web Source Module, etc. You can use these data sources to create interactive reports that allow end users to filter, sort, search, aggregate, and visualize data from different sources.

You can create an APEX workspace and build APEX apps on which of the following platforms? A. Oracle Autonomous Cloud B. Oracle XE C. Amazon RDS D. Microsoft Azure E. All of the above

Answer(s): E 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 Microso