Oracle Forms and Reports – Practice Test

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

2. In Oracle forms can you check whether an object exists or not

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

4. How do you access profile values in reports?

5. What is fnd.srwexit ?

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

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

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

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

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

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

12. How can we execute the query in the report trigger?

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

14. Report Designer has file extension as _______.

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

16. After parameter form trigger will fire before the parameter form

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

18. In Oracle forms, which block property can be set programmatically?

19. A Data block can be associated with.

20. A _______ class is a named object that contains a list of properties
and their settings

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

22. How are images stored in database

23. How many types of canvas are there in a form?

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

25. Which of the following is not an Oracle Reports built-in package?

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

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

28. In Oracle Reports, _____ determines the hierarchy of the data appearing in a report, and are used primarily to create breaks

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

30. what are valid program units in Oracle Reports?