please explain Nomalization in dbms?
Answers were Sorted based on User's Feedback
Answer / ankit srivastava
Normalization is the technique that removes redundancy in
table.It ensures that there is no any duplicate data in table.
Is This Answer Correct ? | 16 Yes | 0 No |
Answer / venkatesh kumar.s
Normalization is the process of the analyzing given
relations schema based on functional dependencies and
primary key to acheive the desirable properties of
1)Minimizing the redundany
2)Minimizing the insertion,update and deletion problems
is called a normalization.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / voota durga prasad
Normalization is the process of designing a data model to
efficiently store data in a database. The end result is that
redundant data is eliminated, and only data related to the
attribute is stored within the table.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ilaya
normalization is the process of the analyzing the related
database is functional dependencies and primary key is called
a normalization.
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / ilaya
normalization is the process of the analyzing the related
database is functional dependencies and primary key is called
a normalization.
Is This Answer Correct ? | 2 Yes | 1 No |
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
what is the age limit for groups1 examination
What do you mean by denormalization?
What is partial key?
What is the use of CONSISTENT (Ver 7) option in EXP command ?
Where is data stored in a database?
Describe the types of keys?
What is database write application of database?
Explain a join between tables?
Is facebook a database?
How to migrate paradox, dbase or foxpro database to firebird?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?