Name a tablespace automatically created when you create a
database.

Answers were Sorted based on User's Feedback



Name a tablespace automatically created when you create a database...

Answer / guest

SYS_UNDOTBS and SYSTEM tablespace gets created automatically

Is This Answer Correct ?    3 Yes 0 No

Name a tablespace automatically created when you create a database...

Answer / david

and users tablespace also get create during the installation
of database .....

Is This Answer Correct ?    0 Yes 0 No

Name a tablespace automatically created when you create a database...

Answer / hai hia

1.SYSAUX
2.SYSTEM --- permanent table spaces for system users

3.USERS --- permanent tablespace for non-system users

4.TEMP --- temporary tablespace for all users

5.UNDOTBS --- undo tablespace for all users

...these are the default table spaces created at database creation.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle AllOther Interview Questions

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  


HOW TO SPOT AHIERARCHY?

0 Answers  


You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  


Are These Dff's Flexible?

0 Answers   Oracle,


1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers  


default triggers available for reports

0 Answers  


where the dff data will be stored

0 Answers   Infosys,


what are basic modules required to implement oracle application in any oraganisation?

0 Answers  


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  


difference of using cursor for loop and open,fetch,close.which one is better

0 Answers   Accenture,


Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)