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
12622 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

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

which background process invoke at the time of upgradation tell me???

0 Answers iGate,

what is a user-defined lock?

0 Answers Oracle,

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers

wat is global index and local indes

1 Answers Oracle,

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers Infozech, Wipro,

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers

For more DB Administration Interview Questions Click Here