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 |
How to change the name of a database user?
write an SQL query to list the employees who joined in the month of January?
How to enter unicode character string literals in ms sql server?
What is policy management?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
Can an entity have two primary keys?
Difference between Function and Procedure-in general?
Tell me can we use custom code in ssrs?
How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?
What is system stored procedures?
How do you set a trace flag in sql server?
What are unicode character string data types in ms sql server?
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)