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
What is the difference RDBMS and Graph Database?
How will you optimize a stored procedure optimization?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How to concatenate two character strings together?
Why use sub query in sql server and list out types of sub queries?
How does the report manager work in SSRS?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What type of locking occurs during the snapshot generation? : sql server replication
What is update locks?
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
What is an entity-relationship diagram (erd)?
How to add additional conditions in SQL?
How do I view a trc file?
Explain the etl (extraction, transformation, and loading)?
Why we need to use secondry database file? though, we can do same work using primary database file also.