What is Normalization in oracle?
Submitted by: AdministratorNormalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating two factors: redundancy and inconsistent dependency.
Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database.
Submitted by: Administrator
Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations. A customer address change is much easier to implement if that data is stored only in the Customers table and nowhere else in the database.
Submitted by: Administrator
Read Online SQR (Structured Query Reporter) Job Interview Questions And Answers
Top SQR (Structured Query Reporter) Questions
☺ | Tell me What is search Record? |
☺ | Can you explain Outer join, inner join in sql? |
☺ | Explain the difference between Load Look up and Array? |
☺ | How to generate tow output files from one SQR? |
☺ | Explain difference between BI, CI, IB? |
Top PeopleSoft Categories
☺ | PeopleSoft HRMS Interview Questions. |
☺ | PeopleSoft Financials Interview Questions. |
☺ | Peoplesoft Security Interview Questions. |
☺ | Peoplesoft Tools Interview Questions. |
☺ | PeopleSoft Common Interview Questions. |