Database Management Question:

Download Job Interview Questions and Answers PDF

What is sufficient to normalize a database up to 3NF?

Database Management Interview Question
Database Management Interview Question

Answer:

dependent on application. Most transactional based
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.

Download Database Management Interview Questions And Answers PDF

Previous QuestionNext Question
How to access the default tables of 9i?What is the difference between oracle CPU and PSU?