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 difference between database and schema?
What do you mean by super key, primary key, foreign key and candidate key?
Describe two phases of Two-phase commit ?
What is the rdbms concept in sql?
Describe a subquery.
Explain the term entity set in dbms?
What is database url?
What is inner join in database?
What are the steps in creating a database?
How to migrate paradox, dbase or foxpro database to firebird?
when All datafiles related to a Tablespace are removed ?
Explain concurrency transparency.
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)