pls tell me abt the normalization five types....
- 2 Answers
- 4191 Views
- I also Faced
- E-Mail Answers
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 are catalog tables in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the picture clause of null indicator variable?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
Mention and explain the contention situations caused by locks?
why we create view.
Explain about cursor stability?
can i code union in cobol-db2 pgm ?
COBOL 
