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 is query in rdbms?

579


Explain dml (data manipulation language)?

567


What is the use case where we can use stretch database?

591


What are procedures in database?

589


What do you mean by query evaluation engine?

592






Mention the different languages present in dbms

587


What is an example of a database?

549


Explain the importance of partitioning.

632


What is acid property in dbms?

603


Mention the different types of dbms.

587


Which is fastest database?

557


What do you know about DBMS?

632


What is 2nf in the dbms?

618


What are data modelling tools?

556


What is default value database?

571