Answer all $5$; What are the four primary Data Manipulation Commands in SQL$.$

Select, Insert, Update, Delete, Create, Truncate, Drop, Grant

Which SQL join fragment will create two identical clientNo columns? $($circle one$)$

FROM Client c JOIN Viewing v ON caclientNo $=$ veclientNo

FROM Client JOIN Viewing USING ClientNo

FROM Client NATURAL JOIN Viewing

none of these fragments do that.

In the following left outer join statement which table will return nulls if there are no matching records?

SELECT b$.$

FROM Branch b

LEFT JOIN PropectyFerRent p ON bucitx $=$ ReCity:

$($True or False$)$ Think about the sakila database and the film table. Would the following exists statement evaluate?

Complete these three statements using either insert, update, or delete.$|$

FROM film WHERE filmID$=1$;

INTO film filmID, title, relleaseYear$)$ VALUES $(1,$'The Social Network', $2010)$;

film SET title $=$ 'Inception' WHERE filmID $=2_{?}$