M03 Quiz Take 1

pdf

School

Ivy Tech Community College, Indianapolis *

*We aren’t endorsed by this school

Course

110

Subject

Computer Science

Date

Feb 20, 2024

Type

pdf

Pages

Uploaded by MagistrateScorpionPerson5065

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 1/9 M03 Quiz Due Feb 3 at 5pm Points 20 Questions 20 Time Limit 60 Minutes Allowed Attempts 2 Instructions Attempt History Attempt Time Score LATEST Attempt 1 28 minutes 17.5 out of 20 Score for this attempt: 17.5 out of 20 Submitted Feb 3 at 4:27pm This attempt took 28 minutes. This assignment takes the format of a quiz over Module 3. This quiz consists of 20 multiple choices, multiple answer, and true-false questions. There is a 30-minute time limit on this quiz, and you will be provided two attempts, the highest score will be kept. This quiz is due by the stated due date. It is suggested that you print the questions, review the chapter, and then come back and enter your answers. Take the Quiz Again 1 / 1 pts Question 1 The actual physical backup files are known as: Backup files Full backups Transaction logs

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 2/9 Backupsets Correct! Correct! 0.5 / 1 pts Question 2 What are the type of participation available in an entity set relationship? Ternary Total Correct! Correct! All Partial orrect Answer orrect Answer 0 / 1 pts Question 3 Unanswered Unanswered Data security consist of: Protection of data orrect Answer orrect Answer Ensure that data is accessed by its intended user orrect Answer orrect Answer Prevention of data corruption orrect Answer orrect Answer Authentication/authorization, encryption, and masking are some of the popular means of data security orrect Answer orrect Answer Only the people who should have access to the data are the only ones who can access the data orrect Answer orrect Answer

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 3/9 1 / 1 pts Question 4 An attribute takes a null value when an entity does not have a value for it True Correct! Correct! False 1 / 1 pts Question 5 How do you eliminate M:N relationship in a relational database? You do not need to eliminate M:N relationship Add foreign keys to each table to reference the other table primary key Add additional attributes to the tables in the relationship Create a Composite Table Correct! Correct! 1 / 1 pts Question 6 An entity is a thing or object in the real world that is distinguishable from other object. True Correct! Correct! False

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 4/9 1 / 1 pts Question 7 The extended version of an ER uses which of the following features: Specialization Correct! Correct! Aggregation Correct! Correct! Attribute inheritance Correct! Correct! Generalization Correct! Correct! 1 / 1 pts Question 8 A composite table: A table used to link two or more entities participating in a M:N relationship Correct! Correct! Consist of a primary key from all the entities in the schema Is a feature included in the specialization process 1 / 1 pts Question 9 An entity whose existence is dependent on another entity is known as: Weak Entity Correct! Correct!

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 5/9 Strong Entity 0 / 1 pts Question 10 Existence dependence occurs on Weak Entity orrect Answer orrect Answer Strong Entity ou Answered ou Answered 1 / 1 pts Question 11 What is the initial phase of database design? Fully characterize the data needs of the prospective database users. Correct! Correct! The designer maps the high-level conceptual schema on the implementation of a data model Choose a data model Identify the functional requirements 1 / 1 pts Question 12 Data Integrity refers to:

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 6/9 Limiting access to the data stored in the database The current state of the data stored in the database Ensuring the data is updated regularly Maintaining the quality of the data stored in the database. Correct! Correct! 1 / 1 pts Question 13 A relationship is: Attributes that share the same value An association among one or more entities Correct! Correct! A set of related business policies Identified business rules 1 / 1 pts Question 14 Does each DBMS has its own architecture for handling transaction log files? No Yes Correct! Correct! 1 / 1 pts Question 15

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 7/9 Each attribute has a set of permitted values known as: Domain or value set Correct! Correct! Simple value Multi-value Null Value Derived value 1 / 1 pts Question 16 What are the types of relationships exist within a relational database design? One to One Correct! Correct! One to Many Correct! Correct! Zero to Many One to None Many to Many Correct! Correct! 1 / 1 pts Question 17 Using ERD Chen Notation entities are represented using: Square

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 8/9 Triangles Ovals Rectangle Correct! Correct! Diamonds 1 / 1 pts Question 18 When designing database schemas we must ensure that we avoid redundancy and incompleteness. True Correct! Correct! False 1 / 1 pts Question 19 An entity has a set of properties known as attributes. True Correct! Correct! False 1 / 1 pts Question 20 Specialization is

2/3/24, 4:35 PM M03 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401355 9/9 the containment relationship that exists between a higher level entity set and one or more lower level entity set. the process of designating subgroupings within an entity Correct! Correct! Quiz Score: 17.5 out of 20

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Analysis of the 5 Tickets.docx

M4_L1_ICMP.doc

CS 410 Binary to C++ Activity Template.docx

Homework 5 cryptography.docx

CS 410 Project One Proficiency Test Template.docx

Milestone infographic timeline1.xlsx

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

Database Systems: Design, Implementation, & Manag...

Computer Science

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Principles of Information Systems (MindTap Course...

Computer Science

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning