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 133 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

diana chang

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

« previous next »
 

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Hematuria. An analysis of urine is performed to evaluate kidney function. In this illustration, the Hematuria. An analysis of urine is performed to evaluate kidney function. In this illustration, the
The autonomic nervous system with its sympathetic and parasympathetic divisions The autonomic nervous system with its sympathetic and parasympathetic divisions
Disorders and Diseases of the Endocrine System Disorders and Diseases of the Endocrine System
Venn Diagram of Nervous System and Endocrine System Venn Diagram of Nervous System and Endocrine System
How to describe transformations of a sinusoidal function (y=a*sin⁡b(x−c)+d) How to describe transformations of a sinusoidal function (y=a*sin⁡b(x−c)+d)
Sketch a graph of the inverse of each exponential function. Sketch a graph of the inverse of each exponential function.
Video: Summary of glucose catabolism

For a complete list of videos, visit our video library