Answer Posted / pavan_1981

sql is a universally accepeted query language whic acts an
interface to the relational databases to fetch,insert and
manipulate the data existing in the database.
sql encompasses of five parts
1.Data Retrieval Language:the commands used to select data
from the database.this includes
a.select
2.Data manipulation Language:commands to manipulate the
data existing in the database.commands in this are
a.insert
b.update
c.delete
d.merge
3.Data Definition Language:commands to define and create
the database ojects like tables ,views etc.commands in this
are
a.create
b.truncate
c.alter
d.drop
e.describe
f.rename
4.Tranaction control Language:the commands in this are
a.grant
b.revoke
5.Data Control Language:the commands in this are
a.Commit
b.Rollback
c.Savepoint.

is there a tool to trace queries, like profiler for sql server?

1196

---

What is different types of joins?

1078

---

What is an external table?

1080

---

What do you mean by group by clause?

1092

---

How to change user password in oracle?

1093

---

What is the difference between a primary key & a unique key?

1139

---

How to rename an index in oracle?

1167

---

What is the sql query to concatenate column values from multiple rows in oracle?

1102

---

What is varray?

1194

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2336

---

What do database buffers contain?

1081

---

How many types of table in Oracle?

1172

---

Explain an exception and its types?

1134

---

What are the parameters that we can pass through a stored procedure?

1117

---

Is there an oracle sql query that aggregates multiple rows into one row?

1025

---