what is Normalization?
Answers were Sorted based on User's Feedback
Answer / cr
Normalization is a design technique to develop table
structures. Purpose of normalization is to eliminate
redundant data.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / murthybabu
The process of decomposing tables to eliminate data
redundancy is called Normalization.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / sudipta
Normalization is a technique by which successive redundancy
of a given relation is make into a more easier form.it
improves the tuple quality and make the data in a
consistence state,also helps to improves redundant data.
(Higher the normal form better the tuple type)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anjali
normalization is to crystalizing the table into small
tables to avoid the redundancy. splitting table into small
ones.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gladys
Is the process of efficiently organizing data in a database.
| Is This Answer Correct ? | 0 Yes | 2 No |
Explain about post-relational databases?
Can you have a nested transaction?
Explain about xml databases?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the disadvantages of cursors? How can you avoid cursors?
Explain about normal forms?
Which four data types cannot be used as a return type from a user-defined function?
What is the physical representation for a many-to-many relationship?
How to generate OIDS
Write the fastest query to find out how many rows exist in a table?
How to create an external table.
how to find the first two highest salaries in deptno in emp table
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)