Oracle Forms and Reports - Practice Test

1. How can we execute the query in the report trigger?

SRW.EXEC_SQL

SRW.EXECUTE_SQL

SRW.DO_SQL

All the above

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

Primary Key

Update Allowed

Query Allowed

Insert Allowed

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

root and secondary

primary & secondary

modal and secondary

None of the Above

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

Visual Attributes

Property Class

Same precedence

None of the above

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

TRUE

False

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

Item level trigger

Property level trigger

Form level trigger

None of the above

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

By using APPCORE library.

By using APPDAYPK library

By using CUSTOM library

8. Key next item trigger is common in form level, block level and item level

TRUE

False

9. Valid printing direction in Oracle reports are?

zigzag

down

across

B & C

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

TRUE

False

11. How to change the format of frame or item programatically in oracle reprots

set_item_property

set_property

format trigger

none

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

Yes

13. Can single canvas be used for different blocks

yes if we have master-details relationship both can be displayed on the same canvas

14. can you query data in a control block

Yes

15. What type of canvases are available in Oracle Forms

tabbed

stack

content

all the above

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

Yes

17. Name the directory having the FORMS source codes ( FMB files ) ?

AU_TOP forms directory

FND_TOP

None

18. In Oracle forms, the _______ block property can be used to sort the records queried from the database

SORT clause

ORDER BY clause

All of the above

None of the above

19. In Oracle reports, The print direction of a repeating frame can’t be _______

Down

Across

Across/Down

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

TRUE

False

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

Yes

Not applicable

22. What is Post-Block?

Navigational Trigger

Key trigger

Transaction Trigger.

None of the above

23. What is SECURE property?

Hides characters that the operator types into the text item. This setting is typically used for password protection

You can restrict delete option using this property.

You can secure your form using this option.

None of the above

24. Which of the following are valid extension in Oracle Forms

fmb

fmt

A&B

None

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

Yes

No as fmx files are machine dependent files while FMB files are not

Depends on the Version

None of the Above

26. What is fnd.srwexit ?

It allows oracle AOL user exits to detect that they have been called by oralce reports. Called from before report trigger.

Used to release all the memory alocated by oracle AOL, used in after report trigger.

None of the above

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

visual attributes

Property Class

sub-routine

none

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

Yes

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

30. Committed block sometimes refer to a BASE TABLE ?

TRUE

False

Question 1 of 30

Upload your own post and refer it anywhere anytime:

Upload your own post

Oracle Forms and Reports – Practice Test

Like this:

Share this post:

Like this: