ISOM Q5 - DB

1. It is a system software designed to organize, control and use the data needed by application programs.

• A. Database Management System

• B. DBMS

• C. Options A and B

• Database Management System Software

2. (Choose all that apply)

Enumerate the primary functions of DBMS.

• Basic Security

• Reduced data redundancy

• Decrease access time

• Backup System

3. It is defined by the data dictionary as a data organized into basic data elements

• DBMS

• Primary key

• Data

• Field

4. It is called as an organized collection of data

• Database

• Organization of data

• Data organization

• Collection of data

5. It is a field which uniquely identifies each record in a table in a relational database: It can be pre-existing data, like for example National Insurance Number.

• Foreign Key

• Primary Key

• Database

• DBMS

6. (Choose all that apply)

Choose all the possible Data Types below.

• Date

• Time

• Decimal

• Text

• String

7. It refers to the format of data storage that can hold a distinct type or range of values and example is when computer programs store data in variables, each variable must be designated in a distinct type.

• Data Type

• Data storage

• Integers

• Characters

8. (Choose all that apply)

Identify the three types of relationships between the data you are likely to encounter when designing a database.

• one-to-one

• one-to-many

• many-to-many

• Divorce data

9. It is the process of structuring a database, usually a relational database, in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity. It was first proposed by Edgar F. Codd as part of his relational model.

• Structured database

• Relational Database

• DBMS

• Database normalization

10 . It is the strategy of reducing database system response time where the databases provide us with information stored with a hierarchical and related structure, which allows us to extract the content and arrange it easily.

• DBMS

• Database Optimization

• Database Normalization

• Database Design