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 do you understand by query optimization?
Mention a query to add email validation to your database
Can files be stored in a database?
Explain the terms ‘attribute’ and ‘relations’
Operators used in select statements are?
What is a relation schema?
Is there an example how to configure externalfileaccess setting in firebird.conf?
why an information gap exists in most organizations.
What is ordbms with example?
Explain the term generalization.
What is the mechanism provided by ORACLE for table replication ?
How do databases work?
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)