Answer Posted / subhash
Normalizatiin is the scientific method of breaking down
complex table sturcture into simple table structure by
using certain rules.using this method you can reduce
redundency in a table and eliminate the problem of
inconsisteny and disk space usage.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain what a database is?
What is data modeling with example?
What is an application role and explain a scenario when you would use one?
Explain the cube operator?
Explain about relational database management systems?
Explain about xml databases?
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?
What are the 18 schemas?
Why does this query return 0?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
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.
Write the fastest query to find out how many rows exist in a table?
Explain the rollup operator?
How is data stored in dbms?
