Oracle Forms and Reports – Practice Test

1. How many types of canvases are there.

2. Which Triggers are created when Master-Detail relationship is established.

3. What different status of forms?

4. Which parameter cannot be used in FROM clause?

5. Which library we can use to change the profile value?

6. In Oracle reports, The print direction of a repeating frame can’t be _______

7. Is table registration mandatory when we use flexfields and alerts in apps?

8. 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

9. In Oracle forms, the block to which form builder should first navigate is set with ________ property of the form module.

10. In Oracle Reports, The Report layout is created or modified in ______

11. Can a block be created in oracle forms without a base table?

12. How are images stored in database

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

14. What is the fire sequence of between page trigger?

15. What is not the type of windows?

16. Which is the report trigger will fire first?

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

18. In Oracle Reports, a bind parameter is used to replace a single value.

19. What are placeholders used for in oracle reports

20. Which of the following is not a system variable in Oracle Reports?

21. Can a Block be associated to multiple objects like a Table, View or Synonym?

22. _______ determines the horizontal and vertical position of an object

23. Which of the following are valid styles of alert in Oracle forms?

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

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

26. Key next item trigger is common in form level, block level and item level

27. Which one is not the standard libraries available in template form?

28. How many group required for matrix report?

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

30. EXIT_FORM is a restricted package procedure ?