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

how can a session indicate its interest in receiving alerts?

1 Answers   Oracle,

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

How would you determine who has added a row to a table?

4 Answers  

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1 Answers  

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

What is a system database and what is a user database? : sql server DBA

1 Answers  

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1 Answers  

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

What is a correlated sub-query? : sql server DBA

1 Answers  

How do you add a data file to a tablespace?

3 Answers  

For more DB Administration Interview Questions Click Here
Categories