WorksheetsData Management Quiz
Total questions: 45
Worksheet time: 33mins
What is the purpose of data governance in managing data challenges?
To increase data complexity
To address common challenges using data governance
To reduce the importance of data
To ignore data challenges
What are relational databases evaluated on?
Their color and design
Their advantages and disadvantages
The number of tables they contain
The speed of the internet connection
What does Big Data refer to?
A large collection of small data
A small collection of large data
Data with basic characteristics that define Big Data
Only the size of the data matters
What is necessary to successfully implement and maintain data warehouses?
Only financial investment
Only physical space
Specific elements that are necessary for implementation and maintenance
A large workforce
What are the considerations when implementing knowledge management systems in organizations?
Only the benefits
Only the challenges
Both the benefits and challenges
Neither benefits nor challenges
Which aspects are involved in the processes of querying a relational database?
Entity-relationship modeling, normalization, and joins
Guesswork, assumptions, and estimations
Data deletion, corruption, and loss
Networking, programming, and hacking
Which of the following is the smallest unit of data in the hierarchy presented?
Byte
Database
Bit
Field
What comes immediately after 'Byte' in the Data Hierarchy?
Bit
Data file or table
Field
Database
What is the largest unit of data in the hierarchy shown in the image?
Byte
Bit
Field
Database
What is one of the difficulties of managing data as it increases over time?
Data decreases exponentially with time
Data remains constant over time
Data increases exponentially with time
Data is completely static with time
Which of the following is a concern related to the longevity of data?
Data permanence
Data creation
Data rot, or data degradation
Data sharing
What is a challenge in managing data that pertains to its authenticity and reliability?
Data entertainment
Data security, quality, and integrity
Data marketing
Data visualization
Which of the following is a difficulty in managing data that involves external rules and standards?
Government innovation
Government regulation
Government data production
Government data analysis
Which of the following is NOT one of the three main problems that Database Management Systems minimize?
Data redundancy
Data isolation
Data inconsistency
Data complexity
Database Management Systems maximize how many things according to the slide?
One
Two
Three
Four
Which of the following is NOT one of the things that Database Management Systems maximize according to the slide?
Data security
Data integrity
Data independence
Data efficiency
What does ER stand for in the context of database design?
Evaluation-Response
Entity-Relationship
Execution-Readiness
Encapsulation-Reusability
What aspect of cardinality deals with the number of entity occurrences associated?
Connectivity
Business rules
Data dictionary
Relationships
What symbol represents a mandatory single relationship in cardinality symbols?
A line ending with a circle before the entity box
A line ending with an arrow before the entity box
A line ending with a branch before the entity box
A line with no special ending before the entity box
How is an optional many relationship depicted in cardinality symbols?
A line ending with a circle before the entity box
A line ending with an arrow before the entity box
A line ending with a branch before the entity box
A line with a circle and a branch before the entity box
Which cardinality symbol indicates a mandatory many relationship?
A line ending with a circle before the entity box
A line ending with an arrow before the entity box
A line ending with a branch before the entity box
A line with a circle and a branch before the entity box
What does a line ending with a circle before the entity box represent in cardinality symbols?
Mandatory single
Optional single
Mandatory many
Optional many
In the one-to-many relationship shown, what does the PROFESSOR entity must have?
Class ID
Professor Department
Professor Identification Number
Class Time
What is the first step in the process of normalization in databases?
First normal form
Second normal form
Third normal form
Functional dependencies
Which of the following is not a normal form discussed in the learning material?
First normal form
Second normal form
Third normal form
Fourth normal form
What is the total price for the order number 1116?
$41.00
$56.00
$12.00
$14.00
How many Meat Feast pizzas were ordered in total according to the data?
1
2
3
4
Which pizza has the lowest price per unit?
Pepperoni
Meat Feast
Vegetarian
The Hawaiian
On what date was the order for the Ham and Mushroom pizza placed?
9/1/14
9/2/14
9/3/14
9/4/14
What is the zip code for the customer who ordered the Vegetarian pizza?
37411
29416
12345
67890
According to the functional dependencies in the pizza shop example, what does the Order Number determine?
Customer F Name, Customer L Name, Customer Address
Order Date, Quantity, Total Price
Pizza Code, Pizza Name, Price
Customer ID, Zip Code, Total Price
What can be determined by the Customer ID according to the functional dependencies shown?
Order Number, Quantity, Total Price
Customer F Name, Customer L Name, Customer Address
Pizza Code, Pizza Name, Price
Order Date, Zip Code, Total Price
Which of the following is determined by the Pizza Code in the functional dependencies?
Customer ID, Customer F Name, Customer L Name
Order Number, Order Date, Quantity
Total Price, Customer Address, Zip Code
Total Price, Pizza Name, Price
According to Gartner Research, what are the characteristics of Big Data?
Low-volume, low-velocity information assets
Diverse, high-volume, high-velocity information assets
Homogeneous, medium-volume, static information assets
Sparse, low-volume, high-latency information assets
What types of data are included in Big Data according to Gartner Research?
How is Big Data generated according to Gartner Research?
Why does Big Data not fit neatly into traditional, structured, relational databases?
What is required to capture, process, transform, and analyze Big Data in a reasonable amount of time?
What does Big Data generally consist of?
Emails and personal documents
Traditional enterprise data
Online shopping transactions
Weather forecasts
Which of the following is a source of Big Data?
Printed books
Machine-generated/sensor data
Handwritten notes
DVDs and CDs
What type of data is included in Big Data from social platforms?
Social data
Encrypted data
Private messages
Financial statements
Where do images that contribute to Big Data come from?
Images captured by billions of devices located around the world
Images stored on personal computers
Images in physical photo albums
Images broadcasted on television
Which devices contribute to the image data in Big Data?
Digital cameras, camera phones, medical scanners, and security cameras
Film cameras and VHS tapes
Paintings and sculptures
Telescopes and microscopes
Which of the following is not a characteristic of Big Data?
Volume
Velocity
Variety
Validity
Which of the following is NOT listed as an issue with Big Data?
Untrusted data sources
Big Data is dirty
Big Data changes, especially in data streams
Big Data is always structured
