Database Management Systems

This database system utility can be used to restore the database in case of catastrophic failure.

This is not the advantage of using database processing as database processing provides high access security to the database by unauthorized users.

This database system utility is used to reorganize a database file into a different file organization to improve performance.

These interfaces accept requests written in english or some other language and attempt to understand them.

This DBMS component module processes schema definitions specified in the DDL and stores descriptions of the schemas in the DBMS catalog.

This object in oracle is a group of records from one or more tables physically stored in a mixed file.

This segment in oracle has nonclustered table and each cluster holds all its data.

This oracle instance keeps the most recently accessed data blocks from the database.

This background process resolves distributed transactions that are pending due to a network or systems failure in a distributed database.

The objective of ODBC is to make it possible to access any data from any application, regardless of which DBMS is handling the data.

End-user query tools are specifically designed for data analysts to create and execute queries against databases. Data extraction (A) retrieves data, presentation tools (C) display results, and data store (D) is the database itself.

The user within this component of the RMAN environment that owns the metadata tables maintained by RMAN.

A flash recovery area is a directory, file system or automatic storage management disk group include multiplexed copies of the control file and online redo logs.

Here, it is possible to lock at the file level i.e to lock at the fragment level.