Which two statements are true about Maps in Oracle APEX?
Correct Answer: A,D
Explanation A map is a type of component that enables you to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST Data Source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Two of the statements that are true about maps in Oracle APEX are: Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps. Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.
Question 7
In a Classic Report, an end user can perform which two of the following actions?
Correct Answer: 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. The other options are incorrect because: Create Control Breaks in the report is not an action that an end user can perform in a Classic Report. This action is only available in an Interactive Report by using the Control Break option in the Actions menu. Rearrange the columns in the report is not an action that an end user can perform in a Classic Report. This action is only available in an Interactive Grid by using the Reorder option in the Actions menu. Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]
Question 8
Which two tasks can you perform using App Builder?
Correct Answer: 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. Verified References: [Using App Builder - Oracle Help Center], [App Builder Concepts - Oracle Help Center]
Question 9
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
Correct Answer: 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. Verified References: [Understanding One-Click Remote Application Deployment - Oracle Help Center], [Remote Deployment of your APEX App is just One Click Away! - Oracle Blogs]
Question 10
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?
Correct Answer: 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. Verified References: Positioning Page ItemsLayout Tab
