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 |
Mention the different locking levels that are available in db2.
How to find schema of a table in db2?
What is the difference between Primary key and unique index?
How to update more then one record using update?
What is a result table?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
How to compare data between two tables in db2?
What is meant by explain?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
How many buffer pools are there in DB2?
what is diffrence b/w file-aid tool and file-aid utility???