The focus of this Oracle Forms 10g assessment is to test the knowledge of test takers in creating forms to interact with an Oracle 10g database. The test covers how Oracle Forms interacts with a database using a variety of blocks, triggers, items, objects, windows, buttons, and simple real-world scenarios involved in everyday Oracle Forms use. This is a beginner to intermediate level test for those who have been working with Oracle Forms for a year or less. An assessment for Oracle 10g for Developers is also available. Total Questions 53 Question Types Multiple Choice Competencies Tested BlocksObjectsItemsButtonsTriggersWindows Tasks Tested Modifying the Data BlockDML Statements Issued During Commit ProcessingDeleting Data BlocksCreating Control BlocksControlling the Behavior and Appearance of Data BlocksQuery Array ProcessingWorking with Object GroupsMarking Objects as StandardsBenefits of Reusable Objects and CodeColor ChangeChange to Button Color StandardsControlling System MessagesReusing PL/SQLReferencing Objects by Internal IDControlling Distance Between RecordsBypass Normal ValidationCreating List ItemsCreating Text ItemsDefining EditorsWorking with Property ClassesCreating a Display ItemTracking Validation StatusReferencing Items IndirectlyTrapping User SelectionsControlling Validation Using PropertiesStandard Navigator Data DisplayCreating a Calculated ItemNew Text Item and the Layout EditorCreating a Push ButtonThe Debugging ProcessCreating Radio GroupsUsing Variables and Built-insWhen-Window-Closed TriggerRecord Deletion ConfirmationUsing System Variables for Flexible CodingQuery Processing and TypesException Handler SyntaxCommon Uses of Commit TriggersCommit Sequence of EventsGrouping Triggers into CategoriesWriting Query TriggersCoding Triggers for Enter-Query ModeTrigger ComponentsCoding Item Interaction TriggersControlling Validation Using TriggersForms Query ProcessingWriting Trigger CodeTrigger Firing SequenceMultiple Content CanvasesCreating OverlaysCreating a New WindowDisplaying a Form Module in Multiple Windows
