adspace


Explain the first normal form(1nf)?

Answer Posted / Alok Yadav

The First Normal Form (1NF) is a database normalization rule that ensures each column in a table contains atomic or indivisible values, and that each table has a primary key. In 1NF, there should be no repeating groups, no arrays within columns, and all columns should contain unique values.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between for xml raw and for xml auto?

1117


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1022


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1133


What is sql or structured query language?

1227


Why use identity in sql server?

1199


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1071


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1196


Is it possible to have clustered index on separate drive from original table location?

1039


Why we use the openxml clause?

1079


How do I create a trace in sql server?

1120


What is a scheduled job or what is a scheduled task?

1039


Can sql servers link to other servers like oracle?

916


What are the different SQL Server Versions you have worked on?

1079


What is a coalesce function?

1282


How to provide default values to function parameters?

1258