| 1. | SMITH was running a form in the debug mode and begins to step through the code of a lengthy subprogram. After stepping through a few lines of its code, he realized that the error came not from the code in that particular subprogram but from code that is executed after it. At this point, how can he jump to the next line of code after the call to the subprogram? |
| a. | | Clicking Step Over to step over the execution of the subprogram |
| b. | | Opening the Stack panel, selecting the previous stack frame, and clicking Go |
| c. | | Clicking Step Out to resume stepping through code after the subprogram is called |
| d. | | HE cannot do this in the same debug session. He should click Stop, set a breakpoint immediately after the subprogram code is called, and run the form in debug mode again
|
|
|
|
|
|
|
| 2. | What type of message indicates a Forms message that cannot be suppressed? |
| a. | | A Busy message |
| b. | | A level 0 message |
| c. | | A Working message |
| d. | | A level 25 message |
| e. | | A level 50 message |
| f. | | A message with a level less than 0 |
| g. | | A message with a level greater than 25
|
|
|
|
|
|
|
| 3. | An application uses a menu that contains a Check type Menu Item. Which built-in should be used to programmatically toggle the checked/unchecked state of the Check item. |
| a. | | FIND_MENU_ITEM |
| b. | | GET_ITEM_PROPERTY |
| c. | | SET_ITEM_PROPERTY |
| d. | | SET_MENU_ITEM_PROPERTY |
| e. | | GET_MENU_ITEM_PROPERTY
|
|
|
|
|
|
|
| 4. | A menu was created for the Summit Office Supply applications that was attached to its main form. The menu, whose Menu Editor, contains the following submenus:
Applications, displaying a choice of forms to invoke Customers, displaying menu items for the Customers form Orders, displaying menu items for the Orders form HR, displaying menu items for the HR form The Main Menu property for the menu is set to Applications.
When the user chooses from the Applications submenu to invoke another form, which built-in can be used to display the appropriate menu items for that form? |
| a. | | FIND_MENU |
| b. | | REPLACE_MENU |
| c. | | FIND_MENU_ITEM |
| d. | | SET_FORM_PROPERTY |
| e. | | SET_MENU_ITEM_PROPERTY
|
|
|
|
|
|
|
| 5. | A form was being developed that serves as a front end to access the Order Entry application. Within the form, the usernames of those users should be stored who have permissions to run the application. This information is accessed when the form starts up to determine if the user is authorized. The list of usernames is not stored in the database and should not be visible to users. How should this information be stored? |
| a. | | In a list item |
| b. | | In a list of values |
| c. | | In a set of parameters |
| d. | | In a record group
|
|
|
|
|
|
|
| 6. | Which of the following statements are correct with regard to Query Record Group? |
| 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
|
|
|
|
|
|
|
| 7. | A query Record Group was created at design time. Which built-in can be used to execute the query defined in the Record Group object? |
| a. | | ADD_GROUP_ROW |
| b. | | POPULATE_GROUP |
| c. | | ADD_GROUP_COLUMN |
| d. | | SET_GROUP_SELECTION
|
|
|
|
|
|
|
| 8. | Which of the following helps in programmatically determining the button a user pressed to respond to an alert? |
| 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
|
|
|
|
|
|
|
| 9. | There is a requirement to invoke the Orders form from the Customers form. Which of the following suggestions names a built-in that will meet the requirements and also offers a correct reason? |
| 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
|
|
|
|
|
|
|
| 10. | The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. A Human Resource application is being developed. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record. The HR clerks have requested that a button be placed on the form to enable them to invoke the Departments form to enter the new department and save it independently. They want to be able to return to the Employees form and decide whether or not to save the new employee record. How should the When-Button-Pressed trigger be coded to achieve this? |
| 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);
|
|
|
|
|
|
|
| 11. | Consider the following scenario: In a multiform application, the user started in FormA.
From FormA, the user invoked FormB using CALL_FORM. From FormB, the user invoked FormC using OPEN_FORM. From FormC, the user invoked FormD using OPEN_FORM. From FormB, the user invoked FormE using CALL_FORM.
There is an additional form in the application, called FormF. Which statement is true? |
| a. | | FormF can be invoked from FormC using CALL_FORM. |
| b. | | FormF can be invoked from FormA using OPEN_FORM. |
| c. | | FormF can be invoked from FormD using CALL_FORM. |
| d. | | FormF can be invoked from FormE using CALL_FORM. |
| e. | | FormF can be invoked from FormB using OPEN_FORM.
|
|
|
|
|
|
|
| 12. | Which of the following statement is correct with regard to client-side validation? |
| 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
|
|
|
|
|
|
|
What others think about Free Oracle OCP Practice Test - Oracle 9i Form OCP Test |
| By: Oliver Ferguson on Oct 18, 2009 |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |
| By: sudha on Sep 16, 2009 |
| | i am taking the exam day after tomo.. so just wanna give it a shot .. |
|
 |