Database Tablespace

Question

One interviewer asked me some database related questions, but I am little bit confused about that.

1) Where is the tablespace located?

2) What is maximum size for tablespace?

3) Is it necessory for each tablespace contains at least one database file?

 

Ans: I answer him as

1) Whenever we create database at that time tablespace is generated in the system.

2) 64 K

3)  Yes

 

Is it correct?

 

 

 

Answer 1

http://searchsqlserver.techtarget.com/definition/tablespace

 

Check this link

Answer 2

Hi Rupesh,

 

below link will explain most of question properly,

 

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7003.htm

 

 

if it work out, please accept ans