Oracle Forms and Reports – Practice Test

1. Why we have to maintain the file names in Capital Letter? ( Library/FMB)

2. What is the sequence of firing tigger in form of
1)Pre-form
2)Pre-block
3) When-new-form
4)When-validate-item 5)Post-block

3. Which sub-routine is used to invoke alter in oracle forms

4. How many basetable blocks can a form have?

5. Can one issue DDL statements in oracle forms

6. In Oracle forms a block can be based on the following objects?

7. What are valid program units in Oracle Forms?

8. How many times a pre query and post query tigger gets fired for detail block in Master-Detail relationship

9. Select the Sequence of triggers that fire for a Text Item
1) When-New-Item
2) When-Validate
3) Key-Next
4) Pre-Text

10. A _____ is a field made up of segments so that each segment has a name and a set of valid values

11. Which of the following property determines the type of an item.

12. Name the directory having the FORMS source codes ( FMB files ) ?

13. Can you attach a library to more than one form

14. What different status of forms?

15. In Oracle Forms, Data blocks can be created from _______ and Stored Procedure

16. While specifying master/detail relationship between two blocks specifying the join condition is a must ?

17. What are placeholders used for in oracle reports

18. In Oracle forms, the _______ block property can be used to sort the records queried from the database

19. Is the statement true “No of records displayed property of block can be set programtically in Oracle forms”?

20. The value recorded in system.last_record variable is of type

21. Can you call a Oracle form from an Oracle reports?

22. Valid layoutts of the block in Oracle forms are

23. How many content canvases can a form have

24. What is the correct sequence of registering a report?
a) Register concurrent -> program -> Define
b) Attach it to appropriate request group security -> responsibility -> Request
c) Register concurrent -> Program ->executable
d) FTP RDF in respective top/report/US

25. what is the difference between key startup and pre-form tiggers

26. In Oracle Reports, What are the ways by which data can be generated for any parameter’s list of values?

27. In Oracle forms, which information can’t be passed from one form to another form?

28. CALL_FORM can calls the other form by which the parent form will be inactive

29. How to invoke a alter in oracle forms?

30. Which of the following function is used to check if a Parameter List is created or not.