Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Access > Database Management 2 > Flashcards

Database Management 2 Flashcards

1
Q

What does data dictionary show

A

characteristic of field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does a query show

A

tables
fields
selection criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the goal of business intelligence

A

improve decision making

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the activities of business intelligence

A

access to data
consolidate
analyse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the tools to conduct BI?

A

data warehouse and data marts
multidimensional data analysis
data mining
utilising web interfaces to databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does a data warehouse store?

A

current historical

data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How is a data mart related to a data warehouse?

A

subset

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Who uses data marts?

A

specific population of users

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Data in data warehouse can be access but not

A

altered

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Where does data warehouse consolidate and standardise its data from?

A

systems

operational and transactional databse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Why is data mart only used for specific users?

A

highly focused

isolated

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is multidimensional data analysis known as

A

OLAP

online analytical processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does data mining seek to find?

A

relationship
patterns
trends

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How are the relationship patterns and trends in data mining displayed?

A

query

report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Why is OLAP multidimensional?

A

view data
different ways
multiple dimensions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the goal of data mining?

A

predict future behaviour

17
Q

What is predicting using data mining techniques also known as?

A

predictive analysis

18
Q

Who do firms make information available to using the web

A

customers

partners

19
Q

Why are web interfaces used to present information

A

familiarity

savings from redesigning and rebuilding

20
Q

What are non-relational databases known as

A

NoSQL

database in the cloud

21
Q

What are teh advantages of NoSQL?

A

flexible data model
scaling
large data sets

22
Q

why are there NoSQL now?

A

data volumes high
workload for web high
cloud

23
Q

What kinds of companies is cloud database suited for

A

web-focused startup

SME

24
Q

What is the characteristic of big data

A

unstructured/ semi

dfferent sources

25
Q

What are examples of big data

A

tweets

email

26
Q

What are examples of NoSQL?

A

Amazon DB

Oracle NoSQL

27
Q

What does big data offer better compared to normal data?

A

more patterns
anomalies
insights

28
Q

How does big data pose as a challenge compared to normal data?

A

new technologies and tools
make sense through questions
expensive

29
Q

What are the capabilities of a DBMS

A

data definition
data dictionary
querying
reporting

30
Q

What does querying and reporting do with the data?

A

manipulation

31
Q

What is the data manipulation language known as

A

SQL

structured query language

32
Q

What does data definition specify in the database?

A

structure of content

33
Q

What does the data dictionary store?

A

definition
characteristics
of data element

34
Q

How does a data dictionary store definitions

A

automated

manual

Access (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions