Logo F2FInterview

DB2 Interview Questions

Q   |   QA

Tables are stored in Table Space (hence the name)! There are 3 sorts of Table Space simple, segmented and partitioned

An embedded Sql statement may come up with a lot of rows additonally the programming blabber can merely entrance one row at a opportunity The programming device labeled a cursor controls the position of the row .

Referential integrity refers to the consistency who are required to be maintained between number one and distant keys, ie most every out of country key quality ought to experience a corresponding number one key value.

I/O operations are mostly many grim for DB2 performance (or any a good deal more database for the current matter)

De-normalizing DB2 tables goes down the would like for processing intensive relational joins and decreases the sum of distant keys.

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: