What is Normalization ?
Answer Posted / ravi kumar
Normalization is the relational database design technique
in which most ambiguity is removed.
Normalization usually involves dividing a database into two
or more tables and defining relationships between the
tables. The objective is to isolate data so that additions,
deletions, and modifications of a field can be made in just
one table and then propagated through the rest of the
database though the defined relationships.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a sub query? What are its various types?
How view is different from a table?
What is a proxy object?
What are the advantages of oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to divide query output into groups in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to write an inner join with the where clause in oracle?
Explain the function of optimizer in oracle?
What is data block in Oracle?
What privilege is needed for a user to create indexes in oracle?
What is a oracle database?
What is the quickest way to export a table to a flat file?
What is a snapshot in oracle database?
Differentiate between post-database commit and post-form commit?