Answer / Prantosh Kumar Singh Chauhan

DDL (Data Definition Language) statements in SQL are used to create, alter, and drop database objects. The most important DDL statements include CREATE TABLE for creating tables, ALTER TABLE for modifying the structure of existing tables, DROP TABLE for deleting tables, CREATE INDEX for creating indexes on tables, and DROP INDEX for deleting indexes.

What is a heap in sql?

1 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

Is sql difficult?

1 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

Are sql database names case sensitive?

1 Answers  

---

Is big data nosql?

1 Answers  

---

What is mutating sql table?

1 Answers  

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

How delete all data from all tables in sql?

1 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

how can you see all indexes defined for a table? : Sql dba

1 Answers  

---

Which is the correct statement about truncate and delete?

1 Answers  

---