Answer / garry

temporary tablespaces are used for sorting operations

and
permanent tablespaces are tablespace that related to system
or sysaux datafile (system and sysaux are mandatory datafiles)



note :-u can not create dictionary manage tablespace in
database which is created thru dbca

Answer / guest

1.Temporary tablespace is locally managed tablespace
Permanent tablespace is dictionary managed tablespace
2. when an extent is allocated or freed for reuse changes
occurs in tables.In case of Temporary tablespace changes
happen in bitmaps but in Permanent tablespace System Tables
gets updated.
3. Temporary Tablespace automatically tracks adjacent free
space.

What type of index should you use on a fact table?

1 Answers  

---

can we drop dual table

7 Answers   Metric Stream,

---

what is shared memory?

1 Answers   IBM,

---

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers  

---

Can we modify approve purchase order?if yes what is navigation?

0 Answers   L&T,

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---

What do you mean by Oracle MEDIA RECOVERY?

0 Answers  

---

Explain materialized views and how they are used.

2 Answers  

---

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

---

How would you go about increasing the buffer cache hit ratio?

0 Answers  

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,

---