Leave a Comment

1. The _______ built-in is used to Exits the current form and enter the indicated form


2. The ___________canvas_view can be used to display items or boilerplate graphics that
operators need to see only in certain situations

Ans: Stacked

3. The ­­________ package contains constructs that provides ways to write and read
information to and from files

Ans: Text_IO

4. On MS-Windows the lookup path for icon files is defined by the _______ environment
variable in the ORACLE.INI file


5. If user receive an error in the ORA-3100 to ORA-3199 range when you try to log on to
Developer/2000 product, there may not be enough real-mode memory to establish a
Communication buffer with an Oracle server.______________ solves this problem by
reserving memory for server communications.


7. The ____________ property is used When queried records have been marked for inserts
, updates, specifies that only columns whose values were actually changed which should
be included in the SQL UPDATE statement that is sent to the database during a

Ans: Update Changed Columns.

8. The _________ property specifies whether Oracle Forms should validate the value of
the text item against the values in the attached LOV.

Ans: LOV for Validation

9. A _____________ is an internal Oracle Forms data structure that has the column/row
frame work similar to a database.

Ans: Record Group.

10. There a three types of Record Group they are___________________________.

Ans: Static, Query record group, Non_query record group.

11.The ______ built-in is used to write data in the Forms to the Database, but does not
perform a database Commit.

Ans: Post.
12. Two types of Windows are _________________________

Ans: Document Window and Dialog Window.

13. The _____________ built-in is used to copy the values of each item in the record with
the next lower sequence number to the corresponding item in the current record.

Ans: Duplicate record.

14. An _______ is a container for a group of objects that can be used to copy or reference
them in another module.

Ans: Object Group.

15. Form the Firing hierarcial for the Given triggers

a] When-New-Item-Instance
b] When-validate-Item
c] Key-Next-Item Ans: F,A,C,D,B,E.
d] Post-change
e] Post-Text-Item
f] Pre-Text-Item

16. Form the hierarchial for the Given Triggers

a] When-New-Record-Instance
b] Pre-Record
c] Post-Record
d] When-Validate-Item
e] When-Create-record Ans: E,B,A,D,C.

17. Use an _________ Trigger for the following purposes:

a] To trap and respond to an informative message.
b] To replace a standard informative message with a custom message.
c] To exclude an in appropriate message. Ans: On_Message.

18. Oracle Forms performs the following steps when the ______ trigger fails

a] Sets the error location
b] Rolls back to the recently issued Savepoint
Ans: On_Update or On_Insert or Pre_Insert or Pre_update or Post_Insert or

19. The _____ command is used to Execute the indicated Operating System Command.

Ans: Host.

20. The maximum Number of Procedures and Functions in a Package is _____.

Ans: 255.

21. Oracle uses work areas called ______ to execute SQL Statement and store processing

Ans: Private SQL Area.

22. Two Types of Cursors are ______________________.

Ans: 1] Implicit Cursor, 2] Explicit Cursor.

23. The variables declared in a subprogram specification and referenced in the subprogram
body are____ parameters. Ans: Formal.

24. The __________ and ___________ are called Assignment Statements.

Ans: 1] Select .. into .. 2] Fetch .. into .. 3] :=


Post a Comment