Describe about first three Normal forms.
1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.
| Is This Answer Correct ? | 6 Yes | 0 No |
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Why Do you want to work in this company?
how many types of store procedre in sqlserver 2000?
Explain indexed view?
How to concatenate two strings in SQL Server.
Explain about SQLOS?
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
What is the difference between OLEDB and ODBC
What is the difference between join and inner join?
Does transparent data encryption provide encryption when transmitting data across the network?
How do I make a resultset scrollable?
What is the difference between mysql and mysqli?
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)