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 you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

What is the dataguard background process??

1 Answers   iGate,

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

what is the use of ocr?

0 Answers   Oracle,

Give the reasoning behind using an index.

2 Answers  




WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

How many packages we have in db

1 Answers   Tesco,

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

0 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

how can you schedule a job in database?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories