University of the People. CS2203 FINAL EXAM With All Correct Answers, Top Rated 100

Which view of information deals with how the information is physically
arranged, stored, and accessed?
Select one:
a. Physical View
b. Logical View
c. Information View
d. None of the Above

Question 2
Answer saved
Marked out of 1.00




Flag question

Question text
A lack of normalisation can lead to which one of the following problems
Select one:
a. Lost Updates
b. Deletion of data
c. Insertion problems
d. Deadlock conditions

Question 3
Answer saved
Marked out of 1.00




Flag question

Question text
Foreign keys uniquely identify records.
Select one:
True
False

Question 4

,Answer saved
Marked out of 1.00




Flag question

Question text
In one-to-many relationship the table in ‘one’ side is called _______ and on
‘many’ side is called _______
Select one:
a. Child , Parent
b. Parent , Child
c. Brother , Sister
d. Father , Son

Question 5
Answer saved
Marked out of 1.00




Flag question

Question text
Select the BEST answer. In a real relational database system, if you try to
join (natural join) tables
R and S and R is empty (that is, it has no tuples),
Select one:
a. the system reports an error.
b. the answer set is an empty table.
c. the answer set is the same as table S.
d. the answer set consists of just one row.
e. an answer set is returned; however, the results are system dependent.

Question 6
Answer saved
Marked out of 1.00

, Flag question

Question text
Foreign keys are not necessary in relational databases.
Select one:
True
False

Question 7
Answer saved
Marked out of 1.00




Flag question

Question text
Consider the following relation:
Repayment(borrower_id,name,address,loanamount,requestdate,repayment_
date,repayment_amount)
Which of the following SQL statements will return all the tuples with
information on repayments from borrower_id equal to 42, and where the lent
amount exceeds 1000 USD.
Choice 1:
SELECT sum(repayment_amount)
FROM Repayment
WHERE borrower_id=42 AND loanamount>1000;
Choice 2:
SELECT *
FROM Repayment
WHERE borrower_id=42 AND loanamount>1000;
Choice 3:
SELECT sum(loanamount)
FROM Repayment
WHERE borrower_id==42 AND loanamount>1000;