What is denormalization and when would you go for it?
Answer Posted / gtp
Denormalization is a technique to move from higher to lower
normal forms of database modeling in order to speed up
database access
| Is This Answer Correct ? | 76 Yes | 9 No |
Post New Answer View All Answers
What is the physical representation for a many-to-many relationship?
Write the fastest query to find out how many rows exist in a table?
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?
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?
Explain about a primary key?
explain detail about ftp in datastage?
Explain the role of indexing in databases?
Explain about relational database management systems?
How to read and create .LDC data files which are used by linguatic dictionary.
How can you fix a poorly performing query?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
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.
Who are naive users?
What is database design and development?
Can an extended stored procedure be called from inside a user-defined function?