Data and Database Management

Question 1

It is a collection of text, numbers, symbols, images, or videos in raw or unorganized form.

Answer 1

Data

Question 2

What has to be processed or provided with a context, before it can have meaning?

Answer 2

Data

Question 3

It describes the object under consideration using a finite set of discrete classes.

Answer 3

Qualitative or Categorical Data

Question 4

This type of data can’t be counted or measured easily using numbers and therefore divided into categories.

Answer 4

Qualitative or Categorical Data

Question 4

Since qualitative data can’t be counted or measured easily using numbers, it is therefore divided into what?

Answer 4

Categories

Question 5

This type of data are usually extracted from audio, images, or text medium.

Answer 5

Qualitative or Categorical Data

Question 5

What are the two subcategories of qualitative data?

Answer 5

Nominal
Ordinal

Question 5

The values grouped into these categories have no meaningful order and no hierarchy.

Answer 5

Nominal

Question 6

What are the examples of Nominal level values?

Answer 6

Gender
Occupation

Question 6

These types of values have a natural ordering while maintaining their class of values.

Answer 6

Ordinal

Question 7

What is the example for the Ordinal level value?

Answer 7

Ranking of student’s grades

Question 8

This data type tries to quantify things and it does by considering numerical values that make it countable in nature.

Answer 8

Quantitative Data

Question 9

What are the two subcategories of quantitative data?

Answer 9

Discrete
Continuous

Question 10

The numerical values which fall under are integers.

Answer 10

Discrete

Question 10

Which category is it where whole numbers are placed?

Answer 10

Discrete

Question 11

What is the example of Discrete?

Answer 11

Number of clothes in a cabinet

Question 11

The fractional numbers are considered as continuous values.

Answer 11

Continuous

Question 12

What are the examples of Continuous?

Answer 12

Days in a week
Months in a year

Question 13

It is an organized or classified data, which has some meaningful values for the receiver.

Answer 13

Information

Question 14

It is the processed data on which decisions and actions are based.

Answer 14

Information

Question 15

For the decision to be meaningful, the processed data must qualify what characteristics?

(CAT)

Answer 15

Completeness
Accuracy
Timely

Question 16

This characteristic of information means that it should be available when required.

Answer 16

Timely

Question 16

This characteristic of information means that it should be accurate.

Answer 16

Accuracy

Question 17

This characteristic of information means that it should be complete.

Answer 17

Completeness

Question 17

It refers to the raw input that when processed or arranged, makes meaningful output.

Answer 17

Data

Question 18

It is usually the processed outcome of data.

Answer 18

Information

Question 19

What happens when data is processed into information?

Answer 19

It becomes interpretable and gains significance.

Question 20

What is done before data becomes interpretable and gains significance?

Answer 20

Data is processed into information

Question 21

What is the equation for information?

Answer 21

Data + Meaning = Information

Question 22

It is produced as a result of understanding the given information and using that information to gain knowledge of how to solve problems.

Answer 22

Knowledge

Question 22

Knowledge can be what?

Answer 22

- Acquiring and remembering a set of facts - The use of information to solve problems

Question 23

What are the two types of knowledge?

Answer 23

Explicit Knowledge Tacit Knowledge

Question 24

It is the acquisition by a person of information or the understanding of information.

Answer 24

Explicit Knowledge

Question 25

This knowledge can be easily passed on to others.

Answer 25

Explicit Knowledge

Question 25

Most forms of explicit knowledge can easily be stored in certain media like what?

Answer 25

Documents Books Computers

Question 26

This is documented information that can facilitate action.

Answer 26

Explicit Knowledge

Question 27

This type of knowledge can be easily identified, articulated, shared, and used.

Answer 27

Explicit Knowledge

Question 28

What are the good examples of Explicit Knowledge?

Answer 28

Encyclopedias Textbooks

Question 29

This knowledge is difficult to pass on to someone else.

Answer 29

Tacit Knowledge

Question 30

This knowledge is embedded in the human mind through experience and jobs.

Answer 30

Tacit Knowledge

Question 31

This knowledge includes insights and intuitions.

Answer 31

Tacit Knowledge

Question 32

What is the fragmented pieces of symbols and characters threaded together?

Answer 32

Data

Question 33

What is the refined data?

Answer 33

Information

Question 34

What do you call the useful information?

Answer 34

Knowledge

Question 35

What can give you a lack of context when looked at singularly?

Answer 35

Data

Question 36

What can give you context to data?

Answer 36

Information

Question 37

What can give you depth in understanding an information?

Answer 37

Knowledge

Question 38

What is the outcome for information and knowledge?

Answer 38

Information = Comprehension Knowledge = Understanding

Question 39

What is incomprehensible independently?

Answer 39

Data

Question 40

What is amplifies consciousness? What is meaningless without being compiled into a sensible structure? What improves representation?

Answer 40

1. Knowledge 2. Data 3. Information

Question 41

What are not sufficient to make any predictions?

Answer 41

Data and Knowledge

Question 42

What do you call when prediction is possible if one possesses the require experience?

Answer 42

Knowledge

Question 43

