testking oracle 9i 1z0-141
Visited 1723 times, 4 so far today
Exam 1z0-141: Oracle Forms: Build Internet Applications
Exam Number: 1Z0-141
Associated Certifications: Application Developer OCP
Exam Price: $125.00 USD
Exam Registration: Register
Duration: 120 mniutes
Number of Questions: 69
Passing Score: 75%
Recommended Training and Preparation
Oracle9i Forms Developer: Build Internet Applications
Oracle Forms Developer 10g: Build Internet Applications
eStudies
Oracle9i Forms Developer: Use Data Structures Effectively
Oracle9i: Forms Developer: Enhance Useability
The e-studies are available to you on the Oracle University Online website.
Oracle 10g Forms Developer: Build Internet Applications Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.
Additional Information & Resources
Practice Exams
Oracle authorized practice exam from Self Test Software: 1Z0-141 Oracle 9i Forms Developer: Build Internet Applications
Oracle authorized practice exam from Transcender: Cert-1Z0-141 DBCert: Oracle Forms: Build Internet Applications
Oracle Application Developer Candidate Guide
Exam Retake Policy
Exam Topics
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
Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.
View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.
Recommended Training about 1z0-141 exam PDF
The following courses are the recommended training for 1z0-141 exam PDF.
1z0-141 Q & A with Explanations
1z0-141 Audio Exam
1z0-141 Study Guide
1z0-141 Preparation Lab
1z0-141 Exam: Freetestking’s oracle9i forma developer:build internet applications PDF
The oracle9i forma developer:build internet applications PDF for preparing for the 1z0-141 exam – Freetestking’s oracle9i forma developer:build internet applications. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
QUESTION 1:
The DBA has added STATE column to the CUSTOMERS table and has asked you to add a corresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation.
Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director for those customers outside the region.
Which style of list item will you create for the State item?
A. A poplist
B. A Tlist
C. A combo box.
D. There is no style of list item that allows users to enter values that are not on the list.
Answer: C
Oracle 9i: Forms Developer Build Internet Application M8-P11
Combo box: Appears as a field with a downarrow next to its right side (Use the button to display all the combo box list
elements. The combo box accepts user input.)
QUESTION 2:
Exhibit:
You want to create a new data block. You click the Data Blocks node in the Object Navigator, and then you click Create to invoke the Create Data Block dialog box. As you click through the pages of the
wizard, the page shown in the exhibit appears.
After looking at the exhibit, what do you know is true about this form?
A. The block you are creating is based on a view.
B. The block you are creating is based on a stored procedure.
C. The form contains at least one block in addition to the block you are creating.
D. In addition to the block you are creating, the form contains at least two other blocks that are master-detail blocks.
TK
1Z0-141
E. The block you are creating is based on a table that has at least one foreign key relationship to another table.
Answer: C
Oracle 9i: Forms Developer Build Internet Application M4-P32
You can build a master-detail form module either by creating a relation between a master and detail block explicitly, or
implicitly by using the Data Block Wizard.
1. Create the master block as described earlier in this lesson in the topic Creating a New Data Block.
2. Invoke the Data Block Wizard in the Object Navigator.
3. Follow the same steps as before to create a new data block in the Data Block Wizard until you come to the
Master-Detail page.
QUESTION 3:
You are creating an application on a Windows PC, and you want to test a form. What are two ways to start an OC4J instance on the PC? (Choose two)
A. From the Forms Builder menu. B. From the Windows Start menu.
C. By executing a batch file that is included with Oracle9iDS. D. From the test form that is included with Oracle9iDS.
E. From the HTML front end (runform.htm) that is included with Oracle9iDS.
F. By running a Forms Builder form, which automatically starts OC4J.
Answer: B, C
Oracle 9i: Forms Developer Build Internet Application M3-P17
To use OC4J on Windows NT, you start it by executing the batch file provided, called startinst.bat. This file is located in the j2ee\Oracle9iDS\ subdirectory of ORACLE_HOME. If you will be
testing your applications on your client machine, it is a good idea to set up a shortcut to this batch file, and also to the batch file to stop the OC4J
instance, called stopinst.bat.
QUESTION 4:
While updating an existing customer record using the Customers form, the user invoked the Orders form
by clicking the CONTROL.Orders_btn button. The When-Button-Pressed trigger had the following code:
CALL_FORM(’orders’);
There is a requirement to navigate back to the Customers form after the order details have also been updated. This will be achieved through a form-level Key-Exit trigger in the Orders form.
Which code should be used?
A. IF GET_APPLICATION_PROPERTY(calling_form) IS NOT NULL THEN EXIT_FORM(ASK_COMMIT, NO_ROLLBACK;
ELSE EXIT_FORM;
TK
1Z0-141
END IF;
B. VALIDATE(FORM_SCOPE);
IF :SYSTEM.FORM_STATUS <> ‘QUERY’ THEN GO_FORM(’CUSTOMERS’);
ELSE EXIT_FORM; END IF;
C. ENTER
IF :SYSTEM.CURSOR_BLOCK = ‘CHANGED’ THEN COMMIT_FORM ;
ELSE
EXIT_FORM(NO_VALIDATE, NO_ROLLBACK); END IF;
D. IF :SYSTEM.FORM_STATUS = ‘CHANGED’ THEN COMMIT_FORM:
END IF; GO_FORM(’CUSTOMERS’);
Answer: A
Oracle Forms Developer 6i: Build Internet Applications II M9-P17
QUESTION 5:
Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and
has asked you to add an item to your form so that data entry clerks can populate the RATING column.
To restrict data entry clerks to one of these three values, you decide to create a radio group for the
Rating item. With the Customers block selected in the Layout Editor, you use the radio button to create three radio buttons on the canvas. You then set the labels (Poor, Good, and Excellent) and values (1, 2, and 3) for the radio buttons. You set the name of the radio group to RATING, its Data Type to Number,
and its Database column to Rating.
You run the form to test it. When you execute a query, however, no records are returned, although there are many customer records in the database.
What can you do to make the query return the records?
A. Set the Mapping of Other Values property for the radio group to Null.
B. Create a fourth radio button for an undetermined credit rating and leave its value blank.
C. Create a fourth radio button for an undetermined credit rating and explicitly set its value to Null.
D. Choose a different type of input, because radio groups do not allow query of Null values.
Answer: A
Oracle 9i: Forms Developer Build Internet Application M8-P23
Handling Other Values in a Radio Group
If the base table column for a radio group accepts values other than those associated with your radio buttons, you must use
one of the following methods to specify how you want to handle the values:
It doesn
Dowload PassGuide Practice Test Questions
3 Comments on “testking oracle 9i 1z0-141”