Home » Developer & Programmer » Forms » Pls Required Answer...
Pls Required Answer... [message #313850] Mon, 14 April 2008 22:07 Go to next message
ranairfan_1
Messages: 2
Registered: April 2008
Location: Pakistan
Junior Member
hi,
Dear All pls required answer of these questions.

QUESTION 1

You have been asked to define a data block based on the result of a SQL query and of PL/SQL function that return summary data. The data can be updated by the user.
How should you define an appropriate data source?
A. Define a data block based on a Ref Cursor.
B. Define a data block based on Table of Records.
C. Define a data block based on a Form Clause query.
D. Define a data block based on a combination of a Form Clause query and a Table of Records.
E. Define a data block based in a Form Clause query and a Ref Cursor for controlling DML statements.

Answer:

QUESTION 2

Which three statement best describe a Ref Cursor in Forms Builder? (Choose three)
A. A stored procedure that uses a Ref Cursor can be used only as a query datasource for a data block.
B. A stored procedure that uses Ref Cursor can be used only as a DML datasource for a data block.
C. A stored procedure that uses Ref Cursor can be used as both a query and a DML datasouece for a data block.
D. A Ref Cursor is ideal for queries that are dependent only on PL/SQL and not SQL statements.
E. A Ref Cursor enables you to query multiple tables and encapsulate logic in a PL/SQL subprogram.
F. A Ref Cursor is used by a stored procedure to return data to a data block.

Answer:

QUESTION 3

In the Products. Fmb module, a trigger currently fires each time you navigate to any item in the Product data block. You want to make a change so that the trigger fires only when you navigate to a specific item
What change should you make to the trigger to correct this behavior?
Change the Trigger scope from Block to Form.
A. Change the Trigger scope from Block to Item.
B. Change the Trigger scope from Form to Item
C. Change the Trigger scope from Form to Block.
D. Change the Trigger scope from Item to Block.
E. Set the Trigger Execution Hierarchy property to After.
F. Set the Trigger Execution Hierarchy property to Before.

Answer:

QUESTION 4

You have been asked to define a data block based on a query that is dependent on SQL only. The data will not be updated by the user. Selection of the tables to by queried will be decided by the userĘs at run time. How should you define the appropriate data source.
A. Define a data block based on Ref Cursor.
B. Define a data block based on a Table of Records.
C. Define a data block based on a from Clause query.
D. Define a data block based on a combination if a Ref Cursor and a Table of Records.
E. Define a data block based on a from Clause query and define Transactional triggers for controlling DML statements.

Answer:

QUESTION 5

Number of Records displayed 10
Number of Records Buffred 50
The EMPLOYEES table contains 100 records. You are developing a Human Resources form that has an Employee block with properties as above.
When you run the form and execute a query in the Employees block, approximately how many network rounds trips will be made to the server before records are displayed in the block?
A. 1
B. 2
C. 10
D. 50
E. 100

Answer:


Regards,
Irfan

Re: Pls Required Answer... [message #313971 is a reply to message #313850] Tue, 15 April 2008 06:32 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Homework, or is this for an interview?
Re: Pls Required Answer... [message #314179 is a reply to message #313850] Tue, 15 April 2008 23:52 Go to previous message
ranairfan_1
Messages: 2
Registered: April 2008
Location: Pakistan
Junior Member
Sir, for OCP Exam.
Previous Topic: forms running very slowly.
Next Topic: FORMS LOADING SLOW
Goto Forum:
  


Current Time: Sat Dec 03 18:25:17 CST 2016

Total time taken to generate the page: 0.08015 seconds