DATABASE 0047 relational_database_unit_4_milestones_4 UNIT 4 — MILESTONE 4 Score 21/22 | Western Governors University

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