More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
What is the Derby Database Directory ?
A Derby database is stored in files that live in a directory of the same name as the database. Database directories typically live in system directories.
A database directory contains the following:
* log directory
Contains files that make up the database transaction log, used internally for data recovery (not the same thing as the error log).
* seg0 directory
Contains one file for each user table, system table, and index (known as conglomerates).
* service.properties file
A text file with internal configuration information.
* tmp directory
(might not exist.) A temporary directory used by Derby for large sorts and deferred updates and deletes. Sorts are used by a variety of SQL statements. For databases on read-only media, you might need to set a property to change the location of this directory.
* jar directory
(might not exist.) A directory in which jar files are stored when you use database class loading.
Read-only database directories can be archived (and compressed, if desired) into jar or zip files.
(Continued on next question...)
