Interested to Buy Any Domain ? << Click Here >> for more details...
Where the data file for system Tablespace is located? What
is its name, initial size and maxsize?
- 1 Answers
- 3442 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 |
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
How data are stored in database?
What is vacuum in database?
What is the purpose of a model?
What is 1nf 2nf 3nf in dbms?
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
How do you create a simple database?
what is s/w lifecycle?
What do you understand by fragmentation?
How do you exit a database?
Describe a subquery.
explain about the critical recovery scenario you had experienced
-
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)
