Question 1

Compare how centralized systems were used when mainframes dominated data processing to how they are currently used.

Accepted Answer

The answer of Compare how centralized systems were used when...

Question 2

Identify the type of data stored in data warehouses and how organizations use it. Use the terms "snapshot" and "data mining" in your answer.

Accepted Answer

The answer of Identify the type of data stored in...

Question 3

Explain how new application development projects might select a relational DBMS and give an example of their selection.

Accepted Answer

The answer of Explain how new application development projects might...

Question 4

What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?
A)Pie chart
B)Sunburst chart
C)Waterfall chart
D)Radar chart

Accepted Answer

A Sunburst chart is ideal for comparing the relative amount of sales between different categories of products within different regions as it displays hierarchical data in a series of concentric circles, making it easy to visualize proportions and relationships.

Question 5

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

Accepted Answer

The answer of Explain when you are likely to use...

Question 6

What type of Excel chart compares values across geographical locations?
A)Globe chart
B)Atlas chart
C)GPS chart
D)Map chart

Accepted Answer

Map charts in Excel are specifically designed to display and compare data across different geographical locations, making them the correct choice for visualizing geographical data.

Question 7

Discuss four of Codd's 12 rules for a distributed database and his goal in formulating them.

Accepted Answer

The answer of Discuss four of Codd's 12 rules for...

Question 8

Which of the following is a data visualization tool that typically summarizes data from three or more fields?
A)PivotChart
B)histogram
C)dashboard
D)graph database

Accepted Answer

The answer of Which of the following is a data...

Question 9

Which of the following is not software that is primarily used for data visualization?
A)Tableau
B)Microsoft Power BI
C)Adobe Dreamweaver
D)Microsoft Excel

Accepted Answer

Adobe Dreamweaver is primarily used for web development, not data visualization, unlike the other options which are commonly used for creating data visualizations.

Question 10

A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.
A)box-and-whisker chart
B)stylesheet
C)dashboard
D)snapshot

Accepted Answer

A dashboard is a one-page grouping of key performance indicators (KPIs) that allows decision makers to evaluate and act on important data. It provides a quick overview of an organization's performance and is commonly used in business intelligence tools.

Quiz 1: Introduction to Database Management

Compare how centralized systems were used when mainframes dominated data processing to how they are currently used.

Identify the type of data stored in data warehouses and how organizations use it. Use the terms "snapshot" and "data mining" in your answer.

Explain how new application development projects might select a relational DBMS and give an example of their selection.

What type of Excel chart would you create to compare the relative amount of sales between different categories of products within different regions as proportionally sized rings?

Explain when you are likely to use a NoSQL DBMS and when you are likely to use an object-oriented DBMS.

What type of Excel chart compares values across geographical locations?

Discuss four of Codd's 12 rules for a distributed database and his goal in formulating them.

Which of the following is a data visualization tool that typically summarizes data from three or more fields?

Which of the following is not software that is primarily used for data visualization?

A _____ is a one-page grouping of key performance indicators (KPIs) that allow decision makers to evaluate and act on important data.