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 define a cusotmer as a supplier in ORACLE R12

2230

---

How many types of table in Oracle?

1120

---

What are the most common interview questions on ETL Testing for experience?

1143

---

How to execute a stored procedure in oracle?

1091

---

What do you mean by cdb and pdb in oracle 12c?

1059

---

Describe varray?

1057

---

What is connection pooling in oracle?

973

---

How to store only time; not date and time?

1018

---

what happened to the global index when I truncate the data in one of the partition?

2022

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2025

---

What is oracle server autotrace in oracle?

1166

---

What is the difference between truncate & delete command?

1182

---

When do you get a .pll extension in oracle? Explain its importance

1039

---

How do I uninstall oracle 11g?

1117

---