Quiz 1

Question 1

What is Data

Answer 1

Raw facts

Question 2

What is information?

Answer 2

the result of processing raw data to reveal its meaning

Question 3

what is Knowledge

Answer 3

familiarity awareness and understanding of information

Question 4

a discipline that focuses on properly generating storage and retrieval of data

Answer 4

Data management

Question 5

a shared integrated computer structure that stores a collection of End-user-data and meta data

Answer 5

Database

Question 6

Meta data

Answer 6

data about data

Question 7

DBMS

Answer 7

Database management system

Question 8

data inconsistency

Answer 8

when different versions of the same data appear in different places

Question 9

Query

Answer 9

specific request

Question 10

ad hoc query

Answer 10

spur of the moment question

Question 11

query result set

Answer 11

what the dbms sends back

Question 12

Data Quality

Answer 12

a comprehensive approach to promoting accuracy validity and timeliness of data

Question 13

Single-user data base

Answer 13

supports one user

Question 14

runs on personal computer

Answer 14

desktop database

Question 15

multiuser data base

Answer 15

Supports multiple users at the same time

Question 16

workgroup database

Answer 16

small number of users less then 50

Question 17

enterprise database

Answer 17

more then 50 users

Question 18

centralized database

Answer 18

data located at a single site

Question 19

distributed database

Answer 19

data distributed across several different sites

Question 20

general-purpose databases

Answer 20

contain a wide variety of data used in multiple diciplines

Question 21

discipline-specific databases

Answer 21

contain data focused on specific subject areas

Question 22

operational database

Answer 22

supports a company’s day to day transactions

Question 23

operational databases are also known as

Answer 23

Online transactions processing (oltp), transaction, production database

Question 24

analytical databases

Answer 24

focus on storing historical data

Question 25

Data warehouse

Answer 25

stores data in a format optimized for decision making

Question 26

Set of tools that provide advanced data analysis

Answer 26

OLAP online analytical processing

Question 27

Business intelligence

Answer 27

approach to capture and process business data to help support business decisions

Question 28

data that exist in raw state

Answer 28

Unstructured data

Question 29

result of formating unstructured data to facilitate storaage

Answer 29

Structured data

Question 30

semistructured data

Answer 30

some structuring has been done

Question 31

special language used to manipulate data elements in a textual format

Answer 31

Markup Language XML

Question 32

supports the storage and management of semistructured xml data

Answer 32

XML database

Question 33

Social Media

Answer 33

anywhere anytime access style database

Question 34

Not only SQL

Answer 34

NoSQL

Question 35

focus on design of database

Answer 35

database design

Question 36

access to a file is dependent on its structure

Answer 36

Structural dependence

Question 37

You can change the file structure without affecting the application

Answer 37

Structural independence

Question 38

exists when you can change the data storage characteristics with out afftecting the programs ability to access the data

Answer 38

data independence

Question 39

When you cant change data storage characteristics and still access the data

Answer 39

Data dependence

Question 40

How the human views the data

Answer 40

Logical data format

Question 41

how the computer must work with the data

Answer 41

Physical data format

Question 42

Scattered locations of information

Answer 42

Islands of information

Question 43

keeping data in more then one place

Answer 43

Data redundancy

Question 44

when required changes in redundant data are not successful

Answer 44

Data anomaly

Question 45

organization of components that define and regulate the collection, storage management and use of data withing a database environment

Answer 45

Database System

Question 46

Used to look up required data component structures and relationships

Answer 46

Data dictionary

Question 47

relates to activities that make the database perform more effciently

Answer 47

Performance Tuning

Question 48

Nonprocedural language, lets the user specify what must be done without having to specify how

Answer 48

Query language

Question 49

SQL structured query language

Answer 49

de facto language of most dbms

Question 50

Loose coupling

Answer 50

Keeping the database separate from the application(dbms)