What is deadlock ?
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. Read more »
‘Database Interview Questions’ - KyaPoocha.com
Explain transactions, commits and rollbacks in DB2 ?
In DB2 a transaction typically requires a series of updates, insertions and deletions that represent a logical unit of work. A transaction puts an implicit lock... Read more »
What are the three DB2 date and time data types and their associated functions ?
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... Read more »
How is the SUBSTR keyword used in sql ?
SUBSTR is used for string manipulation with column name, first position and string length used as arguments. E.g. SUBSTR (NAME, 1 3) refers to the first three... Read more »
What are some SQL aggregates and other built-in functions ?
The common aggregate, built-in functions are AVG, SUM, MIN, MAX, COUNT and DISTINCT. Read more »
What keyword does an SQL SELECT statement use for a string search ?
The LIKE keyword allows for string searches. The % sign is used as a wildcard. Read more »
What is a clustered index ?
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... Read more »
What is meant by index cardinality ?
The number of distinct values for a column is called index cardinality. DB2’s RUNSTATS utility analyzes column value redundancy to determine whether to use... Read more »
What is a composite index and how does it differ from a multiple index ?
A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two columns... Read more »
What are some characteristics of columns that benefit from indexes ?
Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence of... Read more »
How does DB2 use multiple table indexes ?
DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR. Read more »
In terms of DB2 indexing, what is the root page ?
The simplest DB2 index is the B-tree and the B-tree’s top page is called the root page. The root page entries represent the upper range limits of the index... Read more »
When can an insert of a new primary key value threaten referential integrity ?
Never. New primary key values are not a problem. However, the values of foreign key inserts must have corresponding primary key values in their related tables.... Read more »
What are delete-connected tables ?
Tables related with a foreign key are called delete-connected because a deletion in the primary key table can affect the contents of the foreign key table. Read more »
What is the self-referencing constraint ?
The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing... Read more »