Normalization is a process which is the tables in a database are optimized to remove the potential for redundancy. Two main problems may arise if this is not done:
> Repeated data makes a database bigger.
> Multiple instances of the same values make
maintaining the data more difficult and can
create anomalies.
By:UMANG
Date:
What are the advantages of using Stored Procedures?
Why we use Semicolon after SQL Statements?
What\'s the maximum size of a row?
What is a Scheduled Jobs or What is a Scheduled Tasks?
What is the STUFF function and how does it differ from the REPLACE function?
What do you mean by Table Sample?
What is UNIQUE KEY constraint?
What is the mean of The model?
What is Replication and Database Mirroring?
What is the mean of Dictionary Compression?
What is an Aggregate Function?
Explain Active/Active and Active/Passive cluster configurations?
What is denormalization and when would you go for it?
What are the Different methods of loading Dimension tables?
What is the Referential Integrity?
What do you mean by Live Lock?
What is the purpose of UPDATE STATISTICS?
What is the use of SCOPE_IDENTITY() function?
How do you transfer data from text file to database (other than DTS)?
What is RAID and what are different types of RAID configurations?
What are the main attributes of database management system?
What are the main components of Database management systems software.
What Oracle lock modes do you know?
What are the difference between DDL, DML and DCL commands?
Which one is faster DELETE/TRUNCATE?
What are different normalization forms?
What are the components of physical database structure of Oracle database?
What are the components of logical database structure of Oracle database?
What is SYSTEM tablespace and when is it created?
Explain the relationship among database, tablespace and data file.
Can objects of the same schema reside in different table spaces?
Can a tablespace hold objects from different schemes?
What do you mean by Candidate key?
What are the properties of the Relational tables?
What is the mean of Nested Trigger?
What is Difference between Function and Stored Procedure?
What is the Sub-Query?And what is the properties of Sub-Query?
Give the list how many type of Joine?
Define : What is the Cross Join?
give us a definition of Inner Join?
What do you mean by Outer Join? and define also how many types of Outer Join?
What is User Defined Functions?
What kind of User-Defined Functions can be created?
What are slowly changing dimensions (SCD)?
What do you mean by A non clustered index?
What are the different index configurations a table can have?
What are different types of Collation Sensitivity?
What do you mean by DELETE command?
When is the use of UPDATE_STATISTICS command?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What are the properties of SUB-QUERY?
What are the type of SUB-QUERy?
What are the authentication modes in SQL Server? How can it be changed?
What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?
What is the mean of Local temporary table?
What do u mean by Global temporary table?
What is BCP? When does it used?
What is an execution plan? When would you use it? How would you view the execution plan?
How to implement one-to-one,one-to-many and many-to-many relationships while designing tables?
What do you mean by The master database?
Define whats the mean by Resoure Database?
What are the Advantages of using CTE?
What is the mean of Row Compression?
What do you mean by DBCC Command?
What is the Ranking functions?
What is the mean of ROW_NUMBER() OVER?
What is the mean of Root Node?
What do you mean by Branch Node?
What do you mean by Leaf Nodes?
What do you mean by Snow schema?
What do you mean by Star schema?
What are defaults? Is there a column to which a default can't be bound?
What do you mean by COLLATION?
What do you mean by Distributed partitioned views.?
How many New Data types are in the SQL Server 2000?
What do you mean by INSTEAD OF and AFTER Triggers.?
What do you mean by Cascading Referential Integrity Constraints?
Whay do you mean by XML Support in Sql Server 2000?
What do you mean by Indexed Views>
What is the use of union in Indexing?
What do you mean by Read Committed?
What is the basic difference between a join and a union?
What do you mean by Read Uncommitted?
What do you mean by Repeatable Read?
What do you mean by Serialized?
Discuss about Disadvantages of cursors?
In what sequence SQL statement are processed?