Answer Posted / arkchowdary

we use Dept table or Any table Insert Command

Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');

Or

Insert into dept values('&dname',deptno,'&location'....)

List out the difference between commit, rollback, and savepoint?

1094

---

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

2338

---

Which are the five query types available in oracle?

999

---

How to check the oracle tns settings?

1087

---

Explain an extent?

1154

---

Explain the use of online redo log files in oracle.

1077

---

How to rename an index in oracle?

1169

---

Whether any commands are used for months calculation? If so, what are they?

1137

---

How to use subqueries with the in operator using oracle?

1137

---

Explain drop constraint oracle?

1121

---

What is a data dictionary and how can it be created?

1238

---

How to drop an index?

1013

---

How can you use check constraints for self referential integrity?

1017

---

What is sharded cluster?

1070

---

How to use values from other tables in update statements using oracle?

1128

---