Can objects of the same schema reside in different tablespace?

0 Answers  

---

difference between truncate and delete ,drop?

3 Answers  

---

What are inner join and outer join?

3 Answers  

---

sql command 2 know current database

4 Answers  

---

Give the different types of rollback segments.

0 Answers  

---

---

What is hash cluster in oracle?

0 Answers  

---

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

0 Answers  

---

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

---

defination of bitmap index

0 Answers   NIIT,

---

What are the commands youd issue to show the explain plan for select

2 Answers  

---

How to work with data objects interactively?

0 Answers  

---