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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are notification services?

683


Is dynamodb a document database?

706


What information can be stored in a database?

738


What are the different types of database keys?

654


What are the types of database users?

712


What is an image database?

690


What is a distributed database system?

689


What is the most used database?

730


Define a relation schema and a relation.

736


Which database is best for storing large data?

652


What is the relationship?

720


What entity means?

653


Why rdbms is called relational?

671


What is openedge abl in terms of taking the perspective of the developer?

665


Enlist the various relationships of database.

812