What is a Tablespace?


What is a Tablespace?

<<Previous  Next>>

Oracle - What is a Tablespace? - April 10, 2009 at 11:00 AM

What is a Tablespace?  

Tablespaces is a logical storage unit. It is used to group related logical structures together. 

Oracle - What is a Tablespace? - June 18, 2009 at 19:00 PM

What is SYSTEM tablespace?

SYSTEM tablespace is automatically created when the database is created. It contains data dictionary for the entire database.  

Also read
How are extents allocated to a segment?

An extent is stored some specific information. This information is stored using specific number of adjoining data blocks. A collection of extent is called as a segment stored in the same tablespace.............

Explain how to prevent tablespace fragmentation in oracle.

Tablespace fragmentation can be prevented by using PCTINCREASE command. PCTINCREASE is the percentage a new subsequent extent will grow...............

Oracle Security

Explain the security features in Oracle, What are roles? How can we implement roles?, What is user Account in Oracle database?, What is a trace file and how is it created?, What are Tablespace Quota and default tablespace?............

Explain how to assign a Tablespace to a user in Oracle.
What are the Predefined Tablespaces in a database?

SYSTEM Tablespace, SYSAUX Tablespace, UNDO Tablespace, TEMP Tablespace.........

What are elements of database logical layers?

The logical layer of the database consists of the following elements:............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring