Oracle Forms and Reports – Practice Test

1. In Oracle forms, Stacked and Tab canvasses are always built over a content canvas.

2. Is it possible to change the table name of report query at run time?

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

4. In Oracle forms, if you have a Post-query trigger which populates a non-base table field, what will be record status after querying?

5. If the same property is defined in both Property Class and the Visual Attributes then property value defined in which takes precedence over the other

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

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

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

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

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

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

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

13. How do you access profile values in reports?

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

15. What are valid program units in Oracle Forms?

16. Is it possible calling a report from a report?

17. Which of the following are valid layout formats in Oracle reprots

18. In Oracle Reports, Developers can create 2 types of parameters viz: ____ and lexical parameters

19. Which of the following is not a Oracle Reports layout object?

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

21. How is debugging message displayed in oracle reports

22. which of the following is not a valid oracle reports object?

23. Can one issue DDL statements in oracle forms

24. what is the built-in used to show alert at run time

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

26. Valid layoutts of the block in Oracle forms are

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

28. Can single canvas be used for different blocks

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

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