Explain different types of Normalization.
• 1NF (First Normal Form) – Eliminates duplicate columns, ensures atomicity.
• 2NF (Second Normal Form) – Removes partial dependencies.
• 3NF (Third Normal Form) – Removes transitive dependencies.
• BCNF (Boyce-Codd Normal Form) – Ensures every determinant is a candidate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How real and float literal values are rounded?
how to overcome kernel isssues
What is unique key constraint?
What is explicit cursors?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
Why we use trigger in sql server with example?
What are sp_configure commands and set commands?
What are sub-queries? Give example? In which case sub-queries are not feasible?
how to get the rowid/rownumbes of a table in sqlserver
what purpose does OPENXML clause have in sql server stored procedure?
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)