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 is dbms_output put_line?
What are the different type of relationships in the dbms?
Explain the difference between two and three-tier architectures.
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
What are the types of tables in database?
What do you understand by query optimization?
What are the importance of database in banking?
What are the different levels of abstraction in the dbms?
Enlist ways to efficiently code transactions.
What is the use of ROWS option in EXP command ?
What is a degree of relation?
What is atomicity 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)