Choose the three requirements for creating a REST Enabled SQL Reference.
Correct Answer: A,B,D
Explanation To create a REST Enabled SQL Reference, you need to meet the following requirements: Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1. Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2. Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3. You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.
Question 7
Which two statements are true about Oracle APEX?
Correct Answer: 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. The other statements are false because: Application definition is stored in the database. APEX stores the metadata of the application components, such as pages, regions, items, buttons, etc., in the database tables. Processing and data manipulation is executed in the database. APEX leverages the power and performance of Oracle Database to process and manipulate data using SQL and PL/SQL. Running an APEX app does not need client software. APEX apps are web-based and can be accessed from any browser on any device without installing any client software. Verified References: [Oracle Application Express (APEX) - Oracle Help Center], [Platform - Oracle APEX]
Question 8
Select the three types of Card Layout you can create in APEX.
Correct Answer: B,C,D
Explanation You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
Question 9
Which three of the following statements are TRUE about saved Public Interactive Grids?
Correct Answer: A,B,D
Explanation Public reports are available to all users who can access the interactive grid1. However, to enable an end user to save a public interactive grid report, the user must have the required permission. By default, only developers can save public reports1. Any user may save private interactive grid reports, but only the user who creates a private report can view, save, rename, or delete it12. Verified References: 12
Question 10
When you run an application, the APEX engine relies on which two processes?
Correct Answer: A,D
Explanation When you run an application, the APEX engine relies on two processes: Show Page and Accept Page. Show Page is responsible for rendering the page and sending it to the browser. Accept Page is responsible for processing the page when it is submitted by the browser. Run Page is not a process, but a command that can be used to run an application or a page from SQLWorkshop or Application Builder. Validate Page is not a process, but a step that occurs during page processing to check for any validations defined on the page