What is the data that is connected together to form a statement? What cannot make any statements? What brings the ability to have a deduced conclusion using pieces of information?

Answer 43

1. Information 2. Data 3. Knowledge

Question 44

What cannot independently be a basis for question formation? What is a text that answers the 'how' and 'why'? What is a text that answers the 'who' 'what' 'when' and 'where'?

Answer 44

1. Data 2. Knowledge 3. Information

Question 45

It is the interdisciplinary process of creating, using, sharing, and maintaining an organization's information and knowledge.

Answer 45

Knowledge Management

Question 46

It is a multi-faceted strategy for making the best use of organizational knowledge assets in order to achieve business objectives.

Answer 46

Knowledge Management

Question 47

What are the business objectives under Knowledge Management? (BESIC)

Answer 47

Boosting innovation Enhancing competitive advantage Sharing insights Improving performance Continuously improving the organization

Question 48

It is part of the organizational learning process.

Answer 48

Knowledge Management

Question 49

What focuses on the strategic management of knowledge as a shareable business asset?

Answer 49

Knowledge Management

Question 50

What is the core goal of knowledge Management? (What, Where, Why, Who)

Answer 50

What: Connect people looking for knowledge Where: Within the organization Why: Increase overall knowledge level Who: Team and Organization

Question 51

Four Knowledge Management Objectives (SIMI)

Answer 51

Streamlining and enhancing the KE (knowledge environment) Improving the KCP (knowledge capture process) Maintaining knowledge as an OA (organizational asset) Increasing asset to OK (organizational knowledge)

Question 52

It is an organized collection of information that can be easily accessed, managed, and updated.

Answer 52

Database

Question 53

What can typically contain aggregations of data records or files, containing information about sales transactions or interactions with specific customers?

Answer 53

Computer Databases

Question 54

Who provides the users with access to some permissions in a database?

Answer 54

Database Managers

Question 55

Database Managers provides users with what? (ASA)

Answer 55

Ability to control read/write access Specifically report generation Analyze usage

Question 56

What does the abbrev. in ACID compliance mean?

Answer 56

Atomicity Consistency Isolation Durability

Question 57

What do some databases offer to guarantee that data is consistent and that transactions are complete?

Answer 57

ACID Compliance

Question 58

Who, where, when did the relational database was invented?

Answer 58

Who: E.F. Codd Where: IBM When: 1970

Question 59

What are the types of databases? (OG-NCRD)

Answer 59

Object-oriented Database Graph Database NoSQL Database Cloud Database Relational Database Distributed Database

Question 60

It is a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways.

Answer 60

Relational Database

Question 61

It is made up of a set of tables with data that fits into a predefined category, where each table has at least one data category in the columns.

Answer 61

Relational Database

Question 62

It is the standard user and application program interface for a relational database.

Answer 62

SQL

Question 63

What does SQL stand for?

Answer 63

Standard Query Language

Question 64

These are easy to extend, and a new data category can be added after the original database creation without requiring to modify all the existing applications.

Answer 64

Relational Database

Question 65

In a Relational Database, what can be added after the original database creation?

Answer 65

New data category

Question 66

It is a database in which portions of the database are stored in multiple physical locations.

Answer 66

Distributed Database

Question 67

Distributed Database can be what?

Answer 67

Homogeneous Heterogeneous

Question 68

What do you call the kind of Distributed Database where the physical locations have the same underlying hardware and run the same OS and DB Applications?

Answer 68

Homogeneous Distributed Database

Question 69

What kind of Distributed Database is it when the hardware, OS, and DB applications are different in every location?

Answer 69

Heterogeneous Distributed Database

Question 70

It is a database that has been optimized or built for a virtualized environment, either in a hybrid, public, or private.

Answer 70

Cloud Database

Question 71

What are the benefits that the Cloud Database provides?

Answer 71

Ability to pay for Storage Capacity and Bandwidth on a per-use basis Provide scalability on demand Highly available

Question 72

Cloud Database gives enterprises the opportunity to support business applications in what?

Answer 72

Software-as-a-Service (SaaS)

Question 73

What kind of data base is useful for large sets of distributed data?

Answer 73

NoSQL Database

Question 74

What are effective for big data performance issues that relational databases aren't built to solve?

Answer 74

NoSQL Database

Question 75

What are most effective when an organization must analyze large chunks of unstructured data or data stored across multiple virtual servers in the cloud?

Answer 75

NoSQL Database

Question 76

Where do the items created using object-oriented programming languages are often stored?

Answer 76

Relational Database

Question 77

It is organized around objects rather than actions, and data rather than logic.

Answer 77

Object-oriented Database

Question 78

It is a type of NoSQL database that uses graph theory to store, map, and query relationships.

Answer 78

Graph Database

Question 79

It's basically collections of nodes and edges.

Answer 79

Graph Database

Question 80

What do the nodes and edges represent in a Graph Database?

Answer 80

Nodes - an entity Edges - connection between nodes

Question 81

What is growing in popularity for analyzing interconnections?

Answer 81

Graph Database

Question 82

It is a declarative programming language and protocol for graph database analytics that Graph Databases often use.

Answer 82

SPARQL