In your APEX application, you want to have an orderly grid layout of information tiles. Which page
type should you choose in the Create Page Wizard?
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?
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]
Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?
From SQL Workshop, you can perform which two of the following actions?
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]
