Database Tablespace

Jun 18 2014 5:41 AM

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?

Answers (2)

How to create view in sql server?