Answer / ram

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

in DMT data dictionary tables stores the information of free and used extents, for used extents information in dmt tablespace uses sys.uet$ view and free extents information in DMT tablespace stored in sys.fet$

in LMT tablespace, tablespace datafiles maintains own bitmaps @ datafile headers these store the used extents and free extents information.

LMT is preferable, because it won't generate any rollbacks,
dictionary contention is reduced, space wastage removed & fragmentation removed

Answer / kittu

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

In dictionary managed tablespace oracle will take care of tablespace

In locally managed tablespace we need to take care of tablespace

Explain what partitioning is and what its benefit is.

2 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

How would you force a log switch?

4 Answers  

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---