|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions A DB2 bind is a process that builds an access path to DB2 tables. Latest Answer : A BIND process establishes a relationship between an APPLICATION PROGRAM and its RELATIONAL DATA. ... An application plan or package is generated by the bind to define an access path. Latest Answer : DB2 plan is executable form of sql staements(DBRM).you can define DB2 plan as set of pointers to packages. And package contains machine code of best access paths. ... An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row. Latest Answer : Cursor is a Context Area. where which can process multiples rows. ... To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously. A NULL value takes up one byte of storage and indicates that a value is not present as opposed to a space or zero value. It's the DB2 equivalent of TBD on an organizational chart and often correctly Latest Answer : A NULL value is different from a blank or a zeroA NULL value can be inserted into columns of any data typeA NULL value will evaluate to NULL in any expression (e.g.NULL multiplied by 10 is NULL)If a column has a NULL value, Oracle ignores any UNIQUE, ... Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time? Never. Such processing could produce duplicate values violating entity integrity. Primary keys must be updated one at a time. For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently. Latest Answer : Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index ... The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It's Y2K compliant). Latest Answer : DATE PIC X(10)TIME PIC X(8)TIMESTAMP PIC X(26) ... Deadlock occurs when transactions executing at the same time lock each other out of data that they need to complete their logical units of work. What are the four lockable units for DB2? Latest Answer : The 4 lock units are Row, Page, Table (if segmented), and Table space. Christine Pastor ... SQL statements may return any number of rows, but most host languages deal with one row at a time by declaring a cursor that presents each row at a unique isolation level. Latest Answer : Isolation Level determines the duration of the lock over a page.3 level are there.1. Cursor Stability : lock is retained when untill the cursor moves from one record in one page to the next record in another page. Provides WRITE Integrity.2. Repeatable ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
