Answer Posted / animesh

SQL IS A STRUCTURED QUERY LANGUAGE THROUGH WHICH WE CAN
COMMUNICATE WITH THE ORACLE SERVER AND SQL STATEMENTS ARE
DIVIDED INTO FIVE STATEMENTS i:e. Data defintion language
(DDL) which is used in creating the tables,views. In DDL
create,
Alter,
Drop,
Rename,
Trucate comes.
where as Data Manipulation Language(DML)command is used to
manipulate the data.In DML
Insert,
Update,
Delete,
Merge.
the third one is Data retrieval i:e. the select command
the fourth one is Transcation control i:e.
commit,Rollback,savepoint.
the fifth one is data control language(DCL) i:e.
grant,revoke

What are the ways tablespaces can be managed and how do they differ?

2367

---

How different is ms access and oracle?

1039

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2902

---

Oracle

2376

---

What is a lookup table in oracle?

973

---

How to get a list of all user accounts in the database?

1087

---

What is an Oracle index?

1655

---

What are the differences between blob and clob in oracle?

1089

---

Can you assign multiple query result rows to a variable?

987

---

What are the data types in oracle?

1040

---

How oracle handles dead locks?

1066

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1989

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1078

---

Difference between oracle's plus (+) notation and ansi join notation?

1101

---

What are group functions in oracle?

1041

---