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

Give the reasoning behind using an index.

2 Answers  

What would you do with an "in-doubt" distributed transaction?

0 Answers  

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

What view would you use to determine free space in a tablespace?

3 Answers  

what is logical system in sap basis

0 Answers  

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

Explain the use of table functions.

1 Answers  

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

What the different components in replication and what is their use? : sql server DBA

0 Answers  

how can you connect from 10g user to 11g user??

0 Answers   HP,

what do you understand by fine-grained auditing?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories