Oracle Forms and Reports – Practice Test

1. Can one move FMX file from one Operating system to another operationg system

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

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

4. Which of the following is not a system parameter in Oracle Reports.

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

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

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

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

9. How to display a hint when cursor is moved from one item to another

10. How many radio options can be placed under a radio group

11. Can one issue DDL statements in oracle forms

12. Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

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

14. What is fnd.srwinit ?

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

16. In Oracle Forms, the Database item property is set to ‘no’ if the item is not associated with a base table column

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

18. How many layout triggers are there in a report?

19. In Oracle forms, Name_in is a function which writes values into a field

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

21. How to hide an item from displayed?

22. Valid file extenstion in Oracle reports are?

23. Valid printing direction in Oracle reports are?

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

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

26. What is the correct sequence of registering a form?
a)Go to Application -> menu -> Attach function to menu
b) Define Application -> form
c)FTP from to AU_TOP, generate it and copy to respective TOP
d)Define Application -> function -> give link to form defined in step I

27. What is a collection of requests, request sets and concurrent programs

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

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

30. what are the different types of window in oracle form