Explanation Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data. Verified References: 34
Question 17
Choose from the following the different kinds of page components you can create in APEX.
Correct Answer: D
Explanation 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.
Question 18
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
Correct Answer: B,D
Explanation An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as: End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings. End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc. The other options are incorrect because: End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu. End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu. Verified References: [About Interactive Reports] [About Interactive Grids]
Question 19
An Employees App includes a form to enter and update employee details. Examine this Exhibit. Now you must extend the functionality of this form so that: * If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayed * If you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?
Correct Answer: C,E
Explanation To extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows: Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action. Set Name to Show/Hide Hire Date and Commission. Set Event to Change. Set Selection Type to Item(s). Set Item(s) to P2_JOB. Set Condition Type to Equal To. Set Value to SALESMAN. Add two true actions by clicking the Add True Action button twice. For the first true action, set Action to Show. Set Affected Elements > Selection Type to Item(s). Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM. For the second true action, set Action to Show. Set Fire On Initialization to Yes. Set Affected Elements > Selection Type to jQuery Selector. Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"]. Add two false actions by clicking the Add False Action button twice. For the first false action, set Action to Hide. Set Affected Elements > Selection Type to Item(s). Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM. For the second false action, set Action to Hide. Set Fire On Initialization to Yes. Set Affected Elements > Selection Type to jQuery Selector. Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"]. This dynamic action will show or hide both the page items and their labels depending on whether P2_JOB is equal to SALESMAN or not. Verified References: [Creating a Dynamic Action in Oracle Apex - OrclQA.Com], [Managing Dynamic Actions - Oracle Help Center]
Question 20
What three are the key features of Data Load Definition?
Correct Answer: A,C,D
Explanation Data Load Definition is a feature that enables developers to create pages with data loading capability. Users can upload files and load data into tables or collections. Some key features of Data Load Definition are: The APEX_DATA_LOADING PL/SQL API is available for custom processing. Developers can use this API to programmatically load data by calling an application data loading definition . Column mapping occurs at design time, removing the burden on end users. Developers can define SQL expressions, SQL queries, lookups, or transformation rules for each data profile column. Easy workflow for end users: upload the file, verify the preview, and load data. Users can follow a simple three-step process to load data from a file into a table or a collection. Data Load Definition does not support only XML data format. It also supports CSV, JSON, XLSX, and XML formats.