Answer / Sumeet Bhatnagar

SQL supports several types of statements to manipulate and query data in a relational database:n1. Data Definition Language (DDL) Statements: These statements are used to create, alter, or delete database objects such as tables, views, indexes, and schemas.n2. Data Manipulation Language (DML) Statements: These statements are used to insert, update, delete, and retrieve data from the database.n3. Transaction Control Statements: These statements are used to manage transactions, such as COMMIT, ROLLBACK, SAVEPOINT, and BEGIN TRANSACTION.n4. Catalog (Metadata) Statements: These statements are used to retrieve information about database objects, such as DESCRIBE, TABLE, INDEX, and SP_HELP.n5. Control of Flow Statements: These statements are used to control the flow of execution in SQL code, such as IF-ELSE, CASE, LOOP, WHILE, and GOTO.

Why is normalisation important?

1 Answers  

---

What is user-defined multi-statement table-valued function?

1 Answers  

---

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1 Answers  

---

What is query optimizer in sql server?

1 Answers  

---

What is the Disadvantage of indexed sequential file.

1 Answers   HCL,

---

What is nested transaction?

1 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

How to connect to a sql server using odbc_connect()?

1 Answers  

---

How to create nested stored procedure?

1 Answers  

---

How to drop an existing schema in ms sql server?

1 Answers  

---

What is Full Outer Join?

3 Answers  

---