Oracle Forms and Reports – Practice Test

1. How many layout can have a report?

2. How to query data in a block at runtime in oracle forsm

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

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

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

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

7. Can a tabbed canvas be placed on a stacked canvas?

8. In Oracle Forms, how many buttons are created on an alert?

9. We can programatically submit the request with the help of ________ API

10. Can you call a stored procedure from a formula column in oracle reports?

11. If you have property class attached to an item and you have same trigger written for the item. Which will fire first?

12. Which of the following is not a valid oracle forms object?

13. How do you group objects to copy to another module?

14. system variable :system.effective_date is read-only

15. How to change the format of frame or item programatically in oracle reprots

16. In Oracle Reports, Precede a bind parameter with a ______ while accessing the parameter in any code

17. Which is the report trigger will fire first?

18. what is the difference between name_in and copy built-ins

19. How many basetable blocks can a form have?

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

21. How to invoke a alter in oracle forms?

22. which of them are valid forms triggers

23. Custom library allows extension of Oracle Applications forms without modification of Oracle applications code

24. ______ is used for customizations such as form, enforcing business rules and disabling fields that are not required for site without modifying standard apps forms

25. which of them are valid report triggers

26. Can you change the default value of the radio button group at run time?

27. What is not the type of windows?

28. In Oracle Forms, The triggers that must fire when all the records are newly inserted and a commit is done are Pre-Insert, On-Insert and _____.

29. Procedures created by forms builder to ensure Master Detail relationship between Master and Detail block are
1)Query_Master_Detail
2)Check_Master_Detail
3) Clear_All_Master_Details
4) Check_Delete_Master

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