Author Question: Briefly describe the function of the DBMS in a database system. What will be an ideal ... (Read 118 times)

Mimi · **on:** Jul 7, 2018

Briefly describe the function of the DBMS in a database system.

What will be an ideal response?

Question 2

In SQL Developer, DBMS objects are displayed:

A) in the Navigation Pane.
B) in the Object Browser.
C) in the Connections area.
D) in the tabbed document window.
E) in the command tab.

ebenov · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

The DBMS creates the database and the tables and structures within it. The DBMS also reads and updates the database data. It receives requests from application programs to perform data maintenance tasks. These requests are translated into actions that are performed on the database. In addition to maintaining the user data within the database, the DBMS also maintains the database structures. The DBMS also enforces any rules that have been defined to govern the values of the data, such as data type requirements and referential integrity constraints. The DBMS controls concurrency issues, which deal with the unwanted interruption of one user's work by another user's work. As the only point of entry into the database, the DBMS also provides security for the database to restrict users' access to only the data that they have authority to read or modify. Finally, the DBMS is responsible for the creation of backup copies of the database data and for restoring the database in case a recovery is required.

Answer to Question 2

C