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 139 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
YES! Correct, THANKS for helping me on my review

bigcheese9

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

The mammalian respiratory system. The mammalian respiratory system.
Components of the lymphatic system. Components of the lymphatic system.
Procedures and Diagnostic Tests Related to the Urinary System Procedures and Diagnostic Tests Related to the Urinary System
How to apply integration by parts on a single function How to apply integration by parts on a single function
Nervous System Regulation of the Heart Nervous System Regulation of the Heart
Solve the system to find x and y Solve the system to find x and y
Video: Muscle Twitch and Muscle Tension - Motor unit size and force

For a complete list of videos, visit our video library