Answer / Bahoran Singh

The most essential Data Definition Language (DDL) statements in SQL are: CREATE - used to create database objects such as tables, views, indexes, and schemas.n ALTER - used to modify existing database objects.n DROP - used to delete database objects such as tables, views, and indexes.n TRUNCATE - used to remove all rows from a table, but it does not release the space occupied by the table.

Can triggers stop a dml statement from executing on a table?

1 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

How can you tell the difference between an index and a view?

1 Answers  

---

what is the difference between nested subquery and correlated subquery?

1 Answers  

---

What is the difference between truncate and drop statements?

1 Answers  

---

What is the starting oracle error number?

1 Answers  

---

what is dbms? : Sql dba

0 Answers  

---

What is data type in database?

1 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

Is there any restriction on the use of union in embedded sql?

1 Answers  

---

What does where 1/2 mean in sql?

1 Answers  

---

What is rownum?

1 Answers  

---