Oracle Forms and Reports - Practice Test

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

Some of operation system will have case sensitivity, those OS may not able to get the correct file, for avoiding case sensitivity problem we have to maintain the file name in UPPER case

Only for naming convention

None of the above

2. EXIT_FORM is a restricted package procedure ?

TRUE

False

3. Can one issue DDL statements in oracle forms

Yes by using FORM_DDL

Sometime

May be

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

5. Committed block sometimes refer to a BASE TABLE ?

TRUE

False

6. What are placeholders used for in oracle reports

holding values

holding values at run time

for doing calculations

None of the Above

7. Can you have a form without a Canvas?

Yes

8. Which of the following is not a valid sub-function in oracle forms?

show_view

show_block

show_record

none of the above

9. Which is the first trigger fired when a form is opened

Item level

Form Level

Block Level

none

10. In Oracle Reports, What are the ways by which data can be generated for any parameter’s list of values?

Using static values

Writing select statement.

All of the above

None of the above

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

Post-Update

Post-Insert

Pre-Query

Post-Query

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

set required property to rue

set mandatory property to true

all text items are required

none

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

Raise form_failure

Raise form_error

Raise form_trigger_failure

None of the Above

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

bind

static

None of the above

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

execute_query

execute_block

execute_form

none

16. In Oracle reports, If you want to display or hide the contents of a Frame conditionally, then _________

Create a between pages trigger

Create a format trigger for the frame

Create a before report trigger

Create an After report trigger

17. system variable :system.effective_date is read-only

TRUE

FALSE

18. Which of the following is not a system parameter in Oracle Reports.

Destype

Desname

Desformat

DesIP_Address

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

LOV

Parameters

Local variables

None of the above

20. 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)

21. Can you call a Oracle form from an Oracle reports?

Yes

22. What different status of forms?

New,Query,Changed

Latest,Query,Changed

New,Query,Modified

New,Queried ,Modified

23. Valid layoutts of the block in Oracle forms are

Tabular

Form

A&B

none

24. In Oracle Reports, Queries in are created in

Layout editor

Data model editor

A and B

None of the above

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

set_property

set_item_property

set_item

All the above

26. How can one see the query executed by system while runing execute_query statement

:system.last_query

:system.recent_query

27. what is the difference between key startup and pre-form tiggers

key startup tigger fires after successful navigation into the form and pre-form tigger fires before enter into the form

key startup tiggers fires after successful navigation into the form and pre-form tigger fires before leaving the form

key startup tiggers fires after successful navigation on the first item of the form and pre-form tigger fires before leaving the form

None of the Above

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

SRW.EXEC_SQL

SRW.EXECUTE_SQL

SRW.DO_SQL

All the above

29. How to hide an item from displayed?

change the canvas property to null

change the displayed property to No

Cannot be done

None

30. What are valid program units in Oracle Forms?

procedure

function

package

all the above

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: