This topic contains a solution. Click here to go to the answer
« previous next »

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

Mimi

  • Hero Member
  • *****
  • Posts: 542
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.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ebenov

  • Sr. Member
  • ****
  • Posts: 331
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


Mimi

  • Member
  • Posts: 542
Reply 2 on: Jul 7, 2018
Gracias!

Jsherida

  • Member
  • Posts: 314
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

The tracheal system of insects. The tracheal system of insects.
Trans-Alaska Pipeline System (TAPS) Crosses the Active Strike-Slip Denali Fault Trans-Alaska Pipeline System (TAPS) Crosses the Active Strike-Slip Denali Fault
The nervous system. The nervous system.
Describe how fat is digested, absorbed, and transported in the body Describe how fat is digested, absorbed, and transported in the body
Male Reproductive System - Testes Male Reproductive System - Testes
Male Reproductive System - Spermatic cord Male Reproductive System - Spermatic cord
Video: Elementary kinetics

For a complete list of videos, visit our video library