Database Management Systems

Tablespace is a logical grouping of database objects, usually to facilitates security, performance, or the avalibility of database object such as tables and indexes.

Redo log files facilitate the Oracle mechanism to recover from an instance failure or a media failure.

Schema is a named group of objects associated with a particular user account, such as tables, indexes, functions and so forth.

Data files in a database contains all the information of the database save or retrive using SELECT and other DML statements.

In Oracle, data dictionary is a set of tables and views that are used as a read only reference about the database.

When database is shutdown in immediate mode, the oracle server automatically rolls back all currently active transactions.

When the database is shutdown in NORMAL mode, an instance recovery will not need to be done during the subsequent startup.

RESTRICTED SESSION option can be used if you wish to perform some kind of maintance on the database such as export and import.

It's primary function is to connect java applications to the correct JDBC driver.

This driver is most appropriate on a corporate network where client installations are not a problem.

This driver converts JDBC calls into calls on the client application programming interface for Oracle, Sybase etc.

To established a connection with a database, you need to register the ODBC-JDBC driver by calling this method.

This technique mixes simple and advanced features together and it has complex options even for simple queries.

It provides some confidence that JDBC drivers will run your program.

This driver allows a direct call from the client machine to the database management server.