Oracle Forms and Reports – Practice Test

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

 
 
 
 

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

 
 
 

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. 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. How many layout triggers are there in a report?

 
 
 

6. How can you change the select statement of a query at run time?

 
 
 
 

7. which of the following are valid object in oracle forms

 
 
 
 

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

 
 
 
 

9. Can single canvas be used for different blocks

 
 

10. Valid file extenstion in Oracle reports are?

 
 
 
 

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

 
 

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

 
 
 
 

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

 
 
 
 

14. What is the fire sequence of between page trigger?

 
 
 
 

15. How many stacked canvases can a forms have?

 
 
 
 

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

 
 

17. Can a PL/SQL library be attached to a form as well as report?

 
 

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

 
 

19. A Data block can be associated with.

 
 
 
 

20. Which is the report trigger will fire first?

 
 
 

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

 
 
 
 

22. Which library we can use to change the profile value?

 
 
 
 

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

 
 

24. How are images stored in database

 
 
 
 

25. In Oracle Forms, Data blocks can be created from _______ and Stored Procedure

 
 
 
 

26. What is an LOV?

 
 
 
 

27. How can you change the default menu bar action?

 
 
 

28. How many layout can have a report?

 
 
 
 

29. CALL_FORM can calls the other form by which the parent form will be inactive

 
 

30. Can you call a Oracle report from an Oracle form?

 
 

Question 1 of 30

Related posts: Upload your own post and refer it anywhere anytime: