Unit 4 Flashcards
1
Q
- What is a Database?
A
2
Q
- What is DBMS?
A
3
Q
What is a Database server?
A
4
Q
Explain Relational database?
A
5
Q
What is an Object database?
A
6
Q
What is a Hierarchical database?
A
7
Q
Explain the functions of a Database Administrator & a Data Administrator.
A
8
Q
What is an Entity?
A
9
Q
What is a Field?
A
10
Q
What is a Record?
A
11
Q
What is a Table?
A
12
Q
What is a Primary Key?
A
13
Q
How does a Foreign Key work with the Primary Key?
A
14
Q
Explain a Schema?
A
15
Q
What is the Normalization of data?
A
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
What are the advantages of the cloud-based databases?
26
What are some disadvantages to cloud-based databases?
27
Explain Saas (3rd party software as a service)?
28
Explain PaaS (platform as a service)
29
Explain IaaS (Infrastructure as a service)
30
Explain Hypervisor?
31
What is Customer Relationship Management?
32
What is Supply Chain Management?
33
Describe the function of a Data warehouse and Data Mart?
34
Explain terabytes, petabytes, and exabytes.
35
Explain three hierarchical levels. "conceptual data models"
"logical data models"
"physical data models"
