U1: L1 (Understanding the Data Model)

It is the function of a DBMS which stores definitions of the data elements and their relationships.

• Concurrency control services

• Recovery services

• Data dictionary

• Transaction support

Which of the following is not a type of information produced by DBMS?

• Data Resources

• Business Resources

• Management Resources

• System Resources

It is an element of database that is represented as a field in a database record and is a property of an entity.

• entity

• attribute

• relationship

• tables

Which is not a disadvantage of DBMS?

• Higher impact of failure

• Cost of conversion is high

• Integrity can be enforced

• Requires qualified personnel

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

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

• Concurrency control services

• Recovery services

• Authorization services

• Transaction support

It is an element of database that is an association between entities and is represented using a common field in a set of records.

• entity

• attribute

• relationship

• tables

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

• Distribution

• Acquisition

• Retrieval

• Manipulation

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

It is an element of database that is represented as a record in a database and can be a person, place or thing.

• entity

• attribute

• relationship

• tables