CIS 111 SOPHIA-STRAYER Introduction to Relational Database Management Systems Unit 4 Challenges-sobtell.com

Click link for Answers All Correct

 

Unit 4

What is a database?

·        a.)

Body of information and facts about a specific topic

·        b.)

Computer structure that holds a collection of related data

·        c.)

Raw facts of interest to the end user

·        d.)

Process that focuses on data collection, storage, and retrieval

What does end-user data consist of in the context of a database?

·        a.)

Data about data

·        b.)

Computer structure that holds a collection of related data

·        c.)

Process that focuses on data collection, storage, and retrieval

·        d.)

Raw facts of interest to the end user

What does metadata consist of in the context of a database?

·        a.)

Body of information and facts about a specific topic.

·        b.)

Process that focuses on data collection, storage, and retrieval.

·        c.)

Data about data

·        d.)

Computer structure that holds a collection of related data

What is the best example of a scenario in which a new database should be created to support the business?

·        a.)

An organization would like to pull the current ratings of movies from different sites to display on their own website, based on the movies that users have selected.

·        b.)

An organization would like to create a reporting system off of movie rating databases to poll from on a real-time basis to display results to users on their website.

·        c.)

An organization would like to create a movie rating application allowing users to identify what movies they have purchased, what they have watched, and how much they liked a movie.

·        d.)

An organization would like to add a rating system to their existing movie rental database. The rating system would be a new feature to be released in the next iteration.

What is the best example of a scenario in which a new database should be created to support the business?

·        a.)

An organization would like to create a new product line to sell on their existing eCommerce site.

·        b.)

An organization would like to create a reporting tool built off of their eCommerce database to identify data analytics around customer purchases on their existing data.

·        c.)

An organization is building an eCommerce website for their customers to purchase products. They would like to have all of the usual features of an eCommerce site setup while allowing their customer service team to help track orders and provide help to customers that call in.

·        d.)

An organization would like to create an eCommerce site through a hosting site like Shopify that handles all of the processing of the orders.

What is the best example of a scenario in which a new database should be created to support the business?

·        a.)

An organization would like to use a web application to help manage their mailing lists. The web application uses an existing database to store their eCommerce and user table data. All users would register through that site and the reporting would be accessed through that site.

·        b.)

An organization would like to be able to send their users emails from an existing mailing list file provided by a third party.

·        c.)

An organization would like to build a web form to permit users to sign up to a mailing list and unsubscribe as needed. Admin should be able to view the subscribers and see when they registered and use the list to send them emails.

·        d.)

An organization has assigned a single individual to keep track of users who would like to join a mailing list at their physical store. The customers would inform the individual of what their email address is upon purchase. The list should be sent to a third party to have emails sent out.

Flat files require the operating system to handle the protection of the data to provide __________.

·        a.)

flexibliity

·        b.)

security

·        c.)

integrity

·        d.)

redundancy

A problem with with flat files is __________, or repeated data.

·        a.)

redundancy

·        b.)

integrity

·        c.)

flexibliity

·        d.)

security

Which of the following is a feature of flat files, as compared to databases?

·        a.)

Reduced flexibility

·        b.)

Greater security

·        c.)

Less redundancy

·        d.)

Better data consistency

_ include(s) the system's physical devices, such as computers, storage devices, and network devices.

·        a.)

Hardware

·        b.)

People

·        c.)

Software

·        d.)

Procedures

_ include(s) the operating system, database management system, application programs, and utilities.

·        a.)

People

·        b.)

Procedures

·        c.)

Software

·        d.)

Hardware

Which type of user oversees the database's general operations?

·        a.)

Database designer

·        b.)

System analyst

·        c.)

End user

·        d.)

System administrator

Which of the following is a key feature of a non-relational database like NoSQL?

·        a.)

Flexible data models allow for easy storage to combine data of any structure and dynamic changes to the schema.

·        b.)

It ensures strong consistency such that applications should be able to read what has been written to the database immediately.

·        c.)

It efficiently uses indexes as a means to provide efficient access to data and is supported directly in the database rather than maintained in the application code.

·        d.)

It uses expressive query languages to be able to access and modify the data.

Which of the following is a key feature of a non-relational database like NoSQL?

·        a.)

It is integrated well into an application infrastructure within a database stack.

·        b.)

It ensures strong consistency such that applications should be able to read what has been written to the database immediately.

·        c.)

It is designed for highly available systems that should provide a consistent, high-quality experience for all users globally.

·        d.)

It efficiently uses indexes as a means to provide efficient access to data and is supported directly in the database rather than maintained in the application code.

Which of the following is a key feature of a non-relational database like NoSQL?

