Chapter 01
Database Models
- Due No due date
- Points 75
- Questions 75
- Time Limit None
Attempt History
|
Attempt |
Time |
Score |
|
|
LATEST |
59 minutes |
68 out of 75 * |
* Some questions not yet graded
Score for
this quiz: 68 out of 75 *
Submitted
Jun 30 at 8:02pm
This
attempt took 59 minutes.
1 / 1 pts
Data is the result of interpreting facts to reveal
meaning.
True
Correct!
False
Correct. Data is the result of
processing raw facts to reveal their meaning.
1 / 1 pts
A data warehouse can store data derived from many
sources.
Correct!
True
Correct. The data warehouse
stores historical data obtained from many sources.
False
1 / 1 pts
Unstructured data is data that exists in the
format in which it was collected (raw state). While Structured data is the
result of formatting unstructured data to enable storage, use, and generation
of information.
Correct!
True
Correct. Unstructured data is in
its raw state while structured data is formatted to enable storage and
generation of meaningful information.
False
1 / 1 pts
A good Database Management System (DBMS) will
perform well even with a badly designed database.
True
Correct!
False
Correct. A well designed
database is essential for a DBMS to perform well.
1 / 1 pts
Thorough database planning and design is
important to ensure that data is properly used to give the organization the
most benefit.
Correct!
True
Correct. Thorough database
planning and design is important for a DBMS to perform well and to give the
organization the most benefit.
False
0 / 1 pts
Structural dependence exists when it is possible to
make changes in the file structure without affecting the application program's
ability to access the data.
Correct
Answer
True
You
Answered
False
Incorrect. It is true that
structural dependence exists when it is possible to make changes in the file
structure without affecting the application program's ability to access the
data.
1 / 1 pts
Data redundancy exists when data is duplicated and
stored unnecessarily at different places.
Correct!
True
Correct. Data redundancy exists
when data is duplicated and stored unnecessarily at different places.
False
1 / 1 pts
One of the advantages of a database system
over previous data management approaches is reduced costs.
True
Correct!
False
Correct. Database systems
require sophisticated hardware and software and highly skilled personnel. This
increases costs.
1 / 1 pts
The term database system refers to an
organization of components that define and regulate the collection, storage,
management, and use of data within a database environment.
Correct!
True
Correct. Database system refers
to an organization of components that define and regulate the collection,
storage, management, and use of data within a database environment.
False
1 / 1 pts
It is unnecessary for the database designer
to determine which data to enter into the database and how to organize that
data in the database management system.
True
Correct!
False
Correct. It is vital for the
database designer to determine which data to enter into the database and how to
organize that data.
1 / 1 pts
What is the result of revealing the meaning of raw
facts?
End-user data
An encoded sample
An encrypted bit
Correct!
Information
Correct. Information is the
result of revealing the meaning of raw facts.
1 / 1 pts
_____ is the body of information and facts
about a specific subject.
Validation
A format
Correct!
Knowledge
Correct. Knowledge is the body
of information and facts about a specific subject.<br>
A database
1 / 1 pts
Accurate, relevant, and timely information is the
key to ____.
data management
Correct!
good decision making
Correct. Accurate, relevant, and
timely information is the key to good decision making.
knowledge
understanding
1 / 1 pts
One
of the reasons we need database is because they are the best ways to store and
manage ___.
knowledge
Correct!
data
Correct. We need databases
because they are the best ways store and manage data.
tracking
information
1 / 1 pts
James is a database administrator. He has loaded
data into the database and he has some information. What does he require to
reveal the meaning of the information?
Knowledge
Information
Discipline
Correct!
Context
Correct. Information requires
context to reveal meaning.
1 / 1 pts
Information is produced by processing _____.
Correct!
Data
Correct. Information is produced
by processing data.
Information
Scripts
Context
1 / 1 pts
End-user data is _____.
knowledge about the end users
Correct!
raw facts of interest to the end user
Correct. End-user data is raw
facts of interest to the end user.
information about a specific
subject
accurate, relevant and timely information
1 / 1 pts
April is a database administrator, she wants to
provide a description of the data characteristics and the set of relationships
that link the data found within the database. What should she use?
Queries
End-user data
Correct!
Metadata
Correct. Metadata provides a
description of the data characteristics and the set of relationships that link
the data found within the database.
Schemas
1 / 1 pts
You need an intermediary between the user and the
client's database; which of the options below would you use?
Correct!
DBMS(s)
Correct. DBMS(s) serve(s) as the
intermediary between the user and the database.
Metadata
End-user data
Programming languages
1 / 1 pts
As a database developer, how would you explain how
a database structure in a DBMS is stored?
single file
Correct!
collection of files
Correct. The database structure
in a DBMS is stored as a collection of files.
set of key/value pairs
collection of queries
1 / 1 pts
A(n) _____ might be written by a programmer or it
might be created through a DBMS utility program.
query
operating system
database management system
Correct!
application
Correct. An application might be
written by a programmer or it might be created through a DBMS utility program.
1 / 1 pts
While a database analyst is analyzing data, they
find different versions of the same data appearing in different places? What do
you call this type of situation?
Correct!
Data inconsistency
Correct. Data inconsistency
exists when different versions of the same data appear in different places.
Poor data security
Structural dependence
Conceptual dependence
1 / 1 pts
The response of the DBMS to a query is the
___________
ad hoc query
ad hoc response
Correct!
query result set
Correct. The response of the
DBMS to a query is the query result set.
integrated view of the data
1 / 1 pts
A(n) _____ database is used by an organization to
support many users across many departments.
desktop
workgroup
Correct!
enterprise
Correct. An enterprise database
is used by an organization to support many users across many departments.
transactional
1 / 1 pts
Which of the databases below would you recommend
for a client that supports a relatively small number of users (usually fewer
than 50) or a specific department within the client's organization?
desktop
Correct!
workgroup
Correct. A workgroup database
supports a relatively small number of users (usually fewer than 50) or a
specific department within an organization.
enterprise
transactional
1 / 1 pts
A workgroup database is a _____ database.
single-user
Correct!
multiuser
Correct. A workgroup database is
a multi-user database.
desktop
distributed
1 / 1 pts
A desktop database is a _____ database.
Correct!
single-user
Correct. A desktop database is a
single-user database.
multiuser
workgroup
distributed
1 / 1 pts
A data warehouse contains historical data obtained
from the _____.
Correct!
operational databases
Correct. A data warehouse
contains historical data obtained from the operational databases.
desktop database
enterprise databases
workgroup databases
1 / 1 pts
_____ data exist in the format in which they were
collected.
Structured
Semistructured
Correct!
Unstructured
Correct. Unstructured data exist
in the format in which they were collected.
Historical
1 / 1 pts
_____ data exist in a format that does not lend
itself to processing that yields information.
Structured
Semistructured
Correct!
Unstructured
Correct. Unstructured data exist
in a format that does not lend itself to processing that yields information.
Historical
1 / 1 pts
. _____ is the result of formatting
disorganized data in order to facilitate storage, use, and generation of
information.
Correct!
Structured data
Correct. Structured data is the
result of formatting disorganized data in order to facilitate storage, use, and
generation of information.
Raw data
Unstructured data
Obsolete data
1 / 1 pts
Most data that can be encountered are best
classified as _____.
structured
Correct!
semistructured
Correct. Most data that can be
encountered are best classified as semistructured.
unstructured
historical
1 / 1 pts
Jude is a database administrator. Jude wants to
store and manage an XML database. What type of XML data should Jude plan to
use?
structured
multistructured
fully structured
Correct!
semistructured
Correct. An XML database
supports the storage and management of fully structured XML data.
1 / 1 pts
Which of the following refers to the situation
where different versions of the same data are stored at different places
because they were not updated consistently?
Data query
Data integrity
Data dictionary
Correct!
Data redundancy
Correct. Data redundancy refers
to the situation where different versions of the same data are stored at
different places because they were not updated consistently.
1 / 1 pts
.How would you define data that is verifiable?
Correct!
The data always yields consistent results.
Correct. Data is said to be
verifiable if the data always yields consistent results
The data cannot be changed or
manipulated.
The data is obtained from
trusted sources.
The data is stored in different places within the
database.
0 / 1 pts
. What would you define as the condition in
which all of the data in the database are consistent with the real-world events
and conditions?
Correct
Answer
Data integrity
You
Answered
Data anomaly
Incorrect. Data integrity is
defined as the condition in which all of the data in the database are
consistent with the real-world events and conditions.
Data ubiquity
Data quality
1 / 1 pts
. The term _____ refers to an organization of
components that define and regulate the collection, storage, management, and
use of data within a database environment.
structured data
transaction
management system
Correct!
database system
Correct. The term database
system refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment.
1 / 1 pts
. _____ relates to the activities that make
the database execute transactions more efficiently in terms of storage and
access speed.
Correct!
Performance tuning
Correct. Performance tuning
relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed.
Database design
Query access
Database management
1 / 1 pts
One of the advantages of database systems is
that ___
Database systems do not
integrate many different users' data into a single all-encompassing data
repository.
Correct!
Database systems enable the data in the database to
be shared among multiple applications or users.
Correct. One of the advantages
of database systems is that Database systems enable the data in the database to
be shared among multiple applications or users.
Database systems maximizes data
inconsistency
Database systems decreases end user productivity
1 / 1 pts
You are a DBMS and you need to look up the required
data component structures and relationships, thus relieving programmers from
having to code such complex relationships in each program. Which of the options
below would you use?
Performance tuning
An encoded sample
An encrypted bit
Correct!
data dictionary
Correct. The DBMS uses the data
dictionary to look up the required data component structures and relationships,
thus relieving programmers from having to code such complex relationships in
each program.
1 / 1 pts
. As a database, _____ relates to activities
that make them operate more efficiently in terms of storage and access speed.
Query Language
Correct!
Performance tuning
Correct. Performance tuning
relates to activities that make a database operate more efficiently in terms of
storage and access speed.
Data dictionary
An encrypted bit
1 / 1 pts
Which of the answers below is one of the
problems with File system Data Processing?
Ease of getting quick answers
Correct!
Lengthy development time
Correct. Lengthy development
time is one of the problems with File system Data Processing.
Reduced costs
Simple system administration
1 / 1 pts
Structural dependence, which means that
access to a file is dependent
on its ___?
Correct!
Structure
Correct. Structural dependence,
which means that access to a file is dependent on its structure.
Data
Customer
Storage
1 / 1 pts
Which of the options below happens when data
redundancy is uncontrolled?
Good data security
Data consistency
Correct!
Data-entry errors
Correct. Data-entry errors are a
result of uncontrolled data redundancy.
Data integrity
1 / 1 pts
Which option below is a type of data anomaly?
Repeat anomalies
Entry anomalies
Correct!
Insertion anomalies
Correct. Format anomalies is a
type of data anomaly.
Format anomalies
1 / 1 pts
A database contains how many types of data?
Four
Correct!
Two
Correct. A database contains two
types of data: end user data (raw facts) and
metadata.
One
Three
1 / 1 pts
Metadata is ___?
Correct!
Data about data
Correct. Metadata is data about
data.
Raw data
Refined data
Filtered data
1 / 1 pts
A database management system (DBMS) can be
likened to__?
A kitchen pantry
A computer file
A book cabinet
Correct!
A very well-organized electronic filing cabinet
Correct. A database management
system (DBMS) can be likened to a very well-organized electronic filing
cabinet.
1 / 1 pts
End-user data is data that is __ of interest
to the end user?
Filtered data
Correct!
Raw facts
Correct. End-user data is data
that is raw facts of interest to the end user.
Metadata
Refined data
1 / 1 pts
The database structure itself is stored as a
__?
Collection of metadata
A single file
Unlinked files
Correct!
Collection of files
Correct. The database structure
itself is stored as a collection of files.
1 / 1 pts
Which of the answers below is one of the
advantages provided by the Database management system (DBMS)?
Decreased end-user productivity
Maximized data inconsistency
Correct!
Improved data sharing
Correct. Improved data sharing
is one of the advantages provided by the Database management system (DBMS).
Less data integration
1 / 1 pts
The options below are examples of a cloud
database except?
Amazon AWS
Google cloud
Correct!
Desktop database
Correct. Desktop database is not
an example of a cloud database. It is a single-user database that runs on a
personal computer.
Microsoft Azure
1 / 1 pts
The options below are examples of databases
except?
Correct!
Recycle database
Correct. Recycle database is not
an example of a database.
Workgroup database
Distribution database
Centralized database
1 / 1 pts
Unstructured data is data that exists in its
__?
Original (filtered) state
Original (refined) state
Correct!
Original (raw) state
Correct. Unstructured data is
data that exists in its original (raw) state.
Original (altered) state
1 / 1 pts
Unstructured and semistructured data can be
stored in the databases below except __?
Extensible Markup Language (XML)
Social media
Correct!
Microsoft Access database
Correct. Unstructured and
semistructured data cannot be stored in Microsoft Access database.
NoSQL
1 / 1 pts
Which of the answers below is an example of a
single-user database?
Correct!
Desktop database
Correct. A desktop database is
an example of a single-user database.
Workgroup database
Office database
Enterprise database
1 / 1 pts
Which of the answers listed below is an
example of structured data?
Invoices stored in a computer
PDF documents stored in a
computer
Pictures stored in a computer
Correct!
Data in an excel spreadsheet
Correct. An example of
structured data is data stored in excel spreadsheets.
1 / 1 pts
The term database system refers to an
organization of components that define and regulate the collection, storage,
management, and use of ___ within a database environment.
Correct!
Data
Correct. The term database
system refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment.
Information
Filters
Queries
1 / 1 pts
When a database stores the majority
of data in RAM rather than in hard disks, it is referred to as a(n)
_____ database.
Correct!
In-memory database
Correct. When a database
stores the majority of data in RAM rather than in hard disks,
it is referred to as an in-memory database.
Big Data database
Cloud database
Very large database
1 / 1 pts
When a database offers all the advantages of
a local DBMS and resides on the internet, it is referred to as a(n) _____
database.
In-memory database
Big Data database
Correct!
Cloud database
Correct. When a database offers
all the advantages of a local DBMS and resides on the internet, it is referred
to as a cloud database.
Very large database
1 / 1 pts
Which of the answers below is one of the
challenges of managing a database system?
Reduced costs
Correct!
Vendor dependence
Correct. Vendor dependence is
one of the challenges of managing a database system.
Management Simplicity
Infrequent upgrade
1 / 1 pts
The DBMS may be referred to as the database
system's ___?
Brain
Memory
Spine
Correct!
Heart
Correct. The DBMS may be
referred to as the database system's heart.
1 / 1 pts
Which of the answers below is not consider as
one of the five (5) major parts of the database system?
Procedure
Software
Correct!
Internet
Correct. The internet is not
considered as one of the five (5) major parts of the database system.
Data
1 / 1 pts
Which of the answers below would you consider
hardware while gathering requirements for a database?
Operating system
Correct!
Server
Correct. A server is considered
a hardware.
Internet
Application program
1 / 1 pts
Which of the answers below is not one of the
reasons a spreadsheet is not considered a database?
Correct!
A spreadsheet allows for the manipulation of data
in a tabular format
Correct. A spreadsheet allowing
for the manipulation of data in a tabular format is not one of the reasons a
spreadsheet is not considered a database.
A spreadsheet does not support
self-documentation through metadata
A Spreadsheet does not support
enforcement of data types or domains
A Spreadsheet does not support defined
relationships among tables
1 / 1 pts
Which of the answers below is not an example
of a web browser that a database management system (DBMS) might use to provide
access to the database?
Google Chrome
Microsoft Edge
Correct!
Mozzarella Firefox
Correct. Mozzarella Firefox is
not a web browser.
Microsoft Edge
1 / 1 pts
As a database administrator, which option below is
one of the three types of software that you need to make the database system
function fully?
Correct!
Operating system software
Correct. Operating system
software is one of the three types of software needed to make the database
system fully functional.
Microsoft Operating Software
Programming Operating Software
Operating Firmware Software
1 / 1 pts
In explaining data, you could say that the
word data covers the collection of ___ stored in the database.
Strings
Texts
Characters
Correct!
Facts
Correct. Data covers the
collection of facts stored in the database.
1 / 1 pts
As a database administrator, which of the
answers below would you consider as end-users?
System Administrators
Database Administrators
Correct!
Sales Managers
Correct. Sales Managers and
other people who use the application programs to run the organization's daily
operations are considered as end-users.
System analysts and programmers
1 / 1 pts
While trying to resolve a database failure,
which of the answers below would you say might have caused the database
failure?
Correct!
A bad disk
Correct. A bad disk is one of
the reasons that might cause database failure.
Data inconsistency
Multi-user access
Data redundancy
Question 71
Not yet
graded / 1 pts
Describe what metadata are and what value
they provide to the database system.
Your
Answer:
Metadata is data for data. The
main functionality of metadata is to compliment the value and use of the data.
Metadata also expands the data value. To make it simple, metadata provides more
clear picture about the data that is present in the database.
Answer:
See the 'Rationale' field for sample responses.
Rationale:
The metadata describe the data characteristics and
the set of relationships that links the data found within the database. For
example, the metadata component stores information such as the name of each
data element, the type of values (numeric, dates, or text) stored on each data
element, and whether the data element can be left empty. The metadata provide
information that complements and expands the value and use of the data. In
short, metadata present a more complete picture of the data in the database. Given
the characteristics of metadata, you might hear a database described as a
"collection of self-describing data."
Not yet
graded / 1 pts
What are the advantages of having the DBMS between
the end user's applications and the database?
Your
Answer:
There are several benefits of
having database management system which include
scalability,
data consistency,
data integritiy,
and data security.
Answer:
See the 'Rationale' field for sample responses.
Rationale:
Having a DBMS between the end user's applications
and the database offers some important advantages. First, the DBMS enables the
data in the database to be shared among multiple applications or users. Second,
the DBMS integrates the many different users' views of the data into a single
all-encompassing data repository.
Not yet
graded / 1 pts
Discuss some considerations when designing a
database.
Your
Answer:
identifying the purpose of the
designing data base
identifying key users and key
process of the application for which data base is developed
identify the key entities and
attributes
setting up relations and
most importantly applying
normalization on the selected data
Answer:
See the 'Rationale' field for sample responses.
Rationale:
Proper database design requires the designer to
identify precisely the database's expected use. Designing a transactional
database emphasizes accurate and consistent data and operational speed.
Designing a data warehouse database emphasizes the use of historical and
aggregated data. Designing a database to be used in a centralized, single-user
environment requires a different approach from that used in the design of a
distributed, multiuser database.Designing appropriate data repositories of
integrated information using the two-dimensional table structures found in most
databases is a process of decomposition. The integrated data must be decomposed
properly into its constituent parts, with each part stored in its own table.
Further, the relationships between these tables must be carefully considered
and implemented so the integrated view of the data can be re-created later as
information for the end user. A well-designed database facilitates data
management and generates accurate and valuable information. A poorly designed
database is likely to become a breeding ground for difficult-to-trace errors
that may lead to bad decision making-and bad decision making can lead to the
failure of an organization. Database design is simply too important to be left
to luck. That's why college students study database design, why organizations
of all types and sizes send personnel to database design seminars, and why
database design consultants often make an excellent living.
Not yet
graded / 1 pts
What are the problems associated with file
systems? How do they challenge the types of information that can be created
from the data as well as the accuracy of the information?
Your
Answer:
The main problems associated
with the file systems include
lengthy development times,
difficulty query generation and
results,
a complex system administration,
low security,
limited data sharing, and above
all
it require extensive
programming.
Because of the aforementioned
issues it is possible that the data that is available in the file system is
always difficult to evaluate and provide appropriate results. When we are
dealing with complex data there is a possibility that an error might occur in
the selection of queries and processing them and getting target results. So it
is always difficult in file system to get accurate data result as it is
expected
Answer:
See the 'Rationale' field for sample responses.
Rationale:
The following problems associated with file
systems, whether created by DP specialists or through a series of spreadsheets,
severely challenge the types of information that can be created from the data
as well as the accuracy of the information: Lengthy development times. The
first and most glaring problem with the file system approach is that even the
simplest data-retrieval task requires extensive programming. With the older
file systems, programmers had to specify what must be done and how to do it. Difficulty
of getting quick answers. The need to write programs to produce even the
simplest reports makes ad hoc queries impossible. Harried DP specialists who
worked with mature file systems often received numerous requests for new
reports. They were often forced to say that the report will be ready "next
week" or even "next month." If you need the information now,
getting it next week or next month will not serve your information needs.
Complex system administration. System administration becomes more difficult as
the number of files in the system expands. Even a simple file system with a few
files requires creating and maintaining several file management programs. Each
file must have its own file management programs that allow the user to add,
modify, and delete records; to list the file contents; and to generate reports.
Because ad hoc queries are not possible, the file reporting programs can
multiply quickly. The problem is compounded by the fact that each department in
the organization "owns" its data by creating its own files. Lack of
security and limited data sharing. Another fault of a file system data
repository is a lack of security and limited data sharing. Data sharing and
security are closely related. Sharing data among multiple geographically dispersed
users introduces a lot of security risks. In terms of spreadsheet data, while
many spreadsheet programs provide rudimentary security options, they are not
always used, and even when they are, they are insufficient for robust data
sharing among users. In terms of creating data management and reporting
programs, security and data-sharing features are difficult to program and
consequently are often omitted from a file system environment. Such features
include effective password protection, the ability to lock out parts of files
or parts of the system itself, and other measures designed to safeguard data
confidentiality. Even when an attempt is made to improve system and data
security, the security devices tend to be limited in scope and effectiveness. Extensive
programming. Making changes to an existing file structure can be difficult in a
file system environment.
Not yet
graded / 1 pts
Discuss any three functions performed by the
DBMS that guarantee the integrity and consistency of the data in the database.
Your
Answer:
Data Storage Management,
Security Management, and Backup and Recovery Management are the three important
functionalities that ensure data consistency and data integrity of dbms.
Efficient data storage management ensures that the data is stored at right place
and its is accessed when an authorised user is accessing it. This reduces time
required to perform query and generate result. The will be strongly binded.
Data security ensures that authorised use can only access data. This protect
data from unwanted anomalies. Back up ensures that when some data is lost it is
restored without any changes.
Answer:
See the 'Rationale' field for sample responses.
Rationale:
(answers may vary)Data dictionary management. The
DBMS stores definitions of the data elements and their relationships (metadata)
in a data dictionary. In turn, all programs that access the data in the
database work through the DBMS. The DBMS uses the data dictionary to look up
the required data component structures and relationships, thus relieving you
from having to code such complex relationships in each program. Additionally,
any changes made in a database structure are automatically recorded in the data
dictionary, thereby freeing you from having to modify all of the programs that
access the changed structure. In other words, the DBMS provides data
abstraction, and it removes structural and data dependence from the system.
Data storage management. The DBMS creates and manages the complex structures
required for data storage, thus relieving you from the difficult task of
defining and programming the physical data characteristics. A modern DBMS
provides storage not only for the data but for related data-entry forms or
screen definitions, report definitions, data validation rules, procedural code,
structures to handle video and picture formats, and so on. Data storage
management is also important for database performance tuning. Performance
tuning relates to the activities that make the database perform more
efficiently in terms of storage and access speed. Although the user sees the
database as a single data storage unit, the DBMS actually stores the database
in multiple physical data files. Such data files may even be stored on
different storage media. Therefore, the DBMS doesn't have to wait for one disk
request to finish before the next one starts. In other words, the DBMS can
fulfill database requests concurrently. Data transformation and presentation. The
DBMS transforms entered data to conform to required data structures. The DBMS
relieves you of the chore of distinguishing between the logical data format and
the physical data format. That is, the DBMS formats the physically retrieved
data to make it conform to the user's logical expectations. Security
management. The DBMS creates a security system that enforces user security and
data privacy. Security rules determine which users can access the database,
which data items each user can access, and which data operations (read, add,
delete, or modify) the user can perform. This is especially important in
multiuser database systems.
Quiz Score: 68 out of 75
Comments
Post a Comment