Try to answer these 40 Oracle Forms 9i MCQs and check your understanding of the Oracle Forms 9i subject.
Scroll down and let's begin!
A. Both windows must be defined as dialog and modal
B. Both windows must be defined as document and modal
C. Both windows must be defined as document and modeless
D. The default window must be defined as modeless and the BUTTONS window must be modal Â
A. ADD_GROUP_ROW
B. POPULATE_GROUP
C. ADD_GROUP_COLUMN
D. SET_GROUP_SELECTIONÂ Â
A. Enabled
B. Database Item
C. Update Allowed
D. Update Only If NULLÂ
A. You cannot drag a program unit to an object group
B. Object groups contain copies of the original objects
C. You can delete the original objects without affecting the object group
D. You can delete the object group without affecting the original objectsÂ
A. The Record Group is associated with a query
B. The Record Group can be created only at run time
C. The Record Group can be created and modified only at design time
D. The Record Group can be created and modified at design time or at run time
E. The query associated with this Record Group can be defined only at design time Â
A. Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to NO
B. Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to YES
C. Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to NO
D. Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to YESÂ
A. The form doesn't compile and therefore cannot be tested
B. The icon is not displayed on the button. When you click the Sales Rep Id field and then click the button, the LOV is invoked.
C. The icon is displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
D. The icon is not displayed on the button. When you click in the Sales Rep Id field and then click the button, the LOV is not invoked and an error is reported.
A. CREATE_GROUP('PRODUCT')
B. CREATE_GROUP('PRODUCT', FORM_SCOPE)
C. CREATE_GROUP('PRODUCT', GLOBAL_SCOPE)
D. CREATE_GROUP_FROM_QUERY('PRODUCT', 'Select id, desc from products', GLOBAL_SCOPE)Â Â
A. The Record Group can be created only at run time
B. The Record Group is not associated with a query
C. The Record Group can be created and modified only at design time
D. The Record Group can be created and modified at design time or at run timeÂ
A. You cannot raise FORM_TRIGGER_FAILURE in an exception handler
B. FORM_TRIGGER_FAILURE does not cause an Unhandled Exception
C. FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner
D. None of the aboveÂ
A. You will see only three submenus from the Test menu (plus the Window menu that is usually displayed) and you will not be able to call code from the default menu in your form
B. You will see the three submenus from the Test menu merged with the submenus of the default menu (plus the Window submenu that is usually displayed)
C. You will see only the submenus of the default menu (plus Window), but you will be able to call code from the Test menu in your form
D. You will see only the Test menu submenus (plus Window), but you will be able to call code from the default menu in your form
E. You will see only the submenus of the default menu (plus Window) until you issue the REPLACE_MENU built-in in the formÂ
Name | Label |
ENTER_QUERY | ENTER QUERY |
EXECUTE_QUERY | EXECUTE &QUERY |
EDIT | Edi&t |
EXIT Â Â Â Â Â | eXit |
A. EDIT
B. EXIT
C. ENTER_QUERY
D. EXECUTE_QUERYÂ Â
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Â Â
JOB_TITLE | JOB_ID |
Accountant | FI_ACCOUNT |
Accounting Manager | AC_MGR |
Administration | AD_ASST |
Assistant | |
President | AD_PRES |
Programmer  | IT_PROG |
Public Accountant | AC_ACCOUNT |
Purchasing Clerk | PU_CLERK |
Purchasing Manager | PU_MAN |
Sales Manager | SA_MAN |
Sales Representative | SA_REP |
A. The LOV will appear. If the user clicks Cancel, the cursor will move to the next navigable item in the form.
B. The LOV will appear. If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear.
C. The LOV will not appear. The Job_ID item will be assigned the value IT_PROG. The cursor will move to the next navigable item in the form.
D. The LOV will not appear. The Job_ID item will be assigned the value Programmer. The cursor will move to the next navigable item in the form.Â
A. POPULATE_GROUP_WITH_QUERY ('JOBS', 'SELECT distinct initcap(job) as Job,'|| 'job as JOB from emp');
B. POPULATE_GROUP_WITH_QUERY ('JOBS', 'SELECT initcap(title) as Job,' || 'sal as Salary from emp');
C. rgid := CREATE_GROUP_FROM_QUERY ('JOBS', 'SELECT distinct initcap(job) as Job ,' || 'job as JOB from emp');
D. rgid := CREATE_GROUP_FROM_QUERY ('JOBS', 'SELECT initcap(title) as Job.' || 'sal as Salary from emp')Â Â
A. The Record Group is associated with a query
B. The Record Group can be created only at run time
C. The Record Group can be created and modified only at design time
D. The Record Group can be created and modified at design time or run time Â
A. Use the GET_ALERT_PROPERTY function
B. Use the GET_ALERT_BUTTON_PROPERTY function
C. Check the value returned by the SHOW_ALERT function to see if it is 1, 2, or 3
D. Check the value returned by the SHOW_ALERT function to see if it is ALERT_BUTTON1, ALERT_BUTTON2, or ALERT_BUTTON3Â
A. True
B. False <br>
A. Define a data block based on Ref Cursor
B. Define a data block based on a Table of Records
C. Define a data block based on a From Clause query
D. Define a data block based on a combination of a Ref Cursor and a Table of Records Â
A. In a list item
B. In a list of values
C. In a set of parameters
D. In a record groupÂ
A. IF :order_total > 10000 AND :credit_limit < 10000 THEN
MESSAGE(Credit limit exceeded);
END IF;
B. IF :SYSTEM.cursor_item > 10000 AND :SYSTEM.trigger_item < 10000 THEN
MESSAGE(Credit limit exceeded);
END IF;
C. IF NAME_IN('order_total') > 10000 AND NAME_IN('credit_limit') < 10000 THEN
MESSAGE(credit limit exceeded);
END IF;
D. IF COPY(ORDERS.order_total) > 10000 AND COPY(ORDERS.credit_limit) < 10000 THEN
MESSAGE(credit limit exceeded?;
END IF;
A. 1. Create a tab canvas in the Layout Editor
2. For each item, associate the tab canvas by specifying the Canvas property
3. Set the Rendered property of each item to Yes
B. 1. Create a tab canvas in the Layout Editor
2. For each item, associate the tab canvas by specifying the Canvas property
3)For each item, associate the tab page by specifying the Tab Page property
C. 1. Create a Tab page in the Layout Editor
2. Associate the content canvas with each item by specifying the Item Canvas property
3. For each item, associate the tab page by specifying the Tab Page property
4)Set the Visible prope
D. 1. Create a canvas in the Object Navigator.
2. Set the Canvas Type property to Content.
3. For each item, associate the new canvas by specifying the Item Canvas property.Â
E. 1. Create a new canvas in the Object Navigator.
2. Set the Canvas Type property to Tab.
3. For each item, associate the new canvas by specifying the Item Canvas property.
4. For each item, associate the tab page by specifying th
A. CALL_FORM('Departments);
B. CALL_FORM('Departments',NO_HIDE);
C. OPEN_FORM('Departments');
D. OPEN_FORM('Departments', ACTIVATE, SESSION);
E. OPEN_FORM('Departments', NO_ACTIVATE, NO_SESSION);Â Â
A. Define CLYDE as a modal window and display it with a horizontal scroll bar
B. Define CLYDE as a modeless window and display it with a horizontal scroll bar
C. Define CLYDE as a dialog window and display it with a horizontal scroll bar
D. Define CLYDE as a document window and display it with a Vertical Scroll bar
E. Define CLYDE as a modeless window and display it with a Vertical Scroll barÂ
A. Item Type must be set to Display Item
B. Calculation Mode must be set to Formula
C. Calculation Mode must be set to Summary
D. Summarized Block must be set to ORDER_ITEMS
E. Formula must be set to an appropriate calculationÂ
A. The forms run on your local machine using a debug executable client
B. The form runs in a three-tier environment using the application server URL that you specify in runtime preferences
C. The form runs in a three-tier environment using the application server URL that you specify in debug preferences
D. The form runs in a simulated three-tier environment using an applet viewer that is included with the product to enable debuggingÂ
A. If the Maximum Length of an item is set to a value that is greater than the value for Width, the item will not be displayed at run time
B. You can set the Initial Value for an item outside the range of values specified by the Lowest Allowed Value and the Highest Allowed Value properties because Initial Value defines an exception to that range
C. If you set the Required property to Yes for an item whose corresponding database column does not have a NOT NULL constraint, you will receive an error at run time
D. If Data Length Semantics property is set to BYTE, you may need to manually adjust the Maximum Length property depending on the character set that is being usedÂ
A. You cannot use wizards to add a new item to add data block that was created manually
B. Select the last item in the Orders block, then invoke the Layout Wizard from the menu
C. Select the Order Block in the Object Navigator, then invoke the Data Block Wizard from the menu
D. Select the Data Block node in the Object Navigator, then invoke the Data Block Wizard from the menu. //new blockÂ
A. Set the List Style property to combo box. From the When-List-Activated trigger, call the Add_List_Element built-in
B. Set the List Style property to Tlist. From the When-List-Activated trigger, call the Populate_List built-in
C. Set the List Style property to poplist. From the When-List-Activated trigger, call the Add_List_Element built-in.
D. Set the List Style property to combo box. From the When-List-Changed trigger, call the Add_List_Element built-in
A. Ensure that the current item is not hidden by the overlay canvas
B. Call the built-in GET_VIEW_PROPERTY to set the canvas VISIBLE property to True
C. In the Layout Editor, choose View | Stacked Views and then select the overlay canvas in the Stacked Canvases dialog box
D. Change the stacking order of canvases under the Canvases node in the Object Navigator. Ensure that the overlay canvas is the first canvas listed under this node Â
A. CALL_FORM because NEW_FORM is no longer valid for Web-deployed forms due to the extra network traffic that is causes
B. CALL_FORM because it can be issued in Enter-Query mode and can be constrained to be Query only
C. CALL_FORM because the second form is invoked in a modeless state and it saves on memory resources
D. NEW_FORM because the second form is invoked in a modeless state and the user can navigate freely between the two running forms Â
A. ADD_GROUP_ROW
B. POPULATE_GROUP
C. ADD_GROUP_COLUMN
D. SET_GROUP_SELECTIONÂ Â
A. Define EMP_WIN as a modal window, set the Hide on Exit property to No
B. Define EMP_WIN as a modeless window, set the Hide on Exit property to No
C. Define EMP_WIN as a modeless window, set the Hide on Exit property to Yes
D. Define EMP_WIN as a modeless window, set the Close Allowed property to YesÂ
A. You did not change the default value for the Data Type property of the Order_Status text item
B. You did not modify the WHERE clause of the Orders block to include the ORDER_STATUS column
C. You did not change the default value for the Database Item property of the Order_Status text item
D. You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item Â
A. You can create it by first creating a text item and then changing the item type
B. You can create it in the Layout Editor using a special tool that creates a calculated item
C. You can create it by first creating a display item and then setting appropriate properties in its Calculation property group
D. You can create it in the Layout Editor by selecting the Salary item of the Employees block, selecting the Control block from the block list, clicking the Text Item tool, and drawing a text item on the canvas to automatically calculate a sum of the selecte
A. It appears in the Forms Builder window that can be minimized once OC4J starts
B. It appears in a separate window that can be closed once OC4J starts
C. It appears in the Forms Builder window that can be closed once OC4J starts
D. It appears in a separate window that should not be closed as the OC4J instance will abort
A. When-Validate-Item at form level so that validation takes place as soon as the form initializes
B. When-New-Form-Instance because GO_ITEM is a Restricted Procedure and cannot be called from any Pre- triggers
C. Pre-Form at form level because the focus will be set before the items appear so that users do not see the cursor moving around the screen
D. When-Button-Pressed on any of the enabled buttons so that it can still execute. If it were written against the disabled buttons, it would have never been fired for the STORE_CLERK role
E. When-New-Item-Instance on the Date_Ordered Text item because you want to check for the database role and redirect focus away from here if the user is a STORE_CLERKÂ
A. It requires a network round trip
B. It does not require any middle-tier configuration
C. It requires setting an item's Implementation Class property
D. It is implemented with the When-Validate-Item and When-Validate-Record triggers
A. SET_APPLICATION_PROPERTY
B. SET_FORM_PROPERTY
C. SET_BLOCK_PROPERTY
D. SET_RECORD_PROPERTYÂ Â
A. ADD_GROUP_ROW('REGIONS',2);
B. rgno := CREATE_GROUP_FROM_QUERY('REGIONS', 'Select name, country, id from regiontable')
C. rgno := CREATE_GROUP_FROM_QUERY('REGIONS', 'Select name, country from regiontable');
D. rgno := POPULATE_GROUP_WITH_QUERY('REGIONS', 'Select name, country from regiontable');
E. You cannot populate a non-query Record Group with the results of a query.Â
A. ENTER;
IF GET_ITEM_PROPERTY(:SYSTEM.trigger_item, ITEM_IS_VALID) = TRUE THEN
COMMIT_FORM;
END IF;
B. ENTER;
IF :SYSTEM.FORM_STATUS = CHANGED THEN
COMMIT_FORM;
END IF;
C. VALIDATE(ITEM_SCOPE);
IF :SYSTEM.BLOCK_STATUS <> NEW THEN
DO_KEY('COMMIT_FORM');
END IF;
D. VALIDATE;
IF :SYSTEM.BLOCK_STATUS <> NEW THEN
DO_KEY('COMMIT_FORM');
END IF;Â
A. You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group
B. You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same record group
C. You can use the same LOV and record group for the Choose_Event.Event_Name item that you used for the Tickets.Event_Date item
D. You can use the same LOV for both items, but you should specify that each item must use a different record group for the LOV
A. FIND_MENU_ITEM
B. GET_ITEM_PROPERTY
C. SET_ITEM_PROPERTY
D. SET_MENU_ITEM_PROPERTY
E. GET_MENU_ITEM_PROPERTYÂ
A. You cannot programmatically disable validation in a form
B. Use the SET_FORM_PROPERTY built-in to set the VALIDATION property
C. Use the SET_FORM_PROPERTY built-in to set the VALIDATION_UNIT property
D. Use the SET_FORM_PROPERTY built-in to set the DEFERS_REQUIRED_ENFORCEMENT propertyÂ