| Pls Required Answer... [message #313850] |
Mon, 14 April 2008 22:07  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
