3/4/2021 MT exam_03/02/21: CSE 511: Data Processing at Scale (2021 Spring)
Published Preview Edit
MT exam_03/02/21
This is a preview of the draft version of the quiz
MT exam day/time: Tuesday March 2nd 2021, 7:40 PM-8:40 PM MST.
MT duration: 1 hour.
Number of questions: 30 questions.
At the beginning of the exam:
You must show your student ID.
Your camera must be ON.
Your phone must be OFF.
Quiz Type Graded Quiz
Points 20
Assignment Group Midterm Exam
Shuffle Answers Yes
Time Limit 60 Minutes
Multiple Attempts No
View Responses Always
Show Correct Answers After Mar 4 at 12am
One Question at a Time Yes
No
https://canvas.asu.edu/courses/75440/quizzes/531153?preview=1 1/22
,3/4/2021 MT exam_03/02/21: CSE 511: Data Processing at Scale (2021 Spring)
Require Respondus LockDown
Browser
Required to View Quiz Results No
Webcam Required No
Lock Questions After Yes
Answering
Due For Available from Until
Mar 2 at 8:40pm Everyone else Mar 2 at 7:40pm Mar 2 at 8:40pm
Mar 2 at 9:10pm 1 student Mar 2 at 7:40pm Mar 2 at 9:10pm
Preview
Score for this quiz: 20 out of 20
Submitted Mar 4 at 3:33pm
This attempt took 7 minutes.
Question 1 0..5 pts
Which of the following conversion occurs when one creates a relational
database from an entity-relationship diagram?
Entities become columns
Attributes become tables
Correct!
Attributes become columns
Explanation: Each attribute becomes a column in a table during this
conversion. The rest are all false.
Entities become rows
https://canvas.asu.edu/courses/75440/quizzes/531153?preview=1 2/22
, 3/4/2021 MT exam_03/02/21: CSE 511: Data Processing at Scale (2021 Spring)
Question 2 0..5 pts
Under which of the following scenarios is database recovery necessary?
Data entry error
Keyboard failure
Relational database design error
Correct! Transaction failure
Explanation: Transaction failure is the only scenario where database
recovery is necessary. The other scenarios do not affect the
database itself and hence we do not need to recover the database
Question 3 0..5 pts
While translating ER diagrams to relational models, which is true for weak
entity sets?
● Weak entity set and identifying relationship set are translated into
different tables
● None of the given options
● Weak entity set is translated into a table
Correct!
● Weak entity set and identifying relationship set are translated into a
single table
https://canvas.asu.edu/courses/75440/quizzes/531153?preview=1 3/22
Published Preview Edit
MT exam_03/02/21
This is a preview of the draft version of the quiz
MT exam day/time: Tuesday March 2nd 2021, 7:40 PM-8:40 PM MST.
MT duration: 1 hour.
Number of questions: 30 questions.
At the beginning of the exam:
You must show your student ID.
Your camera must be ON.
Your phone must be OFF.
Quiz Type Graded Quiz
Points 20
Assignment Group Midterm Exam
Shuffle Answers Yes
Time Limit 60 Minutes
Multiple Attempts No
View Responses Always
Show Correct Answers After Mar 4 at 12am
One Question at a Time Yes
No
https://canvas.asu.edu/courses/75440/quizzes/531153?preview=1 1/22
,3/4/2021 MT exam_03/02/21: CSE 511: Data Processing at Scale (2021 Spring)
Require Respondus LockDown
Browser
Required to View Quiz Results No
Webcam Required No
Lock Questions After Yes
Answering
Due For Available from Until
Mar 2 at 8:40pm Everyone else Mar 2 at 7:40pm Mar 2 at 8:40pm
Mar 2 at 9:10pm 1 student Mar 2 at 7:40pm Mar 2 at 9:10pm
Preview
Score for this quiz: 20 out of 20
Submitted Mar 4 at 3:33pm
This attempt took 7 minutes.
Question 1 0..5 pts
Which of the following conversion occurs when one creates a relational
database from an entity-relationship diagram?
Entities become columns
Attributes become tables
Correct!
Attributes become columns
Explanation: Each attribute becomes a column in a table during this
conversion. The rest are all false.
Entities become rows
https://canvas.asu.edu/courses/75440/quizzes/531153?preview=1 2/22
, 3/4/2021 MT exam_03/02/21: CSE 511: Data Processing at Scale (2021 Spring)
Question 2 0..5 pts
Under which of the following scenarios is database recovery necessary?
Data entry error
Keyboard failure
Relational database design error
Correct! Transaction failure
Explanation: Transaction failure is the only scenario where database
recovery is necessary. The other scenarios do not affect the
database itself and hence we do not need to recover the database
Question 3 0..5 pts
While translating ER diagrams to relational models, which is true for weak
entity sets?
● Weak entity set and identifying relationship set are translated into
different tables
● None of the given options
● Weak entity set is translated into a table
Correct!
● Weak entity set and identifying relationship set are translated into a
single table
https://canvas.asu.edu/courses/75440/quizzes/531153?preview=1 3/22