·        a.)

It has high scalability and performance that can enable almost unlimited growth.

·        b.)

It efficiently uses indexes as a means to provide efficient access to data and is supported directly in the database rather than maintained in the application code.

·        c.)

It uses expressive query languages to be able to access and modify the data.

·        d.)

It ensures strong consistency such that applications should be able to read what has been written to the database immediately.

Which of the following is a key feature of a transactional database?

·        a.)

This type of database is optimized to execute a small number of complex queries.

·        b.)

 This type of database uses insert, update, and delete statements quickly.

·        c.)

This type of database is used to analyze massive volumes of data.

·        d.)

This type of database is often denormalized with a focus on performance.

Which of the following is a key feature of a transactional database?

·        a.)

This type of database is used to analyze massive volumes of data.

·        b.)

This type of database is often denormalized with a focus on performance.

·        c.)

This type of database has processing that's immediate to when the user makes a request.

·        d.)

This type of database generally only has data loads with extremely rare updates or deletes to the data.

 

Which of the following is a key feature of a transactional database?

·        a.)

This type of database is used to process day-to-day operations in real time.

·        b.)

This type of database generally only has data loads with extremely rare updates or deletes to the data.

·        c.)

This type of database is often denormalized with a focus on performance.

·        d.)

This type of database is optimized to execute a small number of complex queries.

 

What was the third generation of major data models created during the mid-1970s?

·        a.)

Object-oriented

·        b.)

XML Hybrid

·        c.)

Hierarchical and network

·        d.)

Relational

What was the second generation of major data models created during the 1970s?

·        a.)

Relational

·        b.)

Hierarchical and network

·        c.)

Object-oriented

·        d.)

File system

What was the first generation of major data models created during the 1960s and 1970s?

·        a.)

Object-oriented

·        b.)

Hierarchical and network

·        c.)

File system

·        d.)

Relational

Which data model(s) depicts a set of one-to-many relationships in which a parent can have many children but a child can only have one parent?

·        a.)

Both hierarchical and network

·        b.)

Hierarchical

·        c.)

Network

·        d.)

Neither

Which data model(s) depicts a set of one-to-many relationships in which a parent can have many children and a child can have more than one parent?

·        a.)

Both hierarchical and network

·        b.)

Network

·        c.)

Hierarchical

·        d.)

Neither

Which data model(s) depicts a set of one-to-many relationships?

·        a.)

Neither

·        b.)

Network

·        c.)

Hierarchical

·        d.)

Both hierarchical and network

Which of the following criteria was a key milestone for the relational model created in the mid-1970s?

·        a.)

One of the milestones during this period was introducing the schema.

·        b.)

One of the milestones during this period was focusing on having support for large databases at a terabyte size.

·        c.)

One of the milestones during this period was the use of Unified Modeling Language to represent the data models.

·        d.)

One of the milestones during this period was the creation of a tuple or a table row within a relation.

Which of the following criteria was a key milestone for the relational model created in the mid-1970s?

·        a.)

One of the milestones during this period was the use of a star schema support for data warehousing.

·        b.)

One of the milestones during this period was the model being created based on mathematical set theory and representing data as independent relations by E.F. Codd.

·        c.)

One of the milestones during this period was introducing the subschema.

·        d.)

One of the milestones during this period was focusing on managed records rather than relationships.

 

Which of the following criteria was a key milestone for the relational model created in the mid-1970s?

·        a.)

One of the milestones during this period was that web databases became more common.

·        b.)

One of the milestones during this period was the creation of a relationship database management system.

·        c.)

One of the milestones during this period was introducing the subschema.

·        d.)

One of the milestones during this period was introducing the schema.

What notation and relationship does this refer to?

• a.)

Crow's Foot notation showing a 1:M relationship

• b.)

Crow's Foot notation showing a 1:1 relationship

• c.)

UML notation showing a 1:M relationship

• d.)

UML notation showing a 1:1 relationship

What notation and relationship does this refer to?

• a.)

Crow's Foot notation showing an N:M relationship

• b.)

Chen notation showing an N:M relationship

• c.)

Crow's Foot notation showing a 1:M relationship

• d.)

Chen notation showing a 1:M relationship

 

What notation and relationship does this refer to?

• a.)

Chen notation showing a 1:M relationship

• b.)

Chen notation showing a 1:1 relationship

• c.)

UML notation showing a 1:M relationship

• d.)

UML notation showing a 1:1 relationship

Which of the following was a feature of the object relational model created in the mid-1980s?

·        a.)

It made use of objects, which only contained factual content.

·        b.)

It introduced the schema for the first time.

·        c.)

It stored both data and relationships in a single structure.

