Saturday, March 06, 2010

Forms Interview Questions

Forms 6i -Questions
1. Can you change the mouse pointer ?

A. Yes
B. No
C. None
Answer : A
Description :
Yes. Specifies the mouse cursor style. Use this property to dynamically change the shape of the cursor.

2) Can you have VBX and OCX controls in forms ?

A. No
B. Yes
C. None

Answer : B




3. What is Current record attribute property?

A. Specifies the name of the .FMX file of the form currently being executed.

B. Specifies the number of the current record in the block's list of records..

C. Specifies the number of the current record in the block's list of records..

D. Specifies the name of the current form, as indicated by the form module
Name property.

Answer : B

Description :
Specifies the number of the current record in the block's list of records.
Applies to Block

4. Can you port applictions across the platforms? how?

A. No
B. Yes
C. Depends on Platform used
D. None

Answer : B
Description
Yes We can port applications across platforms.Consider the form developed in a windows system.The form would be generated in unix system by using f60gen my_form.fmb scott/tiger

5. Following one is a Property of Call_Form.

A. opens a separate, independent form

B. replaces the current form with a different form

C. calls a modal form

D. None

Answer : C
Description :
Runs an indicated form while keeping the parent form active. Form Builder runs the called form with the same Runform preferences as the parent form. When the called form is exited Form Builder processing resumes in the calling form at the point from which you initiated the call to CALL_FORM.

6. How many types of Canvases are available in Forms?

A. Three
B. Two
C. One
D. Four

Answer : D
Description :
There are four types of Canvases available.
Stack,Content,Vertical Toolbar Canvas and Horizontal Toolbar Canvas

7. Can a button have icon and lable at the same time ?

A. Yes
B. None
C. No
D. Depends on icon type

Answer : C


8. Which of the Following statement is Valid for static group?

A. A Record group that has an associated SELECT statement

B. A Record group that is not associated with a query; rather, you define its
structure and row values at design time, and they remain fixed at
runtime.

C. A Record group that is a group that does not have an associated query, but whose structure and values can be modified programmatically at runtime

D. Non of the above.

Answer : B
Description
A static record group is not associated with a query; instead, you define its structure and row values at design time, and they remain fixed at runtime.Static record groups can be created and modified only at design time.

9. What is the Sequence of Trigger Firing in Forms?

A. First Item, then Block and then Form Level

B. First Form Level, Block Level then Item Level

C. First Block Level, Then Form Level then Item Level

D. There is no such sequence of firing

Answer : A
Description
Triggers at the lowest level are always given the first preference. The item level trigger
fires first and then the block and then the Form level trigger.

10. What is a Secure Property?

A. Hides characters that the end user enters for the substitution parameter.

B. Displays characters that the end user enters for the substitution Parameter


C. Determines whether Form Builder hides the window automatically when the end user navigates to an item in another window

D. makes the current menu disappear

Answer : A
Description :
Hides characters that the end user enters for the substitution parameter.




11. How many types of Window Styles are available in Forms?

A. One
B. Two
C. Three
D. Four
Answer : B
Description :
There two types of Window Styles one is Dialog and another is Document





12. Can you issue DDL in forms?

A. Yes
B. No
C. None


Description
yes, but you have to use FORMS_DDL.





13. Say, you have created al named alert_info.
How many alert buttons will be available for alert buttons?

A. Two
B. One
C. Three
D. Can define any n numbers of buttons

Description :
Three buttons.





14. In Record Group Total Number of Columns should not exceed..

A. 32k
B. 128 K

C. 16 K

D. 64 K


Answer : D



15. System variable :System.Record_status Defines

A. Represents the status of the record where the cursor is located.

B. Represents the status of a Data block where the cursor is located, or the current data block during trigger processing

C. Status of Current form

D. None

Answer : A




16. POST built-in is used to

A. Writes data in the form to the database, but does not perform a database commit. Form Builder first validates the form

B. Causes Form Builder to update data in the database to match data in the form.

C. Form Builder rolls back uncommitted changes (including posted changes) to the last save point.

D. Form Builder does not issue a rollback, and posted changes are preserved

Answer : A

17. Executable Forms Menu File has an extension

A. .mmb
B. .mmx
C. .fmb
D. .fmx



Answer : B


18. SYSTEM.MESSAGE_LEVEL stores one of the following message severity levels

A. 0,10,15
B. 0,10,15,20
C. 0
D. 0,10,15,20,25


Answer : D


19. To get the name of the Operating System on which application is running, following built-in is used.

A. GET_CUSTOM_PROPERTY
B. GET_OS_PROPERTY
C. GET_APPLICATION_PROPERTY
D. GET_FORM_PROPERTY


Answer : C




20. Can Forms be connected to SQL SERVER?

A. Yes
B. No
C. None

Answer : A




21. Is Forms 6i is Object Oriented Tool?

A. No
B. Yes
C. None




Answer : B



22. Can object group have a block

A. Yes
B. No


Answer : A




22. Can you call WIN-SDK thruo' user exits?


A. No
B. Yes
Answer : B

24. Does user exits supports DLL on MSWINDOWS ?

A. YES
B. NO


Answer : A




25. Query System Mode Indicates

A. Indicates that the form is currently in normal processing mode.
B. Indicates that the form is currently in Enter Query mode.
C. Both A and B
D. Indicates that the form is currently in fetch processing mode, meaning that a query is currently being processed.


Answer : D


26. How many types of System Modes are available?

A. One
B. Four
C. Three
D. Two

Answer : C
Normal,Enter-Query and Query these three modes are available.




27. In Release 5.0 and later, cursor mode is handled automatically by Form Builder. Is it True?

A. Yes
B. No

A

In Release 5.0 and later, cursor mode is handled automatically by Form Builder. This property is now obsolete, and should not be used. In particular, cursor mode should never be set to Close. The following information is provided only for historical and maintenance purposes.






28. Whats the Use of Delayed Locking Mode Property?

A. Form Builder locks the row only while it posts the transaction to the database, not while the end user is editing the record. Form Builder prevents the commit action from processing if values of the fields in the block have changed when the user causes a commit action.

B. Identical to Immediate if the datasource is an Oracle database. For other datasources, Form Builder determines the available locking facilities and behaves as much like Immediate as possible.

C. Form Builder locks the corresponding row as soon as the end user presses a key to enter or edit the value in a text item.

D. All Above


Answer : A





29. CREATE OR REPLACE FUNCTION set_budget

(v_studio_id IN NUMBER, v_new_budget IN NUMBER) IS
BEGIN
UPDATE emp
SET sal = v_new_budget
WHERE empno = v_studio_id;
IF SQL%FOUND THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
COMMIT;
END;

Which code must be added to successfully compile this function?

A.Add "RETURN;" right before the "IS" keyword.
B.Add "RETURN number" right before the "IS" keyword.
C.Add "RETURN boolean" right after the "IS" keyword.
D.Add "RETURN boolean" right before the "IS" keyword.



Answer : D

30. The function ID_NULL that is used to test whether the object id is
Available or not, the function returns which of the following value?

A. Varchar2
B. Number
C. Boolean
D. Char
Answer: C
Returns a BOOLEAN value that indicates whether the object ID is available.
You can call this function to test results of the following object ID types like alert, blocks

No comments:

Post a Comment