Database Management Systems

In this option of STARTUP command, DML statements are not allowed in the database.

In this option of SHUTDOWN command, a checkpoint is performed on all the databases and the files are closed.

It holds attributes and their value however any change to a attribute's values requires you to bounce or restart the database.

These files hold control information necessary to keep the database functioning.

Data files contain the data dictionary and user created data.

It has a physical structure that is visible to the operating system made up of operating system files and a logical structure that is recognized only the oracle server.

This option of STARTUP command can be used is you wish to perform some kind of maintenance on the database such as an export and import.

In this option of SHUTDOWN command, when a user's transaction completes the user is automatically disconnected.

It is the highest level of logical objects in the database.

These are files that can be created by a process known as archiving.

Any change made in the database is first recorded in the online redo log files before it is actually implemented.

A schema is another logical structure that can classify or group database objects.

This option of STARTUP command is used when you want only users who possess the privilege to access the database.

It is a type of object that a user typically sees such as a table.

The JDBC-ODBC bridge is classified as a Type 1 JDBC driver because it uses a native library (the ODBC driver) to bridge Java applications to databases. Type 1 drivers are JDBC-ODBC bridge drivers that translate JDBC calls into ODBC calls.