·        d.)

It was focused on managing records, rather than relationships.

By the mid-1990s, __________ was used as the standard to store and exchange structured and unstructured data.

·        a.)

Unified Modeling Language (UML)

·        b.)

Structured Query Language (SQL)

·        c.)

Data Definition Language (DDL)

·        d.)

Extensible Markup Language (XML)

Which of the following was a feature of the extended relational data model created in the mid-1990s?

·        a.)

It focused on record management rather than handling of relationships.

·        b.)

It was introduced by E.F. Codd of IBM.

·        c.)

It was created based on mathematical set theory.

·        d.)

It used object-oriented model features in a simpler relational database structure.

Which of the following is a key part of conceptual design in an entity relationship model?

·        a.)

This model adds all of the attributes for each entity.

·        b.)

This model provides a bird's eye view of the data environment so that it is easy to understand.

·        c.)

This model is both hardware and database management software dependent.

·        d.)

This model defines every data type for every column.

Which of the following is a key part of conceptual design in an entity relationship model?

·        a.)

This model includes all entities and relationships between those entities.

·        b.)

This model includes all table structures including column names, data types, column constraints, primary keys, foreign keys, and relationships.

·        c.)

This model is a global view of the entire database that describes the main objects while avoiding details.

·        d.)

This model uses table names instead of entity names.

 

Which of the following is a key part of conceptual design in an entity relationship model?

·        a.)

This model defines the data types for the columns.

·        b.)

This model may introduce denormalization based on user requirements.

·        c.)

This model defines the primary keys for each entity.

·        d.)

This model provides a means for identification and high-level description of the main data objects.

Which of the following is a key part of logical design in an entity relationship model?

·        a.)

This model may introduce denormalization based on user requirements.

·        b.)

This model provides a means for identification and a high-level description of the main data objects.

·        c.)

This model defines the primary keys for each entity.

·        d.)

This model defines the data types for the columns.

Which of the following is a key part of logical design in an entity relationship model?

·        a.)

This model provides a bird's eye view of the data environment so that it is easy to understand.

·        b.)

This model uses table names instead of entity names.

·        c.)

This model is both hardware and database management software dependent.

·        d.)

This model adds all of the attributes for each entity.

 

Which of the following is a key part of logical design in an entity relationship model?

·        a.)

This model is a global view of the entire database that describes the main objects while avoiding details.

·        b.)

This model includes all entities and relationships between those entities.

·        c.)

This model defines both the data types and sizes.

·        d.)

This model simply states the relationships but does not specify them.

Which of the following is a key part of physical design in an entity relationship model?

·        a.)

This model will have the same design regardless of what relational database management system it's for.

·        b.)

This model provides a bird's eye view of the data environment so that it is easy to understand.

·        c.)

This model adds all of the attributes for each entity.

·        d.)

This model is both hardware and database management software dependent.

Which of the following is a key part of physical design in an entity relationship model?

·        a.)

This model defines attributes.

·        b.)

This model defines the primary keys for each entity.

·        c.)

This model translates entities into tables and attributes into columns.

·        d.)

This model provides a means for identification and a high-level description of the main data objects.

Which of the following is a key part of physical design in an entity relationship model?

·        a.)

This data model includes all table structures, including column names, data types, column constraints, primary keys, foreign keys, and relationships.

·        b.)

In this model, there is a global view of the entire database, and it describes the main objects while avoiding details.

·        c.)

This model includes all entities and relationships between those entities.

·        d.)

This model simply states the relationships but does not specify them.

Which of the following is not a common commercial database option?

·        a.)

SQL Server

·        b.)

SQLite

·        c.)

VMS

·        d.)

Oracle

Which of the following is not a common commercial database option?

·        a.)

Postgres

·        b.)

MS Access

·        c.)

SQL Server

·        d.)

DB2

 

Which of the following is not a common commercial database option?

·        a.)

MySQL

·        b.)

Oracle

·        c.)

Postgres

·        d.)

VAX

Which of the following commands must be supported in the same way by the commercial database management system to comply with ANSI standards?

·        a.)

UPDATE

·        b.)

DROP INDEX

·        c.)

ALTER TABLE

·        d.)

DROP TABLE

 

Which of the following commands must be supported in the same way by the commercial database management system to comply with ANSI standards?

·        a.)

ADD

·        b.)

DELETE

·        c.)

ALTER DATABASE

·        d.)

ALTER TABLE

 

Which of the following commands must be supported in the same way by the commercial database management system to comply with ANSI standards?

·        a.)

SELECT

·        b.)

ADD

·        c.)

CREATE TABLE

·        d.)

CREATE INDEX

 

