Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews PeopleSoft Interviews:Component InterfaceInternet EBusinessPeopleCodePeopleSoft AdminPeopleSoft AdministrationPeopleSoft BasicPeopleSoft CommonPeopleSoft FinancialsPeopleSoft HRMSPeopleSoft ImplementationPeopleSoft InterfacesPeoplesoft SecurityPeoplesoft ToolsPeopleToolsSQR (Structured Query Reporter)
Copyright © 2018. All Rights Reserved
SQR (Structured Query Reporter) Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.