Denormalization is a technique to move from top to bottom database normal f

What is denormalization and when would you go for it?

Question Posted / asim javaid iqbal sahi

9 Answers
39373 Views
NBP, I also Faced
E-Mail Answers

Answer Posted / asim javaid iqbal sahi

Denormalization is a technique to move from top to bottom database normal forms in order to optimize the performance of database and or to increase access time of database.

Is This Answer Correct ?

8 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

997

In which database can extended stored procedures be added?

904

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1001

Why does this query return 0?

1015

I have a few records all are same structures data, I want to store data in multiple targets how

2654

Explain about post-relational databases?

1022

What is an application role and explain a scenario when you would use one?

1012

How to replace not in with not exist?

2089

Explain the process of the user request and data generating?

1094

Explain about relational operator join?

1039

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2144

What is database design and development?

1017

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

963

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2207

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1002