CIS 111 Week 11 Final Exam (4 Set) CIS 111 Week 11 Final Exam (4 Set) | Page 8

Question 3 The ____ command would be used to delete the table row where the P_CODE is
'BRT-345'.
Question 4 The SQL command that lets you select attributes from rows in one or more tables is
____.
Question 5 The SQL command that lets you insert rows into a table is ____.
Question 6 The ____ special operator is used to check whether an attribute value is null.
Question 7 The SQL character data format(s) is(are) ____.
Question 8 To list all the contents of the PRODUCT table, you would use ____.
Question 9 The ANSI standard defines ____ type(s) of outer join(s)
Question 10 The ____ operator could be used in place of INTERSECT if the RDBMS does not
support it.
Ques