![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions 1. What are the different types of joins?2. Explain normalization with examples.3. What cursor type do you use to retrieve multiple recordsets?4. State the difference between a "where" Latest Answer : Delete from < TableName a >Where rowid >(select min(rowid) from < TableName b >Where a.< ColumnName > = b.< ColumnName >)commit;The above query will delete all duplicate columns. ... Read Answers (14) | Asked by : Rajani A: 1 1 0 1 1 0 1 1B: 0 1 1 1 1 0 1 0C: 0 1 1 0 1 1 0 1 Find ( (A-B) u C )==?Hint : 109A-B is {A} - {A n B} Read Answers (3) | Asked by : ritu das A plane moves from 9˚N40˚E to 9˚N40˚W. If the plane starts at 10 am and takes 8 hours to reach the destination, find the local arrival time. Read Answers (1) | Asked by : suganthi If log 0.317=……… and log 0.318=………. Then find the value of log 0.319. Read Answers (1) | Asked by : Madhumitha 1. What are the different types of joins? 2. Explain normalization with examples. 3. What cursor type do you use to retrieve multiple record sets? 4. Difference between a "where" clause and Latest Answer : there are 5 ways to normalize the database in order to make complex data structure into simpler form.
1NF- removing duplicate groups and multivalued entries
2NF-removing functional dependencies and create foreign key to relate with primary key
3NF- ... Read Answers (3) | Asked by : sowjanya
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||