Archive for March, 2008



Pages (999999): [1] 2 3 » ... Last »

What is an alias and how does it differ from a synonym ?

View the Answer

What is a synonym? How is it used ?

View the Answer

What is a NULL value? What are the pros and cons of using NULLS?

View the Answer

What is the significance of DB2 free space and what parameters control it ?

View the Answer

What is SPUFI?

View the Answer

What is lock contention ?

View the Answer

What is the database descriptor ?

View the Answer

Is there any advantage to denormalizing DB2 tables ?

View the Answer

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

View the Answer

What is a cursor and what is its function ?

View the Answer

What is tablespace ?

View the Answer

What is the difference between group by and order by ?

View the Answer

What is a subselect? Is it different from a nested select?

View the Answer

Explain an outer join ?

View the Answer

What is a view? Why use it?

View the Answer

Pages (999999): [1] 2 3 » ... Last »