ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what is bulk bind
 Question Submitted By :: Husenaiahb
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is bulk bind
Answer
# 1
Bulk Bind is technique where instead of multiple individual
SELECT, INSERT, UPDATEE & DELETE statements are executed to
retrive from or store data in, at table all of the
opeartions are carried out at once in bulk.

Regard's
Srinivas Ganamur
 
Is This Answer Correct ?    0 Yes 0 No
24/07/07
 
  Re: what is bulk bind
Answer
# 2
Binding of entire collection at once is called as " Bulk 

Bind".
 
Is This Answer Correct ?    0 Yes 0 No
Suresh Somayajula
 
 
 
  Re: what is bulk bind
Answer
# 3
Bulk binding is a way for performance tunning i.e. it will 
complete the whole process in once remove the contaxt 
switching of sql to pl-sql & pl-sql to sql.
 
Is This Answer Correct ?    0 Yes 0 No
Roopesh Kumar
 
  Re: what is bulk bind
Answer
# 4
A DML statement can transfer all the elements of a
collection in a single operation, a process known as bulk
binding. If the collection has 20 elements, bulk binding
lets you perform the equivalent of 20 SELECT, INSERT,
UPDATE, or DELETE statements using a single operation. This
technique improves performance by minimizing the number of
context switches between the PL/SQL and SQL engines. With
bulk binds, entire collections, not just individual
elements, are passed back and forth.
 
Is This Answer Correct ?    0 Yes 0 No
Guru
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy Target3
Whatis yhe use of cursor ? how cursor allocate context area for executing the sql statement? HCL2
How do you get all records from 2 tables. Which join do you use? Microsoft3
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c Oracle4
What are the types of SQL Statement?  2
what is the difference between trigger and storedprocedures Tech-Mahindra9
What is the usage of NVL? Infosys5
Delete duplicate records in the emp table.  5
how do u call in & out parameters for stored procedures? A1-Technology7
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman Satyam2
hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com Wipro2
How will you a activate/deactivate integrity constraints?  1
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.  2
What is the difference between join and union.  10
Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question TCS4
Please let me know if UNION ALL and Natural Join does the same operation and are same... iGate3
What is Referential Integrity? IBM2
Can a view be updated/inserted/deleted?If Yes under what conditions?  3
in materialized view the structure will create immediately or not? iFlex2
State the advatage and disadvantage of Cursor's?  2
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com