Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Name a tablespace automatically created when you create a
database.

Question Posted / guest

Answers were Sorted based on User's Feedback



Name a tablespace automatically created when you create a database...

Answer / ramesh

System Tablespace is Created when a New oracle Database is
created.
It,s Not-> while Creation of Tablespace
However ,Ensure No user objects created in System Tablespace

Cheers,
Ramesh

Is This Answer Correct ?    6 Yes 0 No

Name a tablespace automatically created when you create a database...

Answer / deepak

system tablespace

Is This Answer Correct ?    4 Yes 0 No

Name a tablespace automatically created when you create a database...

Answer / nagarani k

system and sysaux tablespaces are automatically created in
oracle 10gR2 when database created

Is This Answer Correct ?    4 Yes 1 No

Name a tablespace automatically created when you create a database...

Answer / guest

It is SYSTEM tablespace which get automatically get created
whenever we create any tablespace


Regards
Abhinav Phadnis

Is This Answer Correct ?    2 Yes 2 No

Name a tablespace automatically created when you create a database...

Answer / md azhar alvi

At the time of database creation SYSTEM.DBF AND SYSAUX.DBF tablespaces are created.

SYSTEM.DBF contains the data dictionary views and objects which in owned by sysdba.

in oracle 11g if we are omitting the creation of sysaux.dbf tablespace oracle will automatically create the sysaux.dbf tablespace.

sysaux.dbf contain repository values of oracle tools.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

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

1 Answers  

what is a user-defined lock?

0 Answers   Oracle,

what is the difference between catalog & nocatalog?

3 Answers   CSC,

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

0 Answers  

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

Explain the difference between a data block, an extent and a segment.

2 Answers  

how can you find out if a table can be redefined?

0 Answers   Oracle,

what is the role of dip user in our database?

0 Answers  

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories