Oracle Forms and Reports – Practice Test

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

2. How many types of canvases are there.

3. Can a LOV created in Oracle Forms dynamically

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

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

6. Can a record group be created dynamically in Oracle Forms

7. Is it possible to call a form from report?

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

9. Which is a container of valid values to its segments.

10. A _______ is an argument to pass parameters from oracle reports to oracle applications

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

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

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

14. What are the valid file extension Oracle libraries?

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

16. What are the mandatory parameters when we write concurrent program using stored procedures?

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

18. In Oracle Reports, What type of columns will be used as an empty container to be populated from another object?

19. How is value defaulted in a text item in Oracle forms?

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

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

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

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

24. which of them are valid forms triggers

25. Can you have more item then the columns of a table in a base table block

26. Can window property be changed at runtime in Oracle forms?

27. Valid file extenstion in Oracle reports are?

28. Which built-in is used to change item property at run time

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

30. A tab canvas can contain more than one page?