Week 2:Assignment 2

1)

Show Answer

    d. natural full outer join

2)

Show Answer

    a. If a faculty_id value is deleted from the faculty table, the corresponding records in the course table that use this facultyid will not be deleted.

3)

Show Answer

    b. Delete FROM loan;
d. TRUNCATE TABLE loan;

4)

Show Answer

    a. 0

5)

Show Answer

    b. <25,Lewis F.H>will be the first tuple in the output

6)

Show Answer

    c. SCIENTIST

7)

Show Answer

    d. All rights - select, delete, update.

8)

Show Answer

    a. SELECT * FROM MountainDetails
WHERE StateName IN('Sikkim','Uttarakhand');

9)

Show Answer

    b. UPDATE MountainDetails
SET Altitude=Altitude*1.05
WHERE StateName LIKE '%d';

10)

Show Answer

    c. SELECT MountainName, Altitude
FROM MountainDetails
WHERE Altitude>=(SELECT AVG(Altitude) from MountainDetails)
OR Altitude BETWEEN 6500 AND 8000;