What is a Tablespace?

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.

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
Oracle interview Oracle architecture Oracle FAQs Download Oracle/Java FAQ Test Oracle skills New More Oracle FAQs Oracle processes Oracle memory area Oracle file types Oracle database objects Oracle operators Oracle composite Oracle constraints Oracle data types Oracle DCL and TCL Oracle DML commands Oracle error handling Oracle functions Oracle procedure, package Oracle import and export Oracle sub queries Oracle table Oracle triggers Oracle views Oracle synonym Oracle indexes Oracle joins Oracle cursors Oracle form Oracle security Oracle system privilege Oracle object privileges Oracle table privileges Oracle view privileges Oracle backup & recovery Oracle DBA Oracle PL/SQL Oracle nested table & varrays Oracle large objects Oracle replication Oracle transaction Oracle optimizer Oracle auditing Oracle backup Oracle database tuning Oracle application tuning Oracle procedures Oracle functions Oracle loops Oracle exceptions Oracle Select into clause Oracle string functions Oracle numeric functions Oracle date functions Oracle translate and decode Oracle correlated sub-queries Oracle union, intersect, minus Oracle clusters Oracle sequences Oracle tablespaces Oracle object datatypes Oracle Tutorial


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
© Copyright 2016. All Rights Reserved. Terms of use \| Follow us on Facebook!

What is a Tablespace?