What is the advantage in De-normalizing tables in DB2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is performance tuning db2?

0 Answers  


What is a precompiler?

2 Answers  


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


How do you check for a null value in a db2 column?

2 Answers  


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,






I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


how to unload different table data into different gdg files/ vsam files.

3 Answers  


What is the difference between using bind () and rebind () methods of naming class?

0 Answers  


What is data manager?

0 Answers  


What is db2 look?

0 Answers  


I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,


What is the max length of sqlca?

0 Answers  


Categories