Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pragyan
database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.
de-normalization is the process of attempting to optimize the performance of a database by adding redundant data..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain hostprotectionattribute in sql server 2005?
Name the different type of indexes in sql?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are a database and a data warehouse?
Define compound operators?
Tell me about pre-defined functions of sql?
Tell me what is difference between clustered and non clustered index?
Which language is supported by sql server?
What is faster join or union?
Where are sql server user names and passwords stored in sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is a raid and what are different types of raid configurations?
What is de-normalization and what are some of the examples of it?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
How is table type constraint applied to a table?
