Module 1

Question 1

Structure to put data in

Answer 1

Database

Question 2

Traditional databases typically hold this kind of data

Answer 2

alphanumeric or structured

Question 3

RDBMS are used to manage ___________ data

Answer 3

structured

Question 4

Having data is not the problem. The problems are

Answer 4

size, security, ease of updating, accuracy, redundancy and importance

Question 5

Collection of interrelated data

Answer 5

database

Question 6

A program to enable creation and maintenance of a database, and then to enter, manipulate and retrieve the data it stores.

Answer 6

DBMS

Question 7

Combination of a DBMS and a database

Answer 7

database system

Question 8

The file-based approach to databases (in the 60s and 70s) had these issues…

Answer 8

redundant data, manually programmed queries, storage loss due to redundancy, strong dependency between apps and data, difficulty integrating apps

Question 9

SQL

Answer 9

Structured Query Language

Question 10

A basic unit of data. Can be a letter, number or special symbol.

Answer 10

character

Question 11

A group of related characters is called a

Answer 11

field

Question 12

A collection of fields is called a

Answer 12

record

Question 13

A group of records about the same type of entity is stored in a

Answer 13

file

Question 14

When creating a physical database, a field is commonly referred to as a

Answer 14

column

Question 15

When creating a physical database, a record is commonly referred to as a

Answer 15

row

Question 16

When creating a physical database, a file is commonly referred to as a

Answer 16

table

Question 17

A _____ is a person, place or thing with characteristics or attributes that will be included in the system.

Answer 17

entity

Question 18

A ____ is a diagram that identifies the entities in the database and shows how entities are related to one another.

Answer 18

E-R model

Question 19

NoSQL stands for

Answer 19

not only SQL

Question 20

Big Data storage systems are also called

Answer 20

NoSQL systems

Question 21

Known facts that have meaning, that can be recorded, that have implicit meaning

Answer 21

data

Question 22

Information stored in a database catalog

Answer 22

meta-data

Question 23

Where is meta-data stored

Answer 23

catalog

Question 24

DBA stands for

Answer 24

database administrator

Question 25

Data abstraction used to provide a conceptual representation

Answer 25

data model

Question 26

People whose jobs require access to the database for querying, updating, generating reports

Answer 26

end users

Question 27

People whose jobs require access to the database for querying, updating, generating reports

Answer 27

end users

Question 28

Popular high level conceptual data model

Answer 28

Entity Relationship model

Question 29

The description of a database is call the

Answer 29

database schema

Question 30

The ______ ________ ________ is used by the DBA and by database designers to define conceptual and internal schemas.

Answer 30

data definition language DDL

Question 31

Once the database is compiled and populated with data the ___________ ___________ language is used to manipulate the data

Answer 31

data manipulation language (DML)

Question 32

Property that describes an entity is called an

Answer 32

attribute

Question 33

A user machine that provides user interface and local processing is called a

Answer 33

client

Question 34

A type of database that stores and provides access to data points that are related to one another

Answer 34

relational database