Oracle Forms and Reports - Practice Test

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

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

3. How many no of columns can a RECORD GROUP have?

None of the above

4. Can text item value be defaulted in oracle forns

yes

5. In Oracle Forms, If the not null constraint is defined, the _________ property is set to true.

Datatype

Required

Enabled

Automatic skips.

6. Which is the report trigger will fire first?

Before Report Trigger

Before Parameter Form Trigger

Before Parameter Trigger

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

SRW.EXEC_SQL

SRW.EXECUTE_SQL

SRW.DO_SQL

All the above

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

Yes

9. How many layout can have a report?

One

Two

No Restriction

Six

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

text item

display item

check box

all the above

11. What is Post-Block?

Navigational Trigger

Key trigger

Transaction Trigger.

None of the above

12. While specifying master/detail relationship between two blocks specifying the join condition is a must ?

TRUE

False

13. In Oracle forms, Stacked and Tab canvasses are always built over a content canvas.

TRUE

False

14. How many times a pre-query trigger executed for a block of 10 records in oracle forms?

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

Group

Text item

block

trigger

16. How do you access profile values in reports?

:$PROFILE$.Name

:$PROFILE$.Profile Name

:$PROFILE$.Pfl Name

None of the above

17. How do you group objects to copy to another module?

object group

record group

sub class

none

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

unlimited (actually unlimited but maximum of 6 radio options are preferred more then that we go for list items etc)

19. How many stacked canvases can a forms have?

No Restriction

20. Committed block sometimes refer to a BASE TABLE ?

TRUE

False

21. Of the following which is not an executable method in Oracle Apps?

Host

Immediate

Oracle Forms

Oracle Reports

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

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

fmb

fmt

A&B

None

24. What is not the type of windows?

Root window

.Find_Window

None of the above

25. In Oracle forms, A global variable is active and accessible within a _______

Form

Session

Block

None of the above

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

LOV

Parameters

Local variables

None of the above

27. can you query data in a control block

Yes

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

set initial value property to the contanst vaue

cannot set default values for text item

set default value property

none

29. In Oracle Reports, _____ determines the hierarchy of the data appearing in a report, and are used primarily to create breaks

Summary Columns

Place holder columns

Formula Columns

Groups

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

By using APPCORE library.

By using APPDAYPK library

By using CUSTOM library

Loading …

Question 1 of 30

Oracle Apps Procure To Pay Cycle (P2P Cycle)
Oracle Apps Order Management Tables
Oracle SQL PLSQL Interview Questions
Oracle EBS - Order Management Interview Questions
Oracle Forms and Reports - Practice Questions
Oracle Forms and Reports - Practice Questions -2
Oracle Forms and Reports - Practice Test
Oracle Forms and Reports - Practice Questions
Oracle Reports Frequently Asked Questions (FAQ)/ Oracle Reports Interview Questions