Which of the following is unique about SQLite compared to ANSI SQL?

·        a.)

Primary keys without a rowid can be null.

·        b.)

Primary keys can sometimes be null.

·        c.)

No primary keys can be null.

·        d.)

Integer primary keys can be null.

SQLite is uniquely flexible when it comes to data types.

How many data types does SQLite have?

·        a.)

10

·        b.)

2

·        c.)

5

·        d.)

8

What happens in an SQLite database if you insert 'abcd' into a column that is of type integer?

·        a.)

SQLite will convert the column to type string.

·        b.)

SQLite will store the actual string value in the column.

·        c.)

SQLite will throw an error.

·        d.)

SQLite will convert 'abcd' to an integer.

 

Consider the following command:

UPDATE order_details SET quantity = quantity --10

What happens if we run this command in MySQL?

·        a.)

The quantity in the order_details table for all records is decremented by 10.

·        b.)

The quantity in the order_details table for all records is incremented by 10.

·        c.)

An error is thrown due to the --.

·        d.)

The order_details table has all of the quantity set to the same value as it previously had.

 

Consider the following command:

UPDATE product SET price = price + 1, original_price = price;

What happens if we run this command in MySQL?

·        a.)

The price is updated to the current value of price plus 1. The original_price is updated to the newly calculated price value.

·        b.)

The price is updated to the current value of price plus 1. The original_price is updated to the original price value.

·        c.)

The original_price is set to the current value of price. Then, the price is deducted by 1.

·        d.)

The statement creates an exception, as you can't reference the same column twice.

Consider the following command:

UPDATE order_details SET quantity = quantity - 1, original_quantity = quantity;

What happens if we run this command in MySQL?

·        a.)

The statement creates an exception, as you can't reference the same column twice.

·        b.)

The quantity is updated to the current value of quantity minus 1. The original_quantity is updated to the original quantity value.

·        c.)

The quantity is updated to the current value of quantity minus 1. The original_quantity is updated to the newly calculated quantity value.

·        d.)

The original_quantity is set to the current value of quantity. Then the quantity is deducted by 1.

 

What do business rules NOT help define within a data model?

·        a.)

Relationships

·        b.)

Constraints

·        c.)

Database management system

·        d.)

Entities

What do business rules NOT help define within a data model?

·        a.)

Relationships

·        b.)

Entitites

·        c.)

Attributes

·        d.)

Values

What do business rules NOT help define within a data model?

·        a.)

Attributes

·        b.)

Users

·        c.)

Constraints

·        d.)

Entities

Consider the following business rule:

A customer can make a single reservation. A reservation can belong to a single customer.

How does this business rule(s) affect the database design?

·                  a.)

The business rules define that there is a relationship between CUSTOMER and RESERVATION, and a 1:1 relationship between those two entities.

·                  b.)

The business rules define that there is a relationship between CUSTOMER and RESERVATION, and an M:N relationship between those two entities requiring a bridge table.

·                  c.)

The business rules define that there is a relationship between CUSTOMER and RESERVATION, and a 1:M relationship between those two entities.

·                  d.)

The business rules define that there isn't a need for a relationship between the CUSTOMER and RESERVATION entities, as the relationship isn't a strong one.

Consider the following business rule:

A customer can generate multiple invoices. An invoice is only generated by a single customer.

How does this business rule(s) affect the database design?

·        a.)

The business rules define that there isn't a need for a relationship between the CUSTOMER and INVOICE entities, as the relationship isn't a strong one.

·        b.)

The business rules define that there is a relationship between CUSTOMER and INVOICE, and an M:N relationship between those two entities requiring a bridge table.

·        c.)

The business rules define that there is a relationship between CUSTOMER and INVOICE, and a 1:M relationship between those two entities.

·        d.)

The business rules define that there is a relationship between CUSTOMER and INVOICE, and a 1:1 relationship between those two entities.

Consider the following business rule:

An employee can manage multiple customers. A customer can be managed by multiple employees.

How does this business rule(s) affect the database design?

·        a.)

The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities.

·        b.)

The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.

·        c.)

The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one.

·        d.)

The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table.

What is true about variable length (VARCHAR) variables with databases?

·        a.)

Different databases have a different max size.

·        b.)

The max size in many cases can be unlimited, depending on the amount of disk space allocated for the database.

·        c.)

There is a constant set max size due to compliance with ANSI SQL.

·        d.)

There is no max size regardless of database.

What is true about character large objects with databases?

·        a.)

The max size in many cases can be unlimited, depending on the amount of disk space allocated for the database.

·        b.)

There is no max size, regardless of the database.

·        c.)

