Tópicos do Exame 1Z0-048
Introduction to Oracle Forms Developer and Oracle Forms Services |
|
| [ ] | Describe the components of Oracle9i Developer Suite and the Oracle9i Application Server |
| [ ] | Describe the features and benefits of Oracle Forms Services and Oracle Forms Developer |
| [ ] | Describe the architecture of Oracle Forms Services |
| [ ] | Describe Forms Builder components |
| [ ] | Navigate the Forms Builder interface |
| [ ] | Customize the Forms Builder session |
| [ ] | Use the online help facilities |
Running a Forms Developer Application |
|
| [ ] | Describe the run-time environment |
| __ | Explain the role of each |
| __ | Modify Forms environment variables |
| __ | Describe the appearance of a form at run time |
| [ ] | Navigate a Forms application |
| [ ] | Retrieve both restricted and unrestricted data |
| [ ] | Describe the two modes of operation |
| [ ] | Insert, update, and delete records |
| [ ] | Display database errors |
Creating LOVs and Editors |
|
| [ ] | Describe LOVs and editors |
| [ ] | Design, create, and associate LOVs with text items in a form module |
| __ | Describe the relationship between LOVs and record groups |
| __ | Explain the steps to create an LOV manually |
| __ | Use the LOV Wizard to create an LOV |
| __ | Set LOV properties |
| [ ] | Create editors and associate them with text items in a form module |
Creating Additional Input Items |
|
| [ ] | Describe the item types that allow input |
| [ ] | Create a check box |
| [ ] | Create a list item |
| [ ] | Create a radio group |
Creating Noninput Items |
|
| [ ] | Describe item types that do not allow input |
| [ ] | Create a display item |
| [ ] | Create an image item |
| [ ] | Create a button |
| [ ] | Create a calculated item |
| [ ] | Create a hierarchical tree item |
| [ ] | Create a bean area item |
Creating Windows and Content Canvases |
|
| [ ] | Define windows, content canvases, and viewports |
| [ ] | Describe the relationship between windows and content canvases |
| [ ] | Create windows and content canvases |
| [ ] | Display a form module in multiple windows and on multiple layouts |
Working with Other Canvas Types |
|
| [ ] | Describe the different types of canvases and their relationships to each other |
| [ ] | Identify the appropriate canvas type for different scenarios |
| [ ] | Create an overlay effect by using stacked canvases |
| [ ] | Create a toolbar |
| [ ] | Create a tabbed interface |
Introduction to Triggers |
|
| [ ] | Define triggers |
| [ ] | Describe the different trigger categories |
| [ ] | Describe the components of a trigger |
| [ ] | Describe the types of statements used in trigger code |
| [ ] | Describe the properties that affect the behavior of a trigger |
Working in the Forms Developer Environment |
|
| [ ] | Describe the main Forms Developer executables |
| [ ] | Describe the main Forms Developer module types |
| [ ] | Describe the main objects in a form module |
| [ ] | Run a form from within Forms Builder |
| __ | Start and stop an OC4J instance |
| __ | Set Forms Builder preferences to use OC4J |
Creating a Basic Form Module |
|
| [ ] | Create a form module |
| [ ] | Create data blocks, create data blocks with relationships and create control blocks |
| [ ] | Use wizards in re-entrant mode to make changes to the data block and layout |
| [ ] | Save and compile a form module |
| [ ] | Describe Forms file formats and their characteristics |
| [ ] | Explain how to deploy a form module |
| [ ] | Produce text files and documentation |
| [ ] | Run a master-detail form module |
Working with Data Blocks and Frames |
|
| [ ] | Describe the methods to modify object properties |
| [ ] | Describe the features of the Property Palette |
| [ ] | Manipulate properties through the Property Palette |
| __ | Display the Property Palette |
| __ | Describe the property controls for different types of properties |
| __ | Display multiple Property Palettes |
| __ | Set properties on multiple objects |
| __ | Copy properties |
| [ ] | Control the behavior and appearance of data blocks |
| __ | Use visual attributes |
| __ | Use font, pattern, and color pickers |
| __ | Set navigation properties |
| __ | Set records properties |
| __ | Set database properties |
| __ | Set scrollbar properties |
| [ ] | Control frame properties |
| [ ] | Delete data blocks and their components |
Working with Text Items |
|
| [ ] | Describe text items |
| [ ] | Create a text item |
| [ ] | manage and modify text items using the property palette |
| [ ] | Display helpful messages |
Producing Triggers |
|
| [ ] | Write trigger code |
| __ | Create a trigger of appropriate type and scope |
| __ | Describe the features of the PL/SQL Editor |
| __ | Describe the features of the Database Trigger Editor |
| __ | Explain the structure of trigger code |
| __ | Use variables in triggers |
| [ ] | Explain the use of built-in subprograms in Forms applications |
| [ ] | Describe the When-Button-Pressed trigger |
| [ ] | Describe the When-Window-Closed trigger |
Debugging Triggers |
|
| [ ] | Describe the methods to debug triggers in Forms Builder |
| [ ] | Describe the components of the Debug Console |
| [ ] | Run a form module in debug mode by using the Run Form Debug button |
| [ ] | Debug PL/SQL code |
| __ | Set breakpoints in code |
| __ | Step through code |
| __ | View variable values while form is running |
Adding Functionality to Items |
|
| [ ] | Describe item interaction triggers |
| [ ] | Supplement the functionality of input items by using triggers and built-ins |
| __ | Code interactions with radio groups |
| __ | Code interactions with check boxes |
| __ | Change list items at run time |
| __ | Display an LOV from a button |
| [ ] | Supplement the functionality of noninput items by using triggers and built-ins |
| __ | Populate image items |
| __ | Populate hierarchical trees |
| __ | Code interactions with JavaBeans in the bean area item |
Run Time Messages and Alerts |
|
| [ ] | Describe the default messaging behavior of a form |
| [ ] | Handle run time failure of built-in subprograms |
| [ ] | Describe the different types of Forms Builder messages |
| [ ] | Cause a trigger to fail in a controlled manner |
| [ ] | Control system messages |
| [ ] | Create and control alerts |
| [ ] | Handle database server errors |
Query Triggers |
|
| [ ] | Explain the processes involved in querying a data block |
| [ ] | Describe query triggers and their scope |
| [ ] | Control query array processing |
| [ ] | Write triggers to modify query behavior |
| [ ] | Control trigger action based on the form's query status |
| [ ] | Obtain query information at run time |
Validation |
|
| [ ] | Describe the validation process |
| [ ] | Control validation: |
| __ | Using object properties |
| __ | Explain the effects of the validation unit upon a form |
| __ | Use an LOV for validation |
| __ | Using triggers |
| __ | Using Pluggable Java Components |
| [ ] | Describe how Forms tracks validation status |
| [ ] | Control when validation occurs |
Navigation |
|
| [ ] | Describe how navigation affects the navigation unit and the cursor |
| [ ] | Distinguish between internal and external navigation |
| [ ] | Control navigation with properties |
| [ ] | Describe and use navigation triggers to control navigation |
| [ ] | Explain how the cursor can become stuck between two items, resulting in a navigation trap |
| [ ] | Use navigation built-ins in triggers |
Transaction Processing |
|
| [ ] | Explain the process used by Forms to apply changes to the database |
| [ ] | Describe the commit sequence of events |
| [ ] | Describe the characteristics and uses of commit triggers |
| [ ] | Supplement transaction processing |
| __ | Perform delete validation |
| __ | Allocate sequence numbers to records as they are applied to tables |
| __ | Keep an audit trail |
| [ ] | Test the results of trigger DML |
| [ ] | Override default transaction processing |
| [ ] | Describe how to run against a non-Oracle data source |
| [ ] | Get and set the commit status |
| [ ] | Implement array DML |
Writing Flexible Code |
|
| [ ] | Describe flexible code |
| [ ] | Use system variables to determine: |
| __ | Cursor focus |
| __ | Trigger focus |
| __ | Commit status |
| [ ] | Describe built-in subprograms that assist flexible coding |
| Write code to reference objects: | |
| __ | By internal ID |
| __ | Indirectly |
Sharing Objects and Code |
|
| [ ] | Describe benefits of reusing objects and code |
| [ ] | Create and use property classes |
| __ | Describe property classes |
| __ | Create property classes |
| __ | Add properties to property classes |
| __ | Inherit properties from property classes |
| __ | Explain the inheritance symbols in the Property Palette |
| [ ] | Group related objects for reuse |
| [ ] | Copy and subclass objects |
| [ ] | Reuse objects from an object library |
| __ | Describe object libraries |
| __ | Describe the benefits of using object libraries |
| __ | Create object libraries |
| __ | Populate object libraries |
| __ | Modify objects in an object library |
| __ | Create and use SmartClasses |
| [ ] | Reuse PL/SQL code |
Introducing Multiple Form Applications |
|
| [ ] | Describe the characteristics of multiple form applications |
| [ ] | Describe the benefits of multiple form applications |
| [ ] | Call one form from another form module |
| [ ] | Define multiple form functionality |
| [ ] | Share data among open forms |
| [ ] | Control opening and closing of multiple forms |
| [ ] | Synchronize data among multiple forms |
Creating a Menu Module |
|
| [ ] | Describe the different components of a menu module |
| [ ] | Create, save and attach menu modules |
| [ ] | Set menu properties using the Property Palette |
| [ ] | Create menu toolbars |
| [ ] | Create pop-up menus |
Managing Menu Modules |
|
| [ ] | Control menus programmatically |
| [ ] | Manage the interaction between the menu and form documents |
| [ ] | Implement application security through the menu |
Programming Function Keys |
|
| [ ] | Define key triggers and their uses |
| [ ] | Program function keys |
| [ ] | Describe the characteristics of key triggers |
| [ ] | Classify key triggers |
| [ ] | Associate function keys with interface controls |
Building Multiple Form Applications |
|
| [ ] | Describe the various ways of invoking additional forms modules |
| [ ] | Open and close form modules |
| [ ] | Navigate between form modules |
| [ ] | Control open form modules |
| [ ] | Choose the most appropriate method for invoking forms |
Defining Data Sources |
|
| [ ] | Describe the various datasource types |
| [ ] | Base a data block on a FROM clause query |
| [ ] | Discuss the advantages of using a FROM clause query |
| [ ] | Base a data block on a stored procedure that returns a REF cursor |
| [ ] | Return a table of records from a stored procedure |
| [ ] | Define a Data Source with the Data Block Wizard |
| [ ] | Select the appropriate data source for a data block |
Working with Record Groups |
|
| [ ] | Describe the record group object |
| [ ] | Use record groups |
| [ ] | Define record groups at design time |
| [ ] | Control record groups by using built-in functions |
| [ ] | Define query record groups programmatically and nonprogrammatically |
| [ ] | Manipulate record group rows |
| [ ] | Define lists of values (LOVs) programmatically |
| [ ] | Implement dynamic list items and add values to combo boxes |
Using Database Objects in Forms Applications |
|
| [ ] | Recognize which object types are supported |
| [ ] | Describe how object types are represented within Form Builder |
| [ ] | Create a block based on relation table with an object or an REF column |
| [ ] | Populate a REF column with an LOV |
