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 |
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)