INSY 3304 MAIN EXAMINATION 2026 SET QUESTIONS AND ANSWERS GRADED

INSY 3304 MAIN EXAMINATION 2026 SET QUESTIONS
AND ANSWERS GRADED A+
✔✔33. The syntax for a left outer join is _____.
a.
SELECT column-list
FROM table1 OUTER JOIN table2 LEFT
WHERE join-condition
b.
SELECT column-list
FROM table1 LEFT [OUTER] JOIN table2
ON join-condition
c.
SELECT column-list
WHERE LEFT table1 = table
d.
SELECT column-list
FROM table1 LEFT table2 [JOIN]
WHERE join-condition - ✔✔b

✔✔34. A(n) _____ join performs a relational product (also known as the Cartesian
product) of two tables.
a.
full
b.
cross
c.
natural
d.
equi- - ✔✔b

✔✔35. How many rows would be returned from a cross join of tables A and B, if A
contains 8 rows and B contains 18?
a. 8
b. 18
c. 26
d. 144 - ✔✔d

✔✔36. Which comparison operator indicates a value is not equal?
a. <
b. <=
c. >=
d. <> - ✔✔d

✔✔37. What type of command does this SQL statement use?

, SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE=VENDOR. V_CODE
a. set operator
b. natural join
c. "old-style" join
d. procedural statement - ✔✔c

✔✔38. The special operator used to check whether an attribute value is within a range
of values is _____.
a. BETWEEN
b. NULL
c. LIKE
d. IN - ✔✔a

✔✔39. The special operator used to check whether an attribute value matches a given
string pattern is _____.
a. BETWEEN
b. IS NULL
c. LIKE
d. IN - ✔✔c

✔✔40. The SQL aggregate function that gives the number of rows containing non-null
values for a given column is _____.
a. COUNT
b. MIN
c. MAX
d. SUM - ✔✔a

✔✔41. A(n) _____ is a query that is embedded (or nested) inside another query.
a. alias
b. operator
c. subquery
d. view - ✔✔c

✔✔42. In subquery terminology, the first query in the SQL statement is known as the
_____ query.
a.
outer
b.
left
c.
inner
d.
base - ✔✔a