Answer / orawhiz

Every ORACLE database has one or more physical data files. A
database's data files contain all the database data. The
data of logical database structures such as tables and
indexes is
physically stored in the data files allocated for a database

difference between truncate and delete ,drop?

3 Answers  

---

How to get maxsal , minsal, ename department wise in single query

0 Answers  

---

How to drop an index?

0 Answers  

---

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,

---

what are the differen between key flexifild and discriptive fiexifild.

1 Answers  

---

---

how many types of index?

2 Answers   Cap Gemini, TCS,

---

What happens if you use a wrong connect identifier?

0 Answers  

---

Are truncate and delete commands same? If so why?

0 Answers  

---

Design database draw er diagram for a certain scenario ?

0 Answers   Keane India Ltd, TATA,

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

how to handle exceptions in post production

0 Answers  

---

Explain oracle left join with an example?

0 Answers  

---