Database Interview Questions

« KyaPoocha.com home page
« Next Entries
Previous Entries »


Page 5 of 29« First...«34567»...Last »

What is deadlock ?

View the Answer

Explain transactions, commits and rollbacks in DB2 ?

View the Answer

What are the three DB2 date and time data types and their associated functions ?

View the Answer

How is the SUBSTR keyword used in sql ?

View the Answer

What are some SQL aggregates and other built-in functions ?

View the Answer

What keyword does an SQL SELECT statement use for a string search ?

View the Answer

What is a clustered index ?

View the Answer

What is meant by index cardinality ?

View the Answer

What is a composite index and how does it differ from a multiple index ?

View the Answer

What are some characteristics of columns that benefit from indexes ?

View the Answer

How does DB2 use multiple table indexes ?

View the Answer

In terms of DB2 indexing, what is the root page ?

View the Answer

When can an insert of a new primary key value threaten referential integrity ?

View the Answer

What are delete-connected tables ?

View the Answer

What is the self-referencing constraint ?

View the Answer

Page 5 of 29« First...«34567»...Last »