Where the data file for system Tablespace is located? What
is its name, initial size and maxsize?
Answer Posted / 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 |
Post New Answer View All Answers
What are five advantages of a database?
What happens when my integer identity runs out of scope?
What do you understand by database triggers?
What do you understand by index hunting?
Explain the components of rdbms?
How does a database store data?
Differentiate nested loop, hash join and merge join.
How do you delete a table from database?
What are partitions in database?
What is type of end users?
What are the different technologies used to access Database from Visual Basic?
How can you perform pattern matching in sql?
What are the various normalizations in database?
When does checkpoint occur in dbms?
What do you mean by conflict serializability in dbms?