11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Dashboard / My courses / CS 2203 - AY2022-T November - 17 November / Self-Quiz Unit 1
Started on Wednesday, 17 November 2021, 3:58 AM
State Finished
Completed on Wednesday, 17 November 2021, 4:11 AM
Time taken 12 mins 43 secs
Marks 6.00/8.00
Grade 7.50 out of 10.00 (75%)
Question 1
Correct
Mark 1.00 out of 1.00
Most of the commercial databases are based on the hierarchical model.
Select one:
True
False
The correct answer is 'False'.
Question 2
Incorrect
Mark 0.00 out of 1.00
A primary key of a relation should be part of every other relation to provide referential integrity.
Select one:
True
False
The correct answer is 'False'.
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 1/4
,11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Question 3
Correct
Mark 1.00 out of 1.00
Data modeling includes several models. Which model of data modeling includes the lowest level of abstractions?
Select one:
a. Internal model
b. External model
c. Conceptual model
d. Physical model
Your answer is correct.
The correct answer is: Physical model
Question 4
Correct
Mark 1.00 out of 1.00
In the evolution of database management systems, what does optimization refer to?
Select one:
a. High Availability
b. Security
c. Performance
d. Scalability
The correct answer is: Performance
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 2/4
,11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Question 5
Incorrect
Mark 0.00 out of 1.00
A relational database stores data in the form of relations.
Select one:
True
False
The correct answer is 'True'.
Question 6
Correct
Mark 1.00 out of 1.00
Both the primary key and a candidate key can uniquely identify the tuples in a relation.
Select one:
True
False
The correct answer is 'True'.
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 3/4
, 11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Question 7
Correct
Mark 1.00 out of 1.00
Which of the following is not a property of a data model?
Select one:
a. The blueprint of any database system
b. Defines relationships between managed objects
c. Includes many details
d. Intended for software developers
Your answer is correct.
The correct answer is: Defines relationships between managed objects
Question 8
Correct
Mark 1.00 out of 1.00
A rule that each foreign key value must match a primary key value in the other relation is called as?
Select one:
a. Referential integrity constraint
b. Entity integrity constraint
c. Tuple constraint
d. Semantic integrity constraint
Your answer is correct.
The correct answer is: Referential integrity constraint
◄ Learning Journal Unit 1
Jump to...
Unit 1 Lecture: Information Models ►
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 4/4
Dashboard / My courses / CS 2203 - AY2022-T November - 17 November / Self-Quiz Unit 1
Started on Wednesday, 17 November 2021, 3:58 AM
State Finished
Completed on Wednesday, 17 November 2021, 4:11 AM
Time taken 12 mins 43 secs
Marks 6.00/8.00
Grade 7.50 out of 10.00 (75%)
Question 1
Correct
Mark 1.00 out of 1.00
Most of the commercial databases are based on the hierarchical model.
Select one:
True
False
The correct answer is 'False'.
Question 2
Incorrect
Mark 0.00 out of 1.00
A primary key of a relation should be part of every other relation to provide referential integrity.
Select one:
True
False
The correct answer is 'False'.
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 1/4
,11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Question 3
Correct
Mark 1.00 out of 1.00
Data modeling includes several models. Which model of data modeling includes the lowest level of abstractions?
Select one:
a. Internal model
b. External model
c. Conceptual model
d. Physical model
Your answer is correct.
The correct answer is: Physical model
Question 4
Correct
Mark 1.00 out of 1.00
In the evolution of database management systems, what does optimization refer to?
Select one:
a. High Availability
b. Security
c. Performance
d. Scalability
The correct answer is: Performance
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 2/4
,11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Question 5
Incorrect
Mark 0.00 out of 1.00
A relational database stores data in the form of relations.
Select one:
True
False
The correct answer is 'True'.
Question 6
Correct
Mark 1.00 out of 1.00
Both the primary key and a candidate key can uniquely identify the tuples in a relation.
Select one:
True
False
The correct answer is 'True'.
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 3/4
, 11/24/21, 10:52 AM Self-Quiz Unit 1: Attempt review
Question 7
Correct
Mark 1.00 out of 1.00
Which of the following is not a property of a data model?
Select one:
a. The blueprint of any database system
b. Defines relationships between managed objects
c. Includes many details
d. Intended for software developers
Your answer is correct.
The correct answer is: Defines relationships between managed objects
Question 8
Correct
Mark 1.00 out of 1.00
A rule that each foreign key value must match a primary key value in the other relation is called as?
Select one:
a. Referential integrity constraint
b. Entity integrity constraint
c. Tuple constraint
d. Semantic integrity constraint
Your answer is correct.
The correct answer is: Referential integrity constraint
◄ Learning Journal Unit 1
Jump to...
Unit 1 Lecture: Information Models ►
https://my.uopeople.edu/mod/quiz/review.php?attempt=6110111&cmid=268444 4/4
