Online 1z0-770 Questions Video

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. The other statements are false because:
• A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.
• Multiple number of sessions can exist in the database at the same time for different users or applications. Verified References: [Understanding Session State Management - Oracle Help Center], [What Is a Session? - Oracle Help Center]

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.

Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the database. You can use Data Workshop to copy data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data. While migrating apps, once the database objects are created in the target environment, you can load the data using Data Workshop by following these steps:

• Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
• Click Load Data.
• Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or Object Store Reference (Autonomous Database only).
• Specify a file name or location for your data source.
• Select a table name for your data destination.
• Map your data columns to your table columns.
• Review your data load settings and click Load Data.