Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Normalization.
- 1 Answers
- 1843 Views
- HPCL, Hughes Systique Corporation, Ittiam Systems, I also Faced
- E-Mail Answers
• 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 logical database components? : SQL Server Architecture
What is the Disadvantage of indexed sequential file.
What is a filestream?
What are the different types of locks in the database?
What are the purposes and advantages stored procedure?
What is transcation?Plz give One example?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Explain “not null constraint” in sql server?
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.
How to create a Master database in SQL server ?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
-
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)
