Where the data file for system Tablespace is located? What
is its name, initial size and maxsize?



Where the data file for system Tablespace is located? What is its name, initial size and maxsize?..

Answer / mkumar.it

The datafile for SYSTEM tablespace is located where rest of the default data files are located. The name of the datafile is system.dbf. By default, its initial size is 64 KB and max size of 2 GB.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Database Management Interview Questions

Is it possible to Disable the Parameter form while running the report ?

1 Answers  


Whats is an OLTP Database

0 Answers   Microsoft,


what are the differences you find when working with oracle 91 and sql server 2005?

1 Answers   Choice Solutions,


What do you understand by functional dependency and transitive dependency in dbms?

0 Answers  


Is a server a database?

0 Answers  






What is " group by " clause?

0 Answers  


Explain the term ‘relations’?

0 Answers  


Explain dml compiler?

0 Answers  


Explain armstrong rules? How they are complete and/or sound?

0 Answers  


user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?

1 Answers   HCL,


How do you use a database worksheet?

0 Answers  


What is 1nf in database?

0 Answers  


Categories