1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What are the ways tablespaces can be managed and how do they
differ?

Question Posted / narmada kumari

Answers were Sorted based on User's Feedback



What are the ways tablespaces can be managed and how do they differ?..

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

Is This Answer Correct ?    2 Yes 0 No

What are the ways tablespaces can be managed and how do they differ?..

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

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB Administration Interview Questions

What is RAID and what are different types of RAID configurations?

1 Answers  

What purpose does the model database server? : sql server DBA

0 Answers  

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

How would you extract DDL of a table without using a GUI tool?

0 Answers  

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  




You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

how can you enable flashback feature?

0 Answers   Oracle,

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

Describe what redo logs are.

1 Answers  

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories