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 |
How view is related to data independence?
What is Restricted Mode of Instance Startup ?
What is data types in database?
What happens when my integer identity runs out of scope?
Explain the syntax of named procedure?
How to determine who is and change the owner of database?
What is order by clause?
What is data in dbms?
What is a checkpoint in dbms and when does it occur?
What are the limitations of using a model?
What is the best database software?
What are the applications of database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)