Oracle Forms and Reports – Practice Test

1. How many group required for matrix report?

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

3. EXIT_FORM is a restricted package procedure ?

4. What is the difference between Per-Query and Post Query?

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

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

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

8. Can a content canvas be placed on a stacked canvas?

9. which of them are valid report triggers

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

11. What are the different types of Delete details we can establish in Master-Details?

12. How to invoke a alter in oracle forms?

13. How do you pass values from one form to another form?

14. Which is the first trigger fired when a form is opened

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

16. How many triggers can a form have?

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

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

19. Which is the predefined exception available in form 6i

20. How many content canvases can a form have

21. How many layout can have a report?

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

23. How many report triggers are there in a Report?

24. In Oracle Reports, Use a ____ parameter, when you want the parameter to substitute any part of the select statement at runtime.

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

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

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

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

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

30. Can text item value be defaulted in oracle forns