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.

How to check the server version in oracle?

613

---

How to connect to oracle using service name instead of sid?

553

---

Why oracle is used?

581

---

Is oracle a language?

527

---

How to start your 10g xe server from command line?

548

---

---

How to apply filtering criteria at group level in oracle?

587

---

How to pass parameters to procedures in oracle?

570

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1438

---

How to start a specific oracle instance?

584

---

Compare and contrast between sql and sql server and explain its various functions?

537

---

How to load data through external tables?

583

---

Explain the use of grant option in imp command.

580

---

How will you identify oracle database software release?

527

---

Explain the use of grant option in exp command.

586

---

Is there any function in oracle similar like group_concat of mysql?

541

---