pls tell me abt the normalization five types....
Answers were Sorted based on User's Feedback
Answer / deepthi
there are 5 normalizations
1.1st normal form
2.second normal form
3.3rd normal form
4.fourth normal form
5.fifth normal form
Is This Answer Correct ? | 3 Yes | 1 No |
What is Call attach facility? How does it work?
What is the maximum size of varchar data type in db2?
When is the access path determined for dynamic SQL?
How to get Top 10 Salaries from a Table
What is DCLGEN?
Explain package in db2 and its advantages?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
How does DB2 determine what lock-size to use?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is index cardinality?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.