Interested to Buy Any Domain ? << Click Here >> for more details...
What is denormalization and when would you go for it?
- 9 Answers
- 39258 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
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What is the maximum length of an extended property?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
How would you design a database for an online site, which would average a million hits a day?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Explain the rollup operator?
How you can make a parameterized view?
Explain the role of indexing in databases?
Explain about the storage and physical database design?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
What are the three basic rules which are to be followed for the relational model of the database?
How can you log an error to the server event log from a stored procedure?
Explain about xml databases?
How can I detect whether a given connection is blocked?
How to customize error conditions.
