Unit 4 Flashcards

1
Q
  1. What is a Database?
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  1. What is DBMS?
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a Database server?

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

Explain Relational database?

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

What is an Object database?

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

What is a Hierarchical database?

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

Explain the functions of a Database Administrator & a Data Administrator.

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

What is an Entity?

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

What is a Field?

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

What is a Record?

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

What is a Table?

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

What is a Primary Key?

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

How does a Foreign Key work with the Primary Key?

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

Explain a Schema?

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

What is the Normalization of data?

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

Explain ETL: Extracted, Transformed, Loaded?

A
17
Q

Explain Data Governance?

A
18
Q

What is Data mapping?

A
19
Q

What is Segmenting data?

A
20
Q

What is OLAP? (Online Analytical Processing)

A
21
Q

What is data mining?

A
22
Q

What is OLTP? (Online Transaction Processing)

A
23
Q

What is Data Warehouse?

A
24
Q

What are the Three V’s in Big Data?

A
25
Q

What are the advantages of the cloud-based databases?

A
26
Q

What are some disadvantages to cloud-based databases?

A
27
Q

Explain Saas (3rd party software as a service)?

A
28
Q

Explain PaaS (platform as a service)

A
29
Q

Explain IaaS (Infrastructure as a service)

A
30
Q

Explain Hypervisor?

A
31
Q

What is Customer Relationship Management?

A
32
Q

What is Supply Chain Management?

A
33
Q

Describe the function of a Data warehouse and Data Mart?

A
34
Q

Explain terabytes, petabytes, and exabytes.

A
35
Q

Explain three hierarchical levels. “conceptual data models”
“logical data models”
“physical data models”

A