Machine-translated by Google. Questions are authored in English.
Top

Discussion

Out of the following functions, one of the responsibility is not of the utilities component of DBMS software :

  • A.Removing flagged records from deletion
  • B.Creating and maintaining the data dictionary
  • C.Creating the physical and logical designs
  • D.Performance monitoring

Answer: C

The responsibility that does not belong to the utilities is creating the physical and logical designs.

DBMS utilities are housekeeping programs used by the database administrator: loading data, backup and recovery, reorganising files, which includes removing records flagged for deletion and reclaiming their space, maintaining the data dictionary, and monitoring performance.

Logical and physical design are carried out by database designers before and during implementation, using modelling and design tools. They are a design activity, not a utility function of the DBMS software.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.