What is better - 2nd Normal form or 3rd normal form? Why?

Answer Posted / varun4db

3rd normalization is better in data warehousing.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference RDBMS and Graph Database?

800


How will you optimize a stored procedure optimization?

676


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

850


How to concatenate two character strings together?

757


Why use sub query in sql server and list out types of sub queries?

720






How does the report manager work in SSRS?

131


Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

129


What type of locking occurs during the snapshot generation? : sql server replication

1082


What is update locks?

658


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2250


What is an entity-relationship diagram (erd)?

802


How to add additional conditions in SQL?

767


How do I view a trc file?

679


Explain the etl (extraction, transformation, and loading)?

722


Why we need to use secondry database file? though, we can do same work using primary database file also.

6194