There is a constant set max size due to compliance with ANSI SQL.

·        d.)

Different databases have a different max size.

 

What is true about storage limitations with databases?

·        a.)

All commercial databases have the same database storage size limitations.

·        b.)

All paid commercial databases have the same database storage size limitations.

·        c.)

Most commercial databases do not have the same database storage size limitations.

·        d.)

All commercial databases can support unlimited data for storage.

 

Identify the component that could cause a bottleneck if there is not enough of this component available. 

Without enough, this component is shared among all running processes, and moving data among components have to compete for it.

·        a.)

Application code

·        b.)

RAM

·        c.)

Network

·        d.)

Hard disk

Identify the component that depends on this component's speed and data transfer rates. This component is used for more than just storing the end-user data. 

The OS can also use this component for virtual memory.

·        a.)

Application code

·        b.)

CPU

·        c.)

Hard disk

·        d.)

Network

Identify the component that could cause a bottleneck if there is high utilization in which this component could be too slow for the amount of work performed, potentially affecting all processes running on the system.

·        a.)

Network

·        b.)

Hard disk

·        c.)

RAM

·        d.)

CPU

 

What type of scenario would fall under a siloed database issue in relation to database migration challenges?

·        a.)

Having the data connection dropped during transfer

·        b.)

Having databases in different geographies

·        c.)

Having data be read by a third party during the transfer

·        d.)

Having the physical drives get damaged during migration

What type of scenario would fall under a siloed database issue in relation to database migration challenges?

·        a.)

Having data be read by a third party during the transfer

·        b.)

Having disparate databases that exist within various parts of the company

·        c.)

Having the physical drives get damaged during migration

·        d.)

Having personally identifiable information be acquired

What type of scenario would fall under a data loss or corruption issue in relation to database migration challenges?

·        a.)

Having databases in different departments

·        b.)

Having the database schemas be converted for consistency

·        c.)

Having disparate databases that exist within various parts of the company

·        d.)

Having the physical drives get damaged during migration

 

 

SmartExpert

(118)

Status NEW Posted 24 Feb 2023 02:02 AM My Price 15.00

CIS----------- 11-----------1 S-----------OPH-----------IA------------STR-----------AYE-----------R I-----------ntr-----------odu-----------cti-----------on -----------to -----------Rel-----------ati-----------ona-----------l D-----------ata-----------bas-----------e M-----------ana-----------gem-----------ent----------- Sy-----------ste-----------ms -----------Uni-----------t 4----------- Ch-----------all-----------eng-----------es------------sob-----------tel-----------l.c-----------om ----------- Cl-----------ick----------- li-----------nk -----------for----------- An-----------swe-----------rs -----------All----------- Co-----------rre-----------ct-----------

Attachments

file 1677207511-Unit 4 Challenges Introduction to Relational Database Management Systems.doc preview (10801 words )

A -----------hbj-----------bj -----------.hh----------- 6-----------666-----------67t-----------aL6-----------hv -----------GV0-----------7 v-----------v,7----------- X ----------- DC-----------IS -----------111----------- SO-----------PHI-----------A-S-----------TRA-----------YER----------- In-----------tro-----------duc-----------tio-----------n t-----------o R-----------ela-----------tio-----------nal----------- Da-----------tab-----------ase----------- Ma-----------nag-----------eme-----------nt -----------Sys-----------tem-----------s U-----------nit----------- 4 -----------Cha-----------lle-----------nge-----------s-s-----------obt-----------ell-----------.co-----------m C-----------lic-----------k l-----------ink----------- fo-----------r A-----------nsw-----------ers----------- Al-----------l C-----------orr-----------ect----------- U-----------nit----------- 4 -----------Wha-----------t i-----------s a----------- da-----------tab-----------ase----------- a.-----------) B-----------ody----------- of----------- in-----------for-----------mat-----------ion----------- an-----------d f-----------act-----------s a-----------bou-----------t a----------- sp-----------eci-----------fic----------- to-----------pic----------- b.-----------) C-----------omp-----------ute-----------r s-----------tru-----------ctu-----------re -----------tha-----------t h-----------old-----------s a----------- co-----------lle-----------cti-----------on -----------of -----------rel-----------ate-----------d d-----------ata----------- c.-----------) R-----------aw -----------fac-----------ts -----------of -----------int-----------ere-----------st -----------to -----------the----------- en-----------d u-----------ser----------- d.-----------) P-----------roc-----------ess----------- th-----------at -----------foc-----------use-----------s o-----------n d-----------ata----------- co-----------lle-----------cti-----------on,----------- st-----------ora-----------ge,----------- an-----------d

Not Rated(0)

• Buy Answer