Oracle Forms and Reports – Practice Test

Question-Answers

1. How are images stored in database

 
 
 
 

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

 
 

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

 
 
 
 

4. Can a tabbed canvas be placed on a stacked canvas?

 
 

5. How do you access profile values in reports?

 
 
 
 

6. Can you call a database procedure from trigger in Oracle reports?

 
 

7. Which is the report trigger will fire first?

 
 
 

8. _______ flex fields captures the unique information

 
 
 
 

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

 
 
 
 

10. Valid layoutts of the block in Oracle forms are

 
 
 
 

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

 
 
 
 

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

 
 

13. How many minimum groups are required for a matrix report

 
 
 
 

14. Which is the predefined exception available in form 6i

 
 
 
 

15. Select the Sequence of triggers that fire for a Text Item
1) When-New-Item
2) When-Validate
3) Key-Next
4) Pre-Text

 
 
 
 

16. How many content canvases can a form have

 
 
 
 

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

 
 
 
 

18. Which one is not the standard libraries available in template form?

 
 
 
 

19. How to enfore the user to enter value in text item in oracle forms?

 
 
 
 

20. What is Post-Block?

 
 
 
 

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

 
 
 
 

22. When-Validate-Item trigger can have navigational built-ins in them.

 
 
 
 

23. A Data block can be associated with.

 
 
 
 

24. In Oracle Reports, _____ are used to establish parent-child relationships between queries and groups via column-matching

 
 
 
 

25. How are the font, colour are set for an object in oracle forms?

 
 
 
 

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

 
 
 
 

27. can you query data in a control block

 
 

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

 
 
 
 

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

 
 

30. Which text item data properties can restrict whether a user can insert new data?

 
 
 
 

Question 1 of 30

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