Intro to Database Pt.1

Question 1

Limitation of File-Based Approach

Users of one program may be unaware of potentially useful data held by other programs.

Answer 1

Separation and Isolation of Data

Question 2

Limitation of File-Based Approach

Same data is held by different programs.

Answer 2

Duplication of Data

Question 3

Limitation of File-Based Approach

File structure is defined in the program code.

Answer 3

Data Dependence

Question 4

Limitation of File-Based Approach

Programs are written in different languages and so cannot easily access each others files.

Answer 4

Incompatible file formats

Question 5

Limitation of File-Based Approach

Any new requirement needs a new program.

Answer 5

Fixed Queries

Question 6

Definition of data was embedded in application programs, rather than being stored separately and independently.

Answer 6

DATABASE APPROACH

Question 7

It is unordered and meaningless fact/s. It does not convey any message.

Answer 7

Data

Question 8

It is ordered and meaningful facts.

Answer 8

Information

Question 9

Shared collection of logically related data and a description of this data, designed to meet the information needs of an organization.

Answer 9

Database

Question 10

Logically related data comprises entities, attributes and relationships of an organizations information.

Answer 10

Database

Question 11

The information that describes and explains data.

Answer 11

Metadata

Question 12

The data stored in a structured way

Answer 12

Data Dictionary or System Catalog

Question 13

A software system that enables users to define, create, maintain and control access to the database.

Answer 13

Database Management System (DBMS)

Question 14

TYPES OF DBMS

a type of database that supports only user at the time

Answer 14

Single-user database

Question 15

TYPES OF DBMS

a single user that runs on a personal computer.

Answer 15

Desktop database

Question 16

TYPES OF DBMS

a type of database that supports multiple users at the same time.

Answer 16

Multiuser database

Question 17

TYPES OF DBMS

a type of database that supports a relatively small number of users or a specific department within the organization.

Answer 17

Workgroup database

Question 18

TYPES OF DBMS

a type of database that is used by the entire organization and
support many users across many departments.

Answer 18

Enterprise database

Question 19

TYPES OF DBMS

a type of database that supports data located at a single site.

Answer 19

Centralized database

Question 20

TYPES OF DBMS

a type of database that supports data distributed across several different sites.

Answer 20

Distributed database

Question 21

TYPES OF DBMS

a database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.

Answer 21

Cloud database

Question 22

TYPES OF DBMS

a database that contains a wide variety of data used in multiple discipline.

Answer 22

General-purpose database

Question 23

DATABASE APPROACH Responsibilities

providing a way to define and build the database.

Answer 23

Data Definition

Question 24

DATABASE APPROACH Responsibilities

providing a way to insert and update data in the database.

Answer 24

Data Manipulation.

Question 25

DATABASE APPROACH Responsibilities

retrieving information from the data in the database

Answer 25

Query Execution

Question 26

DATABASE APPROACH Responsibilities

ensuring that data stored is well-formed

Answer 26

Data Integrity

Question 27

DATABASE APPROACH Responsibilities

enforcing restrictions about who is able to access what data

Answer 27

Data Security

Question 28

DATABASE APPROACH Responsibilities

logging capabilities to provide an audit trail for data changes

Answer 28

Provenance

Question 29

DATABASE APPROACH Responsibilities

supporting the activities of many users at the same

Answer 29

Multiuser Concurrency