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 132 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
:D TYSM

Dinolord

  • Member
  • Posts: 313
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

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?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

Interrelationships of the integumentary system with other body systems Interrelationships of the integumentary system with other body systems
The hypothalamic-pituitary portal system. The hypothalamic-pituitary portal system.
What are examples of ideal forms? What are examples of ideal forms?
How to find the average value of a function How to find the average value of a function
Receptors in the Autonomic Nervous System Receptors in the Autonomic Nervous System
Cardiac conduction system Cardiac conduction system
Video: Hydrogen bonds - role in the body

For a complete list of videos, visit our video library