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 |
Describe two phases of Two-phase commit ?
What is compound key?
Explain what are triggers and rules?
What is ddl in dbms?
From which command ENQUEUE_RESOURCES parameter information is derived from ?
What is the data in a database?
What is data independence and also explain its types?
What is On-line Redo Log?
How do you open .db files?
What are the benefits of database management system?
What are the main differences between primary key and unique key?
What is the advantages and disadvantages of database management system?
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)