KyaPoocha.com

Huge Collection of Interview Questions

Search our list of 7708 Interview Questions


What are the functions of Bind ? 

Posted in Database Interview Questions

BIND mainly performs two things syntax checking and authorization checking.It binds together all packages into an application plan hence the name BIND.Apart from this bind has optimiser as a subcomponent.Its function is to determine the optimum access strategy.

Post Your Answer!
Send This to a Friend

← What is the difference between join and union ?
what’s the best lock size that you could use when you create a tablespace ? →

If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!


BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |

Related Interview Questions

  • Explain functions as object constructors?  03.12.08

    If you prefix a new with a function call creates a new object and you can call that functions with a local keyword which is attached to that object. Object prot...

  • Explain about mixed and callback functions?  17.11.08

    Mixed function indicates that the function may contain multiple types but it doesn’t form a necessary condition. Functions like call_user_func() or usort() ac...

  • What does CURRENTDATA option in bind indicate ?  26.03.08

    CURRENTDATA option ensures block fetch while selecting rows from a table. In DB2V4 the default has been changed to NO. Therefore it is necessary to change all t...

  • What are the advantages of using a PACKAGE ?  16.03.08

    The advantages of using PACKAGE are: 1. Avoid having to bind a large number of DBRM members into a plan 2. Avoid cost of a large bind 3. Avoid the entire tra...

  • When do you specify the isolation level ?  14.03.08

    During the BIND process(ISOLATION LEVEL is a parameter for the bind process).  ISOLATION ( CS/RR )......

  • What is a DB2 bind?  07.03.08

    Bind is a process that builds “access paths” to DB2 tables. A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2 pre-compile step as input an...

  • What is overloading??  01.05.07

    With the C++ language, you can overload functions and operators. Overloading is the practice of supplying more than one definition for a given function name in...

  • What are the advantages of the functions?  22.03.06

    Debugging is easier It is easier to understand the logic involved in the program Testing is easier Recursive call is possible Irrelevant details in the us...

  • What is JavaServer Faces _expression language  11.03.06

    A simple _expression language used by a JavaServer Faces UI component tag attributes to bind the associated component to a bean property or to bind the associat...

  • What is a protocol class?  09.03.06

    An abstract class is a protocol class if:- It neither contains nor inherits from classes that contain member data, non-virtual functions, or private (or protec...