Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Normalization.
- 1 Answers
- 1729 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 |
Why we need a group by clause?
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
why SQL server is more used to store database rather than Access
Explain what are the different index configurations a table can have?
What is the purpose of linked server configuration in sql server?
Delete duplicate rows without using rowid.
what is the output for this query select * from employee where 1=1;
How to perform backup for certificates in sql server? : sql server security
What are the requirements to use odbc connections in php scripts?
When would you use a before or after trigger?
What happens if the update subquery returns no rows in ms sql server?
How can u get the number of pupils connecting the database?
-
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)
