Total Pageviews

Showing posts with label Oracle Apex : Interview Question. Show all posts
Showing posts with label Oracle Apex : Interview Question. Show all posts

Saturday, 24 June 2023

Oracle APEX : Interview Question

 Oracle APEX : Interview Question


1.Session state in APEX?
Ans: A Session state enables programmer to store and retrieve values for a user as the user navigates between different application pages.


2.Session state protection used for in APEX?
Ans:This is a built-in functionality that prevents hackers from tampering with the URLs within your application.

3.What is Session ID?
Ans:A session ID is a unique number assigned a specific user for the duration of that user's visit.

4.Session?
Ans: A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier. The Application Express engine uses this identifier (or session ID) to store and retrieve an application's working set of data (or session state) before and after each page view.

5.What is Authorization Scheme and its types?

6. Difference between Page Items,Application Items and Global Page Items

Page Items: This item create in the Page Level. 
Application Items: This Items that are created at Application Level.
Global Page Items: This Global page of your application functions as a master page. You can add a separate Global page for each user interface. The Application Express engine renders all components you add to a Global page on every page within your application. 


***********************************************************************************
#Oracle apex #Apex #Interview Question

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...