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 |
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM
Mention the differences between substr and charindex in sql server.
Simple example for difference between select and cursor in sql
Do you know what guidelines should be followed to help minimize deadlocks?
How you can get a list of all the table constraints in a database? : Sql server administration
What are explicit and implicit transactions?
How to generate create procedure script on an existing stored procedure?
Can store procedure call by user define function in SQL server?
logshipping is Any difference 2000 and 2005?
What is the difference between delete and truncate statements?
What are the different sql server versions?
What is difference between join and natural join?
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)