Where the data file for system Tablespace is located? What
is its name, initial size and maxsize?
- 1 Answers
- 3065 Views
- I also Faced
- E-Mail Answers
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 are the different types of keys in the database?
What is rdbms and also explain its components?
Is excel a database?
What is pcbs (program communication blocks)?
What is data sparsity and how it effect on aggregation?
What are 4 types of models?
What is cluster table or non_cluster table?
What is database management system explain?
What is a checkpoint in dbms?
Is this statement true or false? All databases must be in third normal form?
What do you understand by data redundancy?
What is the diff bet plan,package,dbrm?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
