M02 Quiz Take 2

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

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 1/9 M02 Quiz Due Jan 27 at 5pm Points 20 Questions 20 Time Limit 30 Minutes Allowed Attempts 2 Instructions Attempt History Attempt Time Score KEPT Attempt 2 10 minutes 18.6 out of 20 LATEST Attempt 2 10 minutes 18.6 out of 20 Attempt 1 18 minutes 18 out of 20 Score for this attempt: 18.6 out of 20 Submitted Jan 27 at 2:02am This attempt took 10 minutes. This assignment takes the format of a quiz over Module 2. 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. 1 / 1 pts Question 1 A tuple is simply a sequence of values. True Correct! Correct! False

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 2/9 1 / 1 pts Question 2 Which type of key represents a minimal subset of super key? Primary Key Candidate Key Correct! Correct! Super Key Foreign Key 1 / 1 pts Question 3 The set of permitted values allowed to be stored in a column is known as: Format Attribute Constraint Domain Correct! Correct! 1 / 1 pts Question 4 Data types are used to help enforce the domain of a column. Select the common types of datatypes. Floats Correct! Correct!

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 3/9 Boolean Correct! Correct! Constraints Constructs Integers Correct! Correct! 1 / 1 pts Question 5 Data can be used to transform raw facts into information, and information can be used to acquire knowledge. True Correct! Correct! False 1 / 1 pts Question 6 A null value signifies that the data is unknown or doesn’t exist. True Correct! Correct! False 1 / 1 pts Question 7 A query language is a language in which a user can request information from the database.

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

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 4/9 True Correct! Correct! False 1 / 1 pts Question 8 A relational database consist of a collection of: Data Tuples Tables Correct! Correct! Attributes Records 1 / 1 pts Question 9 Select the operation that allows us to combine a selection and a Cartesian product into a single operation? Join Operation Correct! Correct! Cartesian Product operation Select operation Assignment operation

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 5/9 1 / 1 pts Question 10 How can a database schema be depicted? Web Site Schema diagram Correct! Correct! Graphical Interface Vendors documentation 1 / 1 pts Question 11 What are business rules used to define? Users access to the tables The physical layout of the datafiles Entities, attributes, relationships, and constraints Correct! Correct! The structure of the physical database 0.6 / 1 pts Question 12 Relational algebra consist of set of operations including: Rename Correct! Correct! Project Correct! Correct!

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 6/9 Select Correct! Correct! Update Cartesian Product orrect Answer orrect Answer Insert Join orrect Answer orrect Answer Delete 1 / 1 pts Question 13 When is a domain consider to be in an atomic state? If the element of a domain is considered indivisible Correct! Correct! The elements of a domain store multiple values When the data element is a null value When the data type is of a numeric value 1 / 1 pts Question 14 How is query language categorized? Functional query language Correct! Correct! Declarative query language Correct! Correct! Data Definition language

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

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 7/9 Imperative query language Correct! Correct! Data Manipulation Language 1 / 1 pts Question 15 A referential integrity constraint requires: Each value entered into the column be unique That a value be entered into the column for each record inserted Each tuple in a table be uniquely identifiable Requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in the specified attributes of at least one of tuple in the referenced relation. Correct! Correct! 0 / 1 pts Question 16 A attribute refers to the heading of a column. True ou Answered ou Answered False orrect Answer orrect Answer 1 / 1 pts Question 17

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 8/9 Relational algebra consist of a set of operation that takes one or two relations as input and produce a new relation as a result. Select the two categories which the set operations are grouped into. Binary Correct! Correct! Unary Correct! Correct! Ternary 1 / 1 pts Question 18 Data is organized facts. True False Correct! Correct! 1 / 1 pts Question 19 Business Rules describe the _________ policies that apply to the data stored on a company’s database. business Correct! Correct! orrect Answers orrect Answers Business 1 / 1 pts Question 20

1/27/24, 2:03 AM M02 Quiz: B1B-Spring 2024-Introduction to Data Analytics https://ivylearn.ivytech.edu/courses/1251944/quizzes/4401350 9/9 It is good practice have the foreign key reference an existing primary key in the table being referenced. True Correct! Correct! False Quiz Score: 18.6 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

Mitigating Risk .docx

Performance Lab 2.docx

Viruses and Malicious Code.docx

Cybercrime Tech:Response .docx

ITN v7 SG SECTION 1 (Modules 1-3).docx

Analysis of the 5 Tickets.docx

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