Answer Posted / vikranth

sql is a structured query language which acts as an
interface to the RDBMS.It is used in the application
development side to select the data from the database.

DDL is Data definition language statements which are used
to develop a structure to the table. where as DML(data
manipulation language statements) are used to perform the
updations to the data.

What the is the diff between local index and global index. give some example.

1681

---

What's dateware house and what's clustor with practicle example

2233

---

Can group functions be mixed with non-group selection fields?

1073

---

How to add a new column to an existing table in oracle?

1186

---

How to lock and unlock a user account in oracle?

1160

---

How to install oracle odbc drivers?

1141

---

What is the difference between "as" and "is" in an oracle stored procedure?

1046

---

What is a initialization parameter file in oracle?

1081

---

When system tablespace is created?

1090

---

Can we store pictures in the database and if so, how it can be done?

1089

---

What are temporal data types in oracle?

1164

---

Which is better Oracle or MS SQL? Why?

6482

---

How to find out what oracle odbc drivers are installed?

1092

---

Explain the use of record length option in exp command.

1117

---

How many types of cluster table in Oracle?

1080

---