Oracle Forms and Reports – Practice Test

1. How many stacked canvases can a forms have?

2. What is SECURE property?

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

4. A query fetched 10 records How many times does a PRE-QUERY Trigger

5. which of them are valid forms triggers

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

7. Is the statement true “No of records displayed property of block can be set programtically in Oracle forms”?

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

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

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

11. How do you access profile values in reports?

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

13. Can you have a form without a Canvas?

14. In oracle report, If there are 10 pages in the report, then how many times the between pages trigger would fire?

15. Object group have a block

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

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

18. Can you call a database procedure from trigger in Oracle forms?

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

20. Why we have to maintain the file names in Capital Letter? ( Library/FMB)

21. In Oracle forms, the block to which form builder should first navigate is set with ________ property of the form module.

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

23. Which parameter cannot be used in FROM clause?

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

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

26. In Oracle Reports, the between pages trigger fires for which of the following events?

27. Can we write format trigger in a repeating frame?

28. How many parameter’s a concurrent program can take? (Maximum)

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

30. In Oracle reports, A frame prints once for each record retrieved.