Info Tech 2

This function of a DBMS provides security systems that enforce user access rights and data privacy by means of security rules.

• Data storage and retrieval

• Recovery services

• Authorization services

• Support for data communication and networking

Database can be classified based on users. Based on this classification, what type of database provides simultaneous access for multiple users?

• Single user database

• Multi-user database

• Heterogeneous database

• Distributed database

Which is NOT an advantage of DBMS?

• Controls redundancy

• Cost of conversion is high.

• Data can be shared.

• Concurrency control

It is the step in converting data to information where the report generated is disseminated.

• Retrieval

• Acquisition

• Manipulation

• Distribution

It is the function of a DBMS which provides backup and data recovery if an issue occurred, and to ensure data safety and integrity.

• Concurrency control services

• Authorization services

• Recovery services

• Support for data communication and networking

Which is NOT a disadvantage of DBMS?

• Higher impact of failure

• Integrity can be enforced.

• Requires qualified personnel

• Cost of conversion is high.

This DBMS advantage means that data in a database is always accurate.

• Controls redundancy

• Integrity can be enforced

• Inconsistency can be avoided

• Standards can be enforced

It is the function of a DBMS where complex structures for data storage and easy data retrieval are created and managed.

• Data storage and retrieval

• Data dictionary

• Transaction support

• Concurrency control services

This DBMS disadvantage means that database may be damaged by power failure or any other means and may result in data corruption and bring operations to a halt.

• Complexity

• Performance

• Cost of DBMS

• Higher impact of failure

This is a function of DBMS which guarantees that all the updates in a given transaction are made or not made.

• Transaction support

• Concurrency control services

• Recovery services

• Authorization services