GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  Visual Basic
Go To First  |  Previous Question  |  Next Question 
 Visual Basic  |  Question 398 of 453    Print  
what is bulk binding ?

  
Total Answers and Comments: 1 Last Update: December 14, 2007     Asked by: pghare 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 14, 2007 01:02:35   #1  
sutanu_halder Member Since: December 2007   Contribution: 12    

RE: what is bulk binding ?
The assigning of values to PL/SQL variables in SQL statements is called binding. The binding of an entire collection at once is called bulk binding. Bulk binds improve performance by minimizing the number of context switches between the PL/SQL and SQL engines. Typically using bulk binds improves performance for SQL statements that affect four or more database rows. The more rows affected by a SQL statement the greater the performance gain from bulk binds.
 
Is this answer useful? Yes | No

 Related Questions

Difference between a function and a subroutine, Dynaset and Snapshot,early and late binding, image and picture controls,Linked Object and Embedded Object,listbox and combo box,Listindex and Tab index,modal and moduless window, Object and Class,Query unload and unload in form, Declaration and Instantiation an object?

Latest Answer : Data binding is the process that establishes a connection between the application UI and business logic. If the binding has the correct settings and the data provides the proper notifications, then, when the data changes its value, the elements that are ...

Assigning variable with defined memory space. Late Binding - Memory size is allotted in later stage. Ex:- Dim x as object Early Binding - Memory size is allotted while declaring itself. New Key word is 
Latest Answer : There are 2 types of bindingEarly binding, Late bindingEarly bindingDim obj as new classnameObject created during compile timeLate bindingDim obj as objectset obj = new classnameThis binds the object to the particular class at runtime. ...

Generic Variable: Create Object Ex:-Ole-Automation . No need refer the object library. Specific Variable: Binding Procedure Early and Late Binding ( Can be Remove from the Memory).  

Latest Answer : late bindingdim a as objectset a =new server.createobject("adodb.recordset")early bindingdim a as adodb.recordsetset a=new server.createobject("adodb.recordset") ...
Read Answers (2) | Asked by : PG

Latest Answer : The assigning of values to PL/SQL variables in SQL statements is called binding. The binding of an entire collection at once is called bulk binding. Bulk binds improve performance by minimizing the number of context switches between the PL/SQL and SQL ...
Read Answers (1) | Asked by : pghare


 Sponsored Links

 
Related Articles

jQuery - Basic Alphabetical Sorting

Learning jQuery Basic Alphabetical Sorting Now let s perform a sort on the Title column of the table We ll need a class on the table header cell so that we can select it properly geshibot lang html" Title Author s Publish Date Price geshibot mosgoogle To perform the actual s
 

Working with XML in Visual Basic

Working with XML in Visual Basic Extensive markup language and Visual Basic is the odd couple of the industry Visual Basic is one of the most common languages that are being used today This Microsoft introduced language was meant to be middle tier in characteristic but has managed to get the top tie
 

What is Bulk Data Transfer

Bulk data transfer is software-based mechanism designed to move large data file using compression, blocking and buffering methods to optimize transfer times. Every single second of everyday, data moves from computer to another. Some move over the local area network, other over the wide area network
 

SDLC Model Basic Stages

SDLC or the Software Development Life Cycle refers to the steps involved in creating a software from scratch.  During earlier days, software used to be scarce and its creation was comparatively easier.  Developers could create any programs they want and experience no competition. I
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Basic PC Skills

For those that have decided to walk into the world of technology, they may be overwhelmed by the types of knowledge that are available.  There are several code languages and words as well as different areas that you can move into.  If you are a beginner in technology, you can fin
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Scholarship Basic Facts

Scholarship Basic Facts A scholarship is a financial award that is given to students by colleges universities or other organizations The goal of a scholarship is to enhance the education of the student There are a wide variety of scholarships available and each scholarship will require applicants to
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape