What do the initials DDL and DML stand for and what is their meaning ?
DDL is data definition language and DML is data manipulation language. DDL statements are CREATE, ALTER, TRUNCATE. DML statements are SELECT, INSERT, DELETE... Read more »
Archive for March, 2008
What are foreign keys ?
These are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables. Read more »
What is normalization and what are the five normal forms ?
Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy. Read more »
What are the levels of isolation available with DB2V4 ?
CS RR UR( added new for DB2V4 which stands for uncommitted read which allows to retrieve records from the space which has exclusive locks also but data integrity... Read more »
What is the difference between TYPE 1 index & TYPE 2 index ?
TYPE 1 & TYPE 2 are specified when an index is created on the table. TYPE 2 index is the option which comes with DB2V4. With TYPE 2 index data can be retrieved... Read more »
What does CURRENTDATA option in bind indicate ?
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 the... Read more »
10 Database Interview Questions
What is the command used by TSO users to invoke DB2? DSN RUN What is the error code -803 ? unique index violation How do you filter out the rows retrieved from a... Read more »
what’s the best lock size that you could use when you create a tablespace ?
The answer is Locksize = ANY. Unless you are Sure what’s the Purpose of tablespace ie., Read-only or R/W. If you use lock size =any, Db2 would automatically... Read more »
What are the functions of Bind ?
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... Read more »
What is the difference between join and union ?
join is used to retrieve data from different tables using a single sql statement. union is used to combine the results of two or more sql queries. Read more »
When Can you be sure that a query will return only one row ?
When you use the primary key and only the primary key in the where clause. Read more »
Can we declare DB2 HOST variable in COBOL COPY book ?
NO. If we declare DB2 host variable in COBOL COPY book, at the time of Pre-compilation we get the host variable not defined, because pre-compiler will not expand... Read more »
What is Skeleton cursor table (SKCT) ?
The Executable form of a Plan. This is stored in sysibm.sct02 table. Read more »
How many Buffer pools are there in DB2 and what are they ?
There are 4 Buffer pools. They are BP0,BP1,BP2 and BP32. Read more »
B37 abend during SPUFI ?
The b37 abend in the SPUFI is because of space requirements , the query has resulted in so many rows that the SPUFI. out file is not large enough to handle it, increase... Read more »