UNIT 4 — MILESTONE 4
Score 21/22
You passed this Milestone
21 questions were answered correctly.
1 question was answered incorrectly.
1
Which of the following ALTER TABLE features are available in ANSI SQL but not
...
UNIT 4 — MILESTONE 4
Score 21/22
You passed this Milestone
21 questions were answered correctly.
1 question was answered incorrectly.
1
Which of the following ALTER TABLE features are available in ANSI SQL but not SQLite?
ADD CONSTRAINT
RENAME TABLE
RENAME COLUMN
ADD COLUMN
CONCEPT
Using SQLite
2
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
In the context of a database, what reveals the meaning behind data?
Knowledge
Information
Raw data
Database
CONCEPT
Database Purpose
3
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
Which term is the part of the database system that is the collection of stored facts?
Data
Software
Procedures
Hardware
CONCEPT
Parts of a Database System
4
Which of the following is not a common commercial database option?
SQL Express
MariaDB
MS Access
SQL Server
CONCEPT
Commercial Databases
5
Which of the following is not a reason to identify and document business rules?
It can allow developers to create an accurate data model.
It can ensure that the rules are based on the interpretation of senior management.
It can be used as a communication tool between users and designers.
It can allow the designer to understand business processes.
CONCEPT
Considering Business Rules
6
Which of the following is a key part of conceptual design in an entity relationship model?
This model uses column names instead of attributes.
In this model, no primary keys are specified in the entities.
In this model, the characteristics such as location, path, and format are described.
This model converts entities into tables.
CONCEPT
Conceptual Design
7
What notation and relationship does this refer to?
Crow's notation showing a 1:M relationship
Chen's notation showing a 1:M relationship
Chen's notation showing an M:N relationship
Crow's notation showing a 1:1 relationship
CONCEPT
Entity Relationship Model
8
Which of the following is a key feature of a relational database?
It ensures strong consistency such that applications should be able to read what has been written to the
database immediately.
It's designed for highly available systems that should provide a consistent, high-quality experience for all
users globally.
It has flexible data models that allow easy storage to combine data of any structure and dynamic changes
to the schema.
It has a broad umbrella of a variety of approaches with data storage and manipulation.
CONCEPT
Non-relational Databases
9
Which data model(s) was able to hide the complexities of the database management system from the user?
Neither
Hierarchical
Both hierarchical and network
Network
CONCEPT
Hierarchical and Network Data Models
10
Which of the following is a key part of logical design in an entity relationship model?
This data model includes all table structures including column names, data types, column constraints,
primary keys, foreign keys, and relationships.
This model does not depend on the database management software or the hardware used to implement the
model.
This model converts attributes into columns.
This model resolves the many-to-many relationships to multiple one-to-many relationships.
CONCEPT
Logical Design
11
Which of the following criteria was a key milestone for the object-relational model created in the mid-
1980s?
One of the milestones during this period was the creation of a relation or a table as a two-dimensional
structure composed of rows and columns.
One of the milestones during this period was the use of inheritance to have structures inherit attributes and
methods of classes above it.
One of the milestones during this period was having very large storage in petabytes.
One of the milestones during this period was focusing on high performance and fault tolerance.
CONCEPT
Object and Relational Models
12
Which of the following creates one of the most common types of bottlenecks?
Transactions on running in sequence with one another
Transactions competing for the same data rows
Transactions competing for different data rows in the same table
Transactions competing to access different tables
CONCEPT
Query Processing Bottlenecks
13
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
As compared to databases, file sizes in flat files can be much larger due to __________.
flexibility
data integrity
security
redundancy
CONCEPT
Databases vs. Flat Files
14
What type of scenario would help protect against a security issue in relation to database migration
challenges?
Removing personally identifiable information
Testing for data loss
Converting schemas
Normalizing data
CONCEPT
Migrating Databases in an Organization
15
What happens if we run the following command in MySQL?
UPDATE product
SET sale_price = price --5;
An error is thrown due to the --.
The sale_price in the product table for all records are decremented by 5 from the price.
The product table has all of the sale_price set to the same value as the price.
The sale_price in the product table for all records are decremented by 5 from the price.
CONCEPT
Using MySQL and MariaDB
16
Which of the following criteria was a key milestone for the relational model created in the mid-1970s?
One of the milestones during this period was having support for unstructured data.
One of the milestones during this period was the make use of this data model on IBM mainframe systems.
One of the milestones during this period was that all of the data was identified to be stored in a collection
of tables with each table being independent and each of the rows in a table are related by common values.
One of the milestones during this period was the creation of a single structure that contained both data and
its relationships.
CONCEPT
Relational Models
17
In each milestone, you may want or need to use the database and query tool to answer some of the questions. We
suggest you open the tool in another browser tab while you are working on this assessment.
https://postgres.sophia.org/
What is the best example of a scenario in which a new database should be created to support the business?
An organization would like to create a book review application allowing users to identify what books they
have purchased, what they have read, and how much they liked a book.
An organization would like to add a review system to its existing book purchase database.
An organization would like to pull the current reviews of books from different sites to display on their
own website.
An organization would like to display the results of an external book review database in real-time on their
website.
CONCEPT
Databases in the Real World
18
Which of the following is a key part of physical design in an entity relationship model?
This model converts entities into tables.
In this model, no attributes are specified.
This model adds all of the attributes for each entity.
This model has normalization that occurs.
CONCEPT
Physical Design
19
Which of the following commands must be supported in the same way by the commercial database
management system to comply with ANSI standards?
CREATE VIEW
WHERE
ALTER DATABASE
DROP TABLE
CONCEPT
Using ANSI SQL
20
Which of the following is a key feature of a data warehouse?
This type of database is often denormalized with a focus on performance.
This type of database has processing that's immediate to when the user makes a request.
This type of database focuses on reducing data redundancy.
This type of database uses insert, update, and delete statements quickly.
CONCEPT
Data Warehouse vs. Transactional Databases
21
Which of these databases is limited in terms of database size?
Teradata
PostgreSQL
Oracle
MySQL
CONCEPT
Storage Limitations
22
What was the fifth generation of major data models created during the mid-1990s?
Key-value store and column-store
Relational
XML Hybrid
Object-oriented
CONCEPT
Data Model Innovations
About
Contact Us
Privacy Policy
Terms of Use
[Show More]