is it sufficient to normalize a database up to 3NF?
Answers were Sorted based on User's Feedback
It all depends on users aproach towards data
selec/inserts/updates
... Normelization affects data retrival severely.
we can go up to BCNF
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shwetal
If possible It should be normalize upto BCNF but it completely depends on the data
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jdfiji
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.
Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of a model?
What is the advantage of the database management approach
When the SYSTEM TABLESPACE can be made off-line ?
What is a logical backup ?
What is openedge workgroup rdbms?
Explain the components of rdbms?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
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?
Explain the terms database and dbms?
What are the differences between hash join, merge join and nested loops?
What is database connection pool size?
Explain what is a deadlock and mention how it can be resolved?