D2K - Pre Query & Post Query

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 67 of 71

Pre Query & Post Query

How many times pre query and post query fired when we fetch 10 record from a table ?

Total Answers and Comments: 6

Last Update: May 08, 2009 Asked by: Srikant.db

Sponsored Links

Best Rated Answer

—

Submitted by: viveksis

Pre Query 1 Time - Before Query Post Query each Time ( here 10 Times for all the records fatch by this query)

Above answer was rated as good by the following members:
rahulkumar.it

June 17, 2008 04:47:33

shamkohli

Member Since: June 2008 Contribution: 6

RE: Pre Query & Post Query

They would be fired 10 times each

Is this answer useful? Yes | No

0 3

Overall Rating: -3

June 23, 2008 01:39:13

viveksis

Member Since: January 2007 Contribution: 1

RE: Pre Query & Post Query

Pre Query 1 Time - Before Query Post Query each Time ( here 10 Times for all the records fatch by this query)

Is this answer useful? Yes | No

1 0

Overall Rating: +1

July 17, 2008 23:15:34

karunakaradepu

Member Since: January 2008 Contribution: 3

RE: Pre Query & Post Query

These two are Query based write once U fires the query before the query Pre Query fires only one time when the query executed the 10 rows are executed which means post Query is also fires only one time

Is this answer useful? Yes | No

0 2

Overall Rating: -2

February 24, 2009 05:17:29

rahulkumar.it

Member Since: June 2008 Contribution: 2

RE: Pre Query & Post Query

Pre Query fires only one time before the execution of the query on the other hand Post Query fires after execution of the query and one time for every rows returned. Thus if there are 5 returns rows in a query then Pre Query will fire for 1 time only but Post Query will fire for 5 times.

Is this answer useful? Yes | No

April 09, 2009 15:35:58

samareshp

Member Since: April 2009 Contribution: 24

RE: Pre Query & Post Query

Pre Query 1 Time - Before Query

Post Query n Time ( n Times for n number of records fetch by this query)

Is this answer useful? Yes | No

May 08, 2009 05:14:02

srinivas0808

Member Since: May 2009 Contribution: 1

RE: Pre Query & Post Query

Pre-Query fires one time and Post-Query fires 10 times.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank