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 104 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
Excellent

tranoy

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

« previous next »
 

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

For high blood pressure (hypertension), a new class of drug, called a vasopeptidase blocker (inhibitor), has been developed. It decreases blood pressure by simultaneously dilating the peripheral arteries and increasing the body's loss of salt.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

The most destructive flu epidemic of all times in recorded history occurred in 1918, with approximately 20 million deaths worldwide.

The structure and function of the human testis. The structure and function of the human testis.
Endomembrane system Endomembrane system
The location of the major limbic system structures. In general, they are arrayed near the midline in ... The location of the major limbic system structures. In general, they are arrayed near the midline in ...
Testing motor function of cranial nerve VII - Show teeth Testing motor function of cranial nerve VII - Show teeth
Differentiation of Inverse Trigonometric Function Differentiation of Inverse Trigonometric Function
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Introduction to Genetics

For a complete list of videos, visit our video library