ERASED TEST, YOU MAY BE INTERESTED ON APEX - part1
COMMENTS |
STATISTICS |
RECORDS
|
|---|
TAKE THE TEST
|
Title of test:
APEX - part1 Description: APEX Professional - Part1 Author: Eu Other tests from this author Creation Date: 23/12/2024 Category: Computers Number of questions: 58 |
Share the Test:
New Comment
 blue01 ( uploaded 30 days ) also please share part 2 also as this part doesn't cover all q/a |
| blue01 ( uploaded 30 days ) please share exam code |
Content:
|
Which statement is true about the Link Column attribute of an interactive report? A Link Column cannot be sorted, hidden, or moved by an end user. It is not possible to include a custom target in Link Column It is not possible to exclude Link Column. If you select Link Column, it is always displayed as the last column in the report. . Choose the three requirements for creating a REST Enabled SQL Reference. Configure and enable the REST Enabled SQL service feature Activate REST Enabled SQL for the target schema on the remote database Set up any remote database Install Oracle REST Data Services (ORDS) 19.x or later. . Choose the two statements that are TRUE about the Universal Theme in APEX. Not designed to work on tablets The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. Responsive UI Easy customization . 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? Drill Up Drill Down Stacked Side by Side . Which statement is true about creating and using an interactive grid? 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. End users cannot rearrange columns by dragging and dropping. . Which two are true when the Edit option is NOT enabled for an Interactive Grid? The end user cannot create charts The end user cannot edit the underlying data in the database The end user can customize the report The end user can edit the underlying data in the database . In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is 'Salesman'. This can be achieved by which feature of APEX? Dynamic Actions Processing Conditional SQL PL/SQL procedure. Which two processes take place when the APEX engine runs Accept Page? Show page Navigation to different pages Computations and validations Save submitted values. What are the three key features of Universal Theme? Easy Customization Responsive Design Support for single theme Versatile UI Components . Which two are true about Oracle APEX? Performs the data processing in a middle-tier server Requires no additional client software. A web browser is the app development IDE. Requires developers to be proficient in Java, Python and other programming languages. Is declarative. It requires no code generation. . While migrating apps, once the database objects are created in the target environment, you can load the data using which of the components? Data Generator Data Workshop App Builder Quick SQL. Which search type in Search Configurations provides linguistic and fuzzy search capabilities? Standard Oracle Text List Oracle Popup. Which three statements are TRUE about Search Configuration? Search Configuration is a shared component defines the data source to be searched and the way results should be displayed. One or more Search Configurations can be configured in a Search Page. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources. Only one Search Configuration can be used in a Search Page. By default, which interactive grid report type can be created by an end user? Primary report Public report Private report Alternative report . Which statement is true about session state management in Oracle APEX? Multiple number of sessions cannot exist in the database at the same time APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. A user cannot run multiple instances of an application simultaneously in different browser programs. . Choose the two options provided in a Column Heading menu of an Interactive Report. Group By Hide Control Break Delete. Which two self-service tools are available with Autonomous Database? Low-Code App Dev, APEX Encryption only in Object Storage Oracle Machine Learning Encryption only in Object Storage . What are the required fields while creating a Chart in APEX? All of them Value Column Data Source Label Column Name. Which two statements are true about a Progressive Web Application (PWA)? 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. PWA features will be rendered even if the application is served in an unsecured environment. 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. . What three components must be considered while migrating an APEX app between environments? Move the images Move the application definition and all associated files Move the database objects Move the sessions data . The APEX engine uses which component as a key for tracking each user's session state? LDAP_USER APP_USER HTTP_USER APEX_USER. You want to create a search configuration in Shared Components. Which search type is supported? Navigation Menu Build Options List. You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page? Create new application roles Create Authorization schemes Add Users Assign roles to users . Which three of the following options are TRUE about a page in an APEX application? An APEX application can have only one page. To view the rendered version of the page, you run or submit it to the Oracle APEX engine. A page can contain buttons, page items and regions. A page can be viewed and edited in the Page Designer. . Plug-ins can be used declaratively in which of the following components in APEX? All of them Regions Process Type Dynamic Actions . Which statement is true about page components? Pages require one of each component. Regions contain pages and items. Items can be regions on a page. Pages contain user interface elements. . Which is a standard for exchanging authentication and authorization information between different security domains, to provide cross-organization single sign-on? Security Assertion Markup Language (SAML) Sign-on System OpenID Virtual Private Database (VPD) . Which two tasks can you perform using Quick SQL? Import an application. Export an application. Quickly develop a script for simple tables and views. Compare schemas. Easily generate random data. . Which statement is true about using SQL Commands? You can search and filter database objects. In SQL Commands, you can view queries saved in Query Builder. You can unload data from the database. You can design and prototype data models using a markdown-like shorthand syntax. . Which two statements are true about REST Data Sources? A REST Data Source can contain one or many Operations, which are the references to a concrete external web service. REST Data Sources doesn't support any authentication Oracle APEX doesn't provide direct integration of REST Data Sources in interactive reports. Oracle APEX supports the REST Enabled SQL Query REST Data Source type . 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 restrict acceptable values to TRUE or FALSE. It will default to TRUE. It will restrict acceptable values to Y or N. It will default to FALSE. . I want to hide a few columns in my interactive report. To do so, which option should I choose from the Actions menu? Filter Data Format columns. Choose the two correct statements about PWA. Provides a customizable offline page when users are offline and cannot request the network. Enables users to install the application on devices To download the app as PWA, one must visit the App Store An exisitng APEX app cannot be made a PWA . 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 . Which two are true about Oracle APEX? Performs the data processing in a middle-tier server Requires no additional client software. A web browser is the app development IDE. Is declarative. It requires no code generation. Requires developers to be proficient in Java, Python and other programming languages. Select two features of a Smart Filters Page. Each filter represents the text entered by the end user in the search field Consists of filters at the left side and report on the right side of the page Each filter displays as a suggestion chip with a single count of how often the specific suggestion value occurs. Consists of a single search field with filters at the top of the page and a report at the bottom . Choose the two statements that are TRUE about the Universal Theme in APEX. The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. Not designed to work on tablets Not designed to work on tablets Responsive UI . When a button is pressed, an overlay window is positioned within the viewport. What kind of page mode is it? Non-Modal Dialog Normal Page Modal Dialog Help Page . 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. Which two Query Source types can be used to create a dynamic Navigation Bar List? Function Returning SQL Query Procedure SQL Query Select List . Which two statements are true about the usage of a Remote Server in the context of REST Data Sources? Multiple REST Data Sources can reference a single remote server. A single REST Data Source can use multiple remote servers. The remote server determines the base URL of the REST Data Source. The remote server should mandatorily be an APEX instance. . Which component in SQL Workshop allows you to build queries graphically without manual SQL coding? Query Builder Quick SQL SQL commands Data Workshop. Which two actions can you perform using the Object Browser? Create and run SQL scripts. Restore dropped database objects. Create a lookup table based on a column in the current table. Browse database objects of the current schema. Export and import SQL scripts. 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 on a view or a SQL query, the facets are auto-discovered. The Search Results region can be displayed as an interactive report. If you create a faceted search page based on a table, the facets are not auto-discovered. . Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid End user can customize how and what data is displayed. End user can save the report End user can add, modify, and refresh data directly on the report. End user can customize how and what data is displayed. End user can rearrange the report interactively using the mouse. . 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 notificatio Setting the value Required to Yes on P1_SALARY. Add JavaScript to the item Removing P1_SALARY from the validation associated Item . When you run an application, the APEX engine relies on which two processes? Show Page Accept page Run Page Validate Page . Which three of the following statements are TRUE about Data Synchronization? APEX can create the local table based on the visible columns in the REST Data Source Data Profile. Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service. Helps in Providing efficient reporting on large data sets coming from a REST service You must trigger Data Synchronization manually. Which two statements are true about low code application development with Oracle APEX? The application definition is not stored in the database. Application development IDE is a web browser. Using APEX, you can build mission-critical enterprise apps. Apps cannot natively access Oracle Database capabilities. Data processing is not done in the database. Which two statements are true about a Faceted Search page? Show search results as cards or a classic report. Includes the ability to rearrange the report interactively using the mouse or keyboard. Includes a search field at the top of the page with filters that display as suggestion chips. Allows to toggle between a bar chart and a pie chart type . I want to hide a few columns in my interactive report. To do so, which option should I choose from the Actions menu? Columns Filters Data Format. Which client credentials are utilized for authentication during the One-Click Remote Application Deployment process? APEX Workspace Admin credentials Database schema credentials APEX Developer credentials . 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 Range Popup LOV. The Page Designer Toolbar allows you to perform which two of the following actions? Export the application Delete the application Create a new page Navigate to Shared Components. Which three of the following statements are TRUE about saved Public Interactive Grids? Public reports are available to all users Any user may save public interactive grids To enable an end user to save a public interactive grid, the user must have the required permission Only the user who creates a public interactive grid can save, rename, or delete it . Identify the two different categories of dynamic action event Brower Events. Role events Componet Events. User Events . Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called? Breadcrumbs Navigation Menu Navigation Bar List Lists. You can create an APEX workspace and build APEX apps on which of the following platforms? Microsoft Azure Oracle XE All of the above Amazon RDS Oracle Autonomous Cloud . |
Report abuse