Assessment 6: Attempt review https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=198
UNISA 2024 INF2603-24-Y Welcome Message Assessment 6
QUIZ
Started on Thursday, 6 June 2024, 11:18 AM
State Finished
Completed on Thursday, 6 June 2024, 11:57 AM
Time taken 38 mins 28 secs
Grade 20.00 out of 20.00 (100%)
Question 1
Correct
Mark 1.00 out of 1.00
The SELECT operator yields a vertical subset of a table.
True
False
The correct answer is 'False'.
Question 2
Correct
Mark 1.00 out of 1.00
In a natural join, the column on which the join was made occurs twice in the new
table.
True
False
The correct answer is 'False'.
1 of 7 2024/06/06, 11
,Assessment 6: Attempt review https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=198
Question 3
Correct
Mark 1.00 out of 1.00
A(n) ____ join links tables by selecting only the rows with common values in their
common attribute(s).
a. equal
b. unique
c. foreign
d. natural
The correct answer is: natural
Question 4
Correct
Mark 1.00 out of 1.00
The DIFFERENCE operator subtracts one table from the other.
True
False
The correct answer is 'True'.
Question 5
Correct
Mark 1.00 out of 1.00
In an outer join, the matched pairs would be retained and any unmatched values
in the other table would be left ____.
a. in another table
b. null
c. out of the results
d. with matching values from the original table
The correct answer is: null
2 of 7 2024/06/06, 11
UNISA 2024 INF2603-24-Y Welcome Message Assessment 6
QUIZ
Started on Thursday, 6 June 2024, 11:18 AM
State Finished
Completed on Thursday, 6 June 2024, 11:57 AM
Time taken 38 mins 28 secs
Grade 20.00 out of 20.00 (100%)
Question 1
Correct
Mark 1.00 out of 1.00
The SELECT operator yields a vertical subset of a table.
True
False
The correct answer is 'False'.
Question 2
Correct
Mark 1.00 out of 1.00
In a natural join, the column on which the join was made occurs twice in the new
table.
True
False
The correct answer is 'False'.
1 of 7 2024/06/06, 11
,Assessment 6: Attempt review https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=198
Question 3
Correct
Mark 1.00 out of 1.00
A(n) ____ join links tables by selecting only the rows with common values in their
common attribute(s).
a. equal
b. unique
c. foreign
d. natural
The correct answer is: natural
Question 4
Correct
Mark 1.00 out of 1.00
The DIFFERENCE operator subtracts one table from the other.
True
False
The correct answer is 'True'.
Question 5
Correct
Mark 1.00 out of 1.00
In an outer join, the matched pairs would be retained and any unmatched values
in the other table would be left ____.
a. in another table
b. null
c. out of the results
d. with matching values from the original table
The correct answer is: null
2 of 7 2024/06/06, 11
