quote:

---

Originally posted by rsuresh13
pls mail me at phen2k2@rediffmail.com


01. The users request that [F2], [F3], and [F4] be used to commit, rollback, and exit, respectively. How do you accomplish this?

a. Add the appropriate PL/SQL code for each key
b. Map the logical keys to the physical keys, then add the appropriate PL/SQL code for each key
c. Create an object library to define the key triggers, then reference the object library in the form
d. This cannot be accomplished because other function keys provide this functionality by default

02. You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface.

Which reusable component do you use?

a. ActiveX controls
b. Calendar class
c. Standard Object Library
d. Picklist Class
e. Wizard Class
f. Navigator Class

03. Examine this code:

BEGIN
IF :SYSTEM.EVENT_WINDOW = 'WELCOME' THEN
DO_KEY('EXIT_FORM');
ELSE MESSAGE('ILLEGAL OPERATION');
END IF;
END;
In which form level trigger would you implement this?

a. WHEN-WINDOW-CLOSED
b. WHEN-WINDOW-CHANGED
c. WHEN-WINDOW-RESIZED
d. WHEN-WINDOW-ACTIVATED

04. What are three characteristics of the CALL_FORM built-in? (choose three.)

a. It is an unrestricted procedure
b. It is valid in Enter Query mode
c. It invokes a form in a modal window
d. It can only invoke a form in Query Only mode
e. It enables you to start a new database session
f. It enables free navigation between all opened forms in an application

05. Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?

a. CYCLE
b. ITERATE
c. NO_REPEAT
d. REUSE

06. Which statement about windows and blocks is true?

a. Transaction management is window-oriented rather than block-oriented
b. Forms automatically navigates to an item located in an activated window
c. Windows may contain items from multiple blocks, and the block's items may be located on several windows
d. A window can contain multiple canvases, and an item can be located on multiple canvases

07. What is an example of a dynamic SELECT statement?

a. a query whose object names change during its execution
b. a query whose object names are not known until run time
c. a query whose bind variable values change during execution
d. a query whose bind variable values are not known until run time

08. Which two triggers are mouse movement triggers? (choose two.)

a. When-Mouse-Up
b. When-Mouse-Move
c. When-Mouse-Down
d. When-Mouse-Click
e. When-Mouse-Leave

09. What is a use for the SET_TIMER built-in?

a. retrieve the timer ID
b. change the timer name programmatically
c. determine what to do upon timer expiration
d. set the repeat behavior without changing the time interval

10. Which trigger property applies to Key triggers?

a. Hide Keys
b. Show Menu Keys
c. Hide Menu Keys
d. Display in 'Keyboard Help'
e. Hide Keys Description

---