Data Base Management System (DBMS)
Function 2023
Data storage management - correct answer DBMS creates and manages complex
structures required for data storage.
Data transformation and presentation - correct answer The DBMS transforms entered
data into the required data structures. DBMS formats the physically retrieved data to
make it conform to the user's logical expectations
Ex. Date entered as July 11, 2009, should be converted to 07/11/2009
Security Management - correct answer DBMS creates a security system that enforces
user security and data privacy. Security rules determine who can access what.
Multi-User Access Control - correct answer DBMS uses sophisticated algorithms to
ensure multiple users can access the database concurrently without compromising the
integrity of the database
Backup and Recovery - correct answer DBMS systems provide special utilities that
allow the DBA to perform routing and special backup and restore procedures.
Applicable to failure, such as a bad sector in the disk or power failure.
Data Integrity Management - correct answer Enforces integrity rules, minimizing data
redundancy and maximizing data consistency.
Database access languages and application programming interfaces - correct answer
DBMS provides data access through a query language. A query language is a non
procedural language-one that lets the user specify what must be done without having to
specify how it is to be done.
Structured Query language(SQL) is the defacto query language and data access
standard supported by majority of DBMS vendors.
Database communication interfaces - correct answer Current DBMSs accept end-user
requests via multiple different network environments.
-End users can generate answers to queries by filling in screen forms through their
preferred Web browser.
-The DBMS can automatically publish predefined reports on a Website.
-The DBMS can connect to third-party systems to distribute information via e-mail or
other productivity applications.
