'Create a library module' is a method of reuse that is possible with a PL/SQL program unit, but not with a Forms trigger.
A user has requested a change to the Summit.fmb module. The form has two windows, DEPT_WIN and EMP_WIN. DEPT_WIN is always visible to the user. However, EMP_WIN is only occasionally required to be ...
Define EMP_WIN as a modal window, set the Hide on Exit property to No 0.0%
Define EMP_WIN as a modeless window, set the Hide on Exit property to No 0.0%
Define EMP_WIN as a modeless window, set the Hide on Exit property to Yes 100.0%
Define EMP_WIN as a modeless window, set the Close Allowed property to Yes 0.0%
An application uses a menu that contains a Check type Menu Item. You want to programmatically toggle the checked/unchecked state of the Check item. Which of the following built-ins can you use to a...
FIND_MENU_ITEM 0.0%
GET_ITEM_PROPERTY 0.0%
SET_ITEM_PROPERTY 0.0%
SET_MENU_ITEM_PROPERTY 0.0%
GET_MENU_ITEM_PROPERTY 100.0%
In the Human Resource form, you created a LOV based on a record group. The record group query selects the job title and job ID from the JOBS table that contains the following records: JOB_TITLE J...
The LOV will appear. If the user clicks Cancel, the cursor will move to the next navigable item in the form. 0.0%
The LOV will appear. If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear. 100.0%
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. 0.0%
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. 0.0%
In the Human Resource form, you created a LOV based on a record group. The record group query selects the job title and job ID from the JOBS table that contains the following records: � JOB_TITLE ...
The LOV will appear. If the user clicks Cancel, the cursor will move to the next navigable item in the form. 0.0%
The LOV will appear. If the user clicks Cancel, the cursor will remain in the Job_ID item and an error message will appear. 0.0%
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. 100.0%
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. 0.0%
In the Orders Form you define five LOVs and create one button to be used to display any of the LOVs. The button is enabled only when the user navigates through a field with an attached LOV. If the ...
Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to NO 0%
Use the List_Values(RESTRICT) built-in, and set the Mouse Navigate property value to YES 0%
Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to NO 0%
Use the List_Values(NO_RESTRICT) built-in, and set the Mouse Navigate property value to YES 0%
Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it. What property can ...
Enabled 0%
Database Item 0%
Update Allowed 0%
Update Only If NULL 0%
The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resource application. HR clerks use the Employees form to query, update, and ...
CALL_FORM('Departments); 0%
CALL_FORM('Departments',NO_HIDE); 0%
OPEN_FORM('Departments'); 0%
OPEN_FORM('Departments', ACTIVATE, SESSION); 0%
OPEN_FORM('Departments', NO_ACTIVATE, NO_SESSION); 0%
The DBA has informed you that two new columns have been added to the ORDERS table. The blocks in the Order Entry form were created manually. How can you use a wizard to modify the Orders block to i...
You cannot use wizards to add a new item to add data block that was created manually 0%
Select the last item in the Orders block, then invoke the Layout Wizard from the menu 0%
Select the Order Block in the Object Navigator, then invoke the Data Block Wizard from the menu 0%
Select the Data Block node in the Object Navigator, then invoke the Data Block Wizard from the menu. //new block 0%
The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table. You want to update the Order Entry form to display the additional data. You open the Layout Editor ...
You did not change the default value for the Data Type property of the Order_Status text item 0%
You did not modify the WHERE clause of the Orders block to include the ORDER_STATUS column 0%
You did not change the default value for the Database Item property of the Order_Status text item 0%
You did not select the Orders block from the block poplist in the Layout Editor prior to creating the item 0%
The Department form is a part of a multiform application that also includes the Customer and Orders forms. The Department form must include a query-based PRODUCT Record Group. You must ensure that ...
CREATE_GROUP('PRODUCT') 0%
CREATE_GROUP('PRODUCT', FORM_SCOPE) 0%
CREATE_GROUP('PRODUCT', GLOBAL_SCOPE) 0%
CREATE_GROUP_FROM_QUERY('PRODUCT', 'Select id, desc from products', GLOBAL_SCOPE) 0%
The LINE data block is defined in the Order.fmb module. LINE items are displayed in the default window at run time. In a second window called BUTTONS, you display a set of icon buttons. At run time...
Both windows must be defined as dialog and modal 0%
Both windows must be defined as document and modal 0%
Both windows must be defined as document and modeless 0%
The default window must be defined as modeless and the BUTTONS window must be modal 0%
The menu that appears by default in a Forms application does not quite meet your needs, so you decide to create a custom menu. You create and compile a menu module called Test with three submenus t...
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 0%
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) 0%
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 0%
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 0%
You will see only the submenus of the default menu (plus Window) until you issue the REPLACE_MENU built-in in the form 0%
The Orders form is required to initialize differently for different users. A database procedure (GET_ROLE_NAME) is used to determine which database roles are enabled for the user logging on to the ...
When-Validate-Item at form level so that validation takes place as soon as the form initializes 0%
When-New-Form-Instance because GO_ITEM is a Restricted Procedure and cannot be called from any Pre- triggers 0%
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 0%
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 0%
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 0%
The Orders form must display the item total for products ordered. You decide to implement this functionality by creating an item in the ORDER_ITEMS block as a Calculated item. The item total is cal...
Item Type must be set to Display Item 0%
Calculation Mode must be set to Formula 0%
Calculation Mode must be set to Summary 0%
Summarized Block must be set to ORDER_ITEMS 0%
Formula must be set to an appropriate calculation 0%
The Products.fmb module has one content canvas that displays information about products sold by your company. You increase the canvas display area by creating an overlay canvas to enable the produc...
Ensure that the current item is not hidden by the overlay canvas 0%
Call the built-in GET_VIEW_PROPERTY to set the canvas VISIBLE property to True 0%
In the Layout Editor, choose View | Stacked Views and then select the overlay canvas in the Stacked Canvases dialog box 0%
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 0%
The REGIONS non-query Record Group has two char columns. Which of the following built-ins an you use to replace any existing rows in REGIONS with the results of a query?
ADD_GROUP_ROW('REGIONS',2); 0%
rgno := CREATE_GROUP_FROM_QUERY('REGIONS', 'Select name, country, id from regiontable') 0%
rgno := CREATE_GROUP_FROM_QUERY('REGIONS', 'Select name, country from regiontable'); 0%
rgno := POPULATE_GROUP_WITH_QUERY('REGIONS', 'Select name, country from regiontable'); 0%
You cannot populate a non-query Record Group with the results of a query. 0%
The user must be able to invoke a list of values for valid sales representative in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep ID field The tex...
The form doesn't compile and therefore cannot be tested 0%
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. 0%
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. 0%
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. 0%
There is a requirement to invoke the Orders form from the Customers form. Your colleagues offer some suggestions regarding their choice of built-in to be used. They also give the reasons for their ...
CALL_FORM because NEW_FORM is no longer valid for Web-deployed forms due to the extra network traffic that is causes 0%
CALL_FORM because it can be issued in Enter-Query mode and can be constrained to be Query only 0%
CALL_FORM because the second form is invoked in a modeless state and it saves on memory resources 0%
NEW_FORM because the second form is invoked in a modeless state and the user can navigate freely between the two running forms 0%
There is a requirement to modify the default functionality of the [Commit] key. To implement this requirement, you decide to write a Key-Commit trigger that will force validation and issue a commit...
ENTER; IF GET_ITEM_PROPERTY(:SYSTEM.trigger_item, ITEM_IS_VALID) = TRUE THEN COMMIT_FORM; END IF; 0%
ENTER; IF :SYSTEM.FORM_STATUS = CHANGED THEN COMMIT_FORM; END IF; 0%
VALIDATE(ITEM_SCOPE); IF :SYSTEM.BLOCK_STATUS <> NEW THEN DO_KEY('COMMIT_FORM'); END IF; 0%
VALIDATE; IF :SYSTEM.BLOCK_STATUS <> NEW THEN DO_KEY('COMMIT_FORM'); END IF; 0%
To centralize some of your processing, you decide to write PL/SQL library modules, which contain procedures that can be called from the triggers or menu items. You want the message [Credit limit ex...
IF :order_total > 10000 AND :credit_limit < 10000 THEN MESSAGE(Credit limit exceeded); END IF; 0%
IF :SYSTEM.cursor_item > 10000 AND :SYSTEM.trigger_item < 10000 THEN MESSAGE(Credit limit exceeded); END IF; 0%
IF NAME_IN('order_total') > 10000 AND NAME_IN('credit_limit') < 10000 THEN MESSAGE(credit limit exceeded); END IF; 0%
IF COPY(ORDERS.order_total) > 10000 AND COPY(ORDERS.credit_limit) < 10000 THEN MESSAGE(credit limit exceeded?; END IF; 0%
What happens when you click Run Form Debug in Forms Builder?
The forms run on your local machine using a debug executable client 0%
The form runs in a three-tier environment using the application server URL that you specify in runtime preferences 0%
The form runs in a three-tier environment using the application server URL that you specify in debug preferences 0%
The form runs in a simulated three-tier environment using an applet viewer that is included with the product to enable debugging 0%
Which of the following actions allow the user to view the display item at run time?
Define CLYDE as a modal window and display it with a horizontal scroll bar 0%
Define CLYDE as a modeless window and display it with a horizontal scroll bar 0%
Define CLYDE as a dialog window and display it with a horizontal scroll bar 0%
Define CLYDE as a document window and display it with a Vertical Scroll bar 0%
Define CLYDE as a modeless window and display it with a Vertical Scroll bar 0%
Which of the following helps you programmatically determine the button a user pressed to respond to an alert?
Use the GET_ALERT_PROPERTY function 0%
Use the GET_ALERT_BUTTON_PROPERTY function 0%
Check the value returned by the SHOW_ALERT function to see if it is 1, 2, or 3 0%
Check the value returned by the SHOW_ALERT function to see if it is ALERT_BUTTON1, ALERT_BUTTON2, or ALERT_BUTTON3 0%
Which of the following statements are correct with regard to FORM_TRIGGER_FAILURE?
You cannot raise FORM_TRIGGER_FAILURE in an exception handler 0%
FORM_TRIGGER_FAILURE does not cause an Unhandled Exception 0%
FORM_TRIGGER_FAILURE causes a trigger to fail in a controlled manner 0%
None of the above 0%
Which of the following statements are correct with regard to Query Record Group?
The Record Group is associated with a query 0%
The Record Group can be created only at run time 0%
The Record Group can be created and modified only at design time 0%
The Record Group can be created and modified at design time or run time 0%
The Record Group can be created and modified at design time or at run time 0%
The query associated with this Record Group can be defined only at design time 0%
Which of the following statements define a Static Record Group?
The Record Group can be created only at run time 0%
The Record Group is not associated with a query 0%
The Record Group can be created and modified only at design time 0%
The Record Group can be created and modified at design time or at run time 0%
Which of the following statements is correct with regard to client-side validation?
It requires a network round trip 0%
It does not require any middle-tier configuration 0%
It requires setting an item's Implementation Class property 0%
It is implemented with the When-Validate-Item and When-Validate-Record triggers 0%
Which of the following statements is correct with regard to Data properties of a text item?
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 0%
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 0%
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 0%
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 0%
Which of the following statements is correct with regard to object group?
You cannot drag a program unit to an object group 0%
Object groups contain copies of the original objects 0%
You can delete the original objects without affecting the object group 0%
You can delete the object group without affecting the original objects 0%
You are creating an application on a Windows PC. You want to test a form. How would you start an OC4J instance on the PC?
From the Forms Builder menu 0%
From the Windows Start menu 0%
By executing a batch file that is included with Oracle9iDS 0%
From the test form that is included with Oracle9iDS 0%
From the HTML front end (runform.htm) that is included with Oracle9iDS 0%
You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has a LOV whose record group uses the following query: SELECT e...
You must define a new LOV for the Choose_Event.Event_Name item that uses a different record group 0%
You must define a new LOV for the Choose_Event.Event_Name item, but you can base it on the same record group 0%
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 0%
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 0%
You are developing a form that serves as a front end to access the Order Entry application. Within the form, you want to store the usernames of those users who have permissions to run the applicati...
In a list item 0%
In a list of values 0%
In a set of parameters 0%
In a record group 0%
You are running a multiple-form application. The Customers Form invoked the Orders Form. When the Orders Form launches, it displays orders for only the active customer from the Customers form. Form...
SET_APPLICATION_PROPERTY 0%
SET_FORM_PROPERTY 0%
SET_BLOCK_PROPERTY 0%
SET_RECORD_PROPERTY 0%
You are testing a form. How can you programmatically disable validation during testing?
You cannot programmatically disable validation in a form 0%
Use the SET_FORM_PROPERTY built-in to set the VALIDATION property 0%
Use the SET_FORM_PROPERTY built-in to set the VALIDATION_UNIT property 0%
Use the SET_FORM_PROPERTY built-in to set the DEFERS_REQUIRED_ENFORCEMENT property 0%
You create the following four menu items for the main menu of a menu module that is attached to a form: Name Label ENTER_QUERY ENTER QUERY EXECUTE_QUERY EXECUTE &QUERY EDIT Edi&t EXIT eXit W...
EDIT 0%
EXIT 0%
ENTER_QUERY 0%
EXECUTE_QUERY 0%
You create the following four menu items for the main menu of a menu module that is attached to a form: Name Label ENTER_QUERY ENTER QUERY EXECUTE_QUERY EXECUTE &QUERY EDIT Edi&t EXIT ����� eXit W...
EDIT 0%
EXIT 0%
ENTER_QUERY 0%
EXECUTE_QUERY 0%
You created a query Record Group at design time. Which built-in can you use to execute the query defined in the Record Group object?
ADD_GROUP_ROW 0%
POPULATE_GROUP 0%
ADD_GROUP_COLUMN 0%
SET_GROUP_SELECTION 0%
You have an EMP block in the Employee.fmb module, which is currently on a content canvas. You want to display items from the EMP block on a new tab canvas. What are two ways to achieve this?
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 0%
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 0%
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 property of each item to Yes. 0%
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. 0%
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 the Tab Page property. 0%
You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to be queried will be decided by the use...
Define a data block based on Ref Cursor 0%
Define a data block based on a Table of Records 0%
Define a data block based on a From Clause query 0%
Define a data block based on a combination of a Ref Cursor and a Table of Records 0%
You need to restrict access to a form. Access must be limited to particular times of day and to certain authorized users. You write a procedure (get_authorization) in the form that checks the usern...
When-Validate-Item on the first enterable item because the form will exit without showing the position of fields on the screen or the accompanying prompts 0%
Pre-Text-Item on the first navigable text item in the first navigable block because this will trap every user and allow time for the message to be read before exiting the form 0%
When-New-Form-Instance at form level because GET_AUTHORIZATION is a restricted procedure and cannot be called from any Pre trigger 0%
Pre-Form at form level because the form will exit immediately after displaying the message in an alert 0%
When-Validate-Item at form level because the message will appear on the message line and must be acknowledged by the user 0%
You start an OC4J instance on your development PC and then run a form from the Forms Builder. Which of the following statements describes the behavior of OC4J?
It appears in the Forms Builder window that can be minimized once OC4J starts 0%
It appears in a separate window that can be closed once OC4J starts 0%
It appears in the Forms Builder window that can be closed once OC4J starts 0%
It appears in a separate window that should not be closed as the OC4J instance will abort 0%
You want to create a calculated item in the Control block of the Human Resource form. This item will contain the total of employee salaries for employees in a particular department. Which statement...
You can create it by first creating a text item and then changing the item type 0%
You can create it in the Layout Editor using a special tool that creates a calculated item 0%
You can create it by first creating a display item and then setting appropriate properties in its Calculation property group 0%
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 selected Salary item. 0%
You want users to be able to add a single value to a list item. How would you do this?
Set the List Style property to combo box. From the When-List-Activated trigger, call the Add_List_Element built-in 0%
Set the List Style property to Tlist. From the When-List-Activated trigger, call the Populate_List built-in 0%
Set the List Style property to poplist. From the When-List-Activated trigger, call the Add_List_Element built-in. 0%
Set the List Style property to combo box. From the When-List-Changed trigger, call the Add_List_Element built-in 0%
Your colleague created a list item that will be populated at run time by the JOBS Record Group. JOBS is populated from the EMP table using one or more of the following three columns: SAL column, wh...
POPULATE_GROUP_WITH_QUERY ('JOBS', 'SELECT distinct initcap(job) as Job,'|| 'job as JOB from emp'); 0%
POPULATE_GROUP_WITH_QUERY ('JOBS', 'SELECT initcap(title) as Job,' || 'sal as Salary from emp'); 0%
rgid := CREATE_GROUP_FROM_QUERY ('JOBS', 'SELECT distinct initcap(job) as Job ,' || 'job as JOB from emp'); 0%
rgid := CREATE_GROUP_FROM_QUERY ('JOBS', 'SELECT initcap(title) as Job.' || 'sal as Salary from emp') 0%