Varchar30 primary key rid foreign key cemail

varchar(30), Primary key (RID), Foreign
key (CEmail) references Customer
(CEmail));
Create Table Tools (TooLID int,
RentalPrice int, OriginalPrice int,
Deposit int, Primary Key (ToolID));
Create Table ReserveTools (RID int,
TooLID int, Primary Key (RID,ToolID),
Foreign Key (RID) references Reservation
(RID), Foreign Key ToolID references
Tools (ToolID));
4 / 4 pts
Question 20

5/18/2020 Exam 3: DB Sys Concepts& Design - CS-6400-OAN
16/21
Which of the following clauses are mandatorily required in a
syntactically correct SQL SELECT statement when querying a
database table?
a Select, a From and a Where clause
a Select, a From, a Where, a Group By and an Order By clause
a Select and a From clause
a Select, a From, a Where and a Group By clause
0 / 4 pts
Question 21
Incorrect
Incorrect
How many rows are returned by the following query?
select distinct r.cemail
from reservation r, reservation s
where r.cemail = s.cemail and (r.startdate -
4 / 4 pts
Question 22
Hypothetically assume that none of the attributes in the
relational schema are set as NOT NULL and that the existing
primary keys are utilized. Which of the following SQL
statements will correctly insert a new row into a table?

5/18/2020 Exam 3: DB Sys Concepts& Design - CS-6400-OAN
17/21
7 / 7 pts
Question 23
Consider the original database state. After executing the
following Update statement
update Tools
set deposit = deposit * 0.5
where originalprice > 2000 and toolid not in
(select toolid from reservetools);
What would be the new state of the Tools table? (Enter your
answer as a whole number.)

5/18/2020 Exam 3: DB Sys Concepts& Design - CS-6400-OAN
18/21
Answer 1:
Answer 2:
Answer 3:
Answer 4:
Answer 5:
Answer 6:
103 30 800 60
104 40 1500 80
105 50 2200 100
106 30 800 60
107 70 3000
70
100
60
60
80
100
60

5/18/2020 Exam 3: DB Sys Concepts& Design - CS-6400-OAN
19/21
Answer 7:
70
4 / 4 pts
Question 24
After the Tools table has been updated using the SQL in the
previous question, what toolid(s) would be returned by the
following query? (The previous button will allow you to revisit
the previous question.)
Select toolid from tools where deposit > 65
and deposit < 95;
104 and 107
104
104, 106 and 107
105
No toolid(s) are returned
5 / 5 pts