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 is the full form of dql?
How to delete multiple rows with one delete statement in ms sql server?
What do you mean by sql server agent?
How do you open a cluster administrator?
How do you rename a table in sql server?
What to perform pattern match with the like operator?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What is data source object?
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
How to list all user defined functions in the current database?
How to drop an existing stored procedure in ms sql server?
Do you know query execution plan?
Oracle (3253)
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)