What is SYSTEM tablespace and When is it Created?

Answers were Sorted based on User's Feedback



What is SYSTEM tablespace and When is it Created?..

Answer / chaudhry

Every ORACLE database contains a tablespace named SYSTEM, which
is automatically created when the database is created. The
SYSTEM tablespace always contains the data dictionary tables
for the entire database.

Is This Answer Correct ?    10 Yes 0 No

What is SYSTEM tablespace and When is it Created?..

Answer / nishi

Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle General Interview Questions

what is the difference between dbms and rdbms?

3 Answers   Oracle,


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  


What do you understand by a database object? Can you list a few of them?

0 Answers  


i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,


Explain an index segment?

0 Answers  






How index is implemented in oracle database?

0 Answers  


Will you be able to store pictures in the database?

0 Answers  


Can we save images in a database and if yes, how?

0 Answers  


how many columns can a plsql table have

13 Answers   NIIT,


List the various oracle database objects?

0 Answers  


How to convert times to characters in oracle?

0 Answers  


Explain implicit cursor.

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)