⟩ Explain What is an extent?
An Extent is a collection of contagious blocks the second level of granuality of the storage in database is called extent.it is defined as the collectionof contagious datablocks.
An Extent is a collection of contagious blocks the second level of granuality of the storage in database is called extent.it is defined as the collectionof contagious datablocks.
How will you force database to use particular rollback segment?
How can we organize the tablespaces in Oracle database to have maximum performance?
How will you swap objects into a different table space for an existing database?
What is redo log buffer?
What is meant by recursive hints?
How can we plan storage for very large tables?
How will you estimate the space required by a non-clustered tables?
It is possible to use raw devices as data files and what are the advantages over file system files?
What is a Control file?
How will you monitor rollback segment status?