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 |
What is the Structural difference between bitmap and b-tree index ?
What are the ways to controlling cursor behavior?
What is a data type in a database?
how to pass values from one table to another by using Bulk collect?
Enlist some commands of ddl?
Can you explain the 'between' clause?
What is optimization in database?
What are service-specific middleware?
What is use of LOG (Ver 7) option in EXP command ?
Define union all operator and union.
Should database table names be capitalized?
What does DLL stands for ?
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)