Name a tablespace automatically created when you create a database.

Categories >> Software >> Databases >> DB Administration
Suggest New Category

Name a tablespace automatically created when you create a
database.

Question Posted / guest

5 Answers
12671 Views
I also Faced
E-Mail Answers

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 do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

What is the difference between Datapump & export/import?

2 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

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,

how does an oracle clusterware manage crs resources?

0 Answers Oracle,

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers Patni,

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

How do you tell what your machine name is and what is its IP address?

4 Answers

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers Tech Mahindra,

what is the difference between db2start command and start database manager command?

1 Answers

For more DB Administration Interview Questions Click Here