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 are the benefits of modeling?
What is a RADIO GROUP ?
Describe the four types of indexes.
Explain a join between tables?
What is called dbms?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
What are the parts of a table?
Explain the different types of join operations?
What are stand-alone procedures?
Can group by and ordered by used in a single query?
How is the pattern matching done in the sql?
When does checkpoint occur in dbms?
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)