Db2 Flashcards by Elizabeth Browne

Q

What is Db2?

A

IBM’s relational database management system

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

When was Db2 first released?

A

1983

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Which company created Db2?

A

IBM

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What platforms does Db2 run on?

A

Linux, Unix, Windows, z/OS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is the Db2 product family?

A

A suite of database products for OLTP, analytics, cloud, and big data

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is Db2 Database used for?

A

On-premises OLTP workloads

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is Db2 Warehouse used for?

A

Analytics and business intelligence

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is Db2 on Cloud?

A

A managed cloud SQL database

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is Db2 Warehouse on Cloud?

A

A managed cloud data warehouse

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is Db2 Big SQL?

A

SQL engine for Hadoop and big data sources

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is Db2 for z/OS?

A

Enterprise mainframe database

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What free option does Db2 offer for evaluation?

A

Community edition or cloud lite plan

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is the data limit for Db2 Community Edition?

A

100 GB

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is the data limit for Db2 on Cloud Lite?

A

200 MB

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What are key Db2 features?

A

AI optimisation, column store, data skipping, replication

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is column store?

Study These Flashcards

A

Stores data by column for faster analytics

Q

What is data skipping?

Study These Flashcards

A

Avoids scanning unnecessary data

Q

What does common SQL engine mean?

Study These Flashcards

A

Same SQL works across all Db2 products

Q

What does HADR stand for?

Study These Flashcards

A

High Availability Disaster Recovery

Q

What does Db2 HADR do?

Study These Flashcards

A

Replicates data to standby servers

Q

What happens when the primary DB fails in HADR?

Study These Flashcards

A

A standby is promoted to primary

Q

What is partitioning in Db2 Warehouse?

Study These Flashcards

A

Splitting data across multiple nodes

Q

What is massively parallel processing?

Study These Flashcards

A

Queries executed across many servers at once

Q

What is Cloud Pak for Data?

Study These Flashcards

A

IBM platform for data and AI management

What technology does Cloud Pak for Data use?

Red Hat OpenShift containers

What plans does Db2 on Cloud offer?

Lite, Standard, Enterprise

Which plans include 3-node HA clustering?

Standard and Enterprise

Which clouds support Db2 on Cloud?

IBM Cloud and AWS

How can you access Db2 on Cloud?

CLI, GUI, ODBC, JDBC, REST

What file types can be imported into Db2 on Cloud?

CSV, Excel, text files

Where can Db2 Big SQL run?

Cloudera and IBM Cloud Pak for Data

What type of workloads is Db2 Warehouse best for?

Business intelligence and analytics

How does Db2 scale storage in warehouse?

Add or remove nodes