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 the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  


How can we read records for specific member in CL? AND rpg?

0 Answers  


What are data types?

2 Answers  


I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  


What is dbrm? What it contains? When it will be created?

0 Answers  






Where are plans stored?

2 Answers  


what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,


What is a bind card?

0 Answers  


How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,


how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,


Categories