INSY 3304 CORE EXAM 2026 TEST QUESTIONS AND
ANSWERS GRADED A+
✔✔11. String comparisons are made from left to right.
a. True
b. False - ✔✔True
✔✔12. Date procedures are often more software-specific than other SQL procedures.
a. True
b. False - ✔✔True
✔✔13. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and
NOT.
a. True
b. False - ✔✔True
✔✔14. You cannot insert a row containing a null attribute value using SQL.
a. True
b. False - ✔✔False
✔✔15. ANSI-standard SQL allows the use of special operators in conjunction with the
WHERE clause.
a. True
b. False - ✔✔True
✔✔16. The conditional LIKE must be used in conjunction with wildcard characters.
a. True
b. False - ✔✔True
✔✔17. Most SQL implementations yield case-insensitive searches.
a. True
b. False - ✔✔False
✔✔18. Some RDBMSs, such as Microsoft Access, automatically make the necessary
conversions to eliminate case sensitivity.
a. True
b. False - ✔✔True
✔✔19. The COUNT function is designed to tally the number of non-null "values" of an
attribute, and is often used in conjunction with the DISTINCT clause.
a. True
b. False - ✔✔True
, ✔✔20. Numeric functions take one numeric parameter and return one value.
a. True
b. False - ✔✔True
✔✔21. The SQL data manipulation command HAVING:
a. restricts the selection of rows based on a conditional expression.
b. restricts the selection of grouped rows based on a condition.
c. modifies an attribute's values in one or more table's rows.
d. groups the selected rows based on one or more attributes. - ✔✔b
✔✔22. The SQL command that allows a user to permanently save data changes is
_____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE - ✔✔c
✔✔23. The _____ command defines a default value for a column when no value is
given.
a. CHECK
b. UNIQUE
c. NOT NULL
d. DEFAULT - ✔✔d
✔✔24. The _____ command restricts the selection of grouped rows based on a
condition.
a. DISPLAY
b. HAVING
c. FROM
d. CONVERT - ✔✔b
✔✔25. A(n) _____ query specifies which data should be retrieved and how it should be
filtered, aggregated, and displayed.
a.
INSERT
b.
SELECT
c.
COMMIT
d.
UPDATE - ✔✔b
✔✔26. A(n) _____ is an alternate name given to a column or table in any SQL
statement.
ANSWERS GRADED A+
✔✔11. String comparisons are made from left to right.
a. True
b. False - ✔✔True
✔✔12. Date procedures are often more software-specific than other SQL procedures.
a. True
b. False - ✔✔True
✔✔13. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and
NOT.
a. True
b. False - ✔✔True
✔✔14. You cannot insert a row containing a null attribute value using SQL.
a. True
b. False - ✔✔False
✔✔15. ANSI-standard SQL allows the use of special operators in conjunction with the
WHERE clause.
a. True
b. False - ✔✔True
✔✔16. The conditional LIKE must be used in conjunction with wildcard characters.
a. True
b. False - ✔✔True
✔✔17. Most SQL implementations yield case-insensitive searches.
a. True
b. False - ✔✔False
✔✔18. Some RDBMSs, such as Microsoft Access, automatically make the necessary
conversions to eliminate case sensitivity.
a. True
b. False - ✔✔True
✔✔19. The COUNT function is designed to tally the number of non-null "values" of an
attribute, and is often used in conjunction with the DISTINCT clause.
a. True
b. False - ✔✔True
, ✔✔20. Numeric functions take one numeric parameter and return one value.
a. True
b. False - ✔✔True
✔✔21. The SQL data manipulation command HAVING:
a. restricts the selection of rows based on a conditional expression.
b. restricts the selection of grouped rows based on a condition.
c. modifies an attribute's values in one or more table's rows.
d. groups the selected rows based on one or more attributes. - ✔✔b
✔✔22. The SQL command that allows a user to permanently save data changes is
_____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE - ✔✔c
✔✔23. The _____ command defines a default value for a column when no value is
given.
a. CHECK
b. UNIQUE
c. NOT NULL
d. DEFAULT - ✔✔d
✔✔24. The _____ command restricts the selection of grouped rows based on a
condition.
a. DISPLAY
b. HAVING
c. FROM
d. CONVERT - ✔✔b
✔✔25. A(n) _____ query specifies which data should be retrieved and how it should be
filtered, aggregated, and displayed.
a.
INSERT
b.
SELECT
c.
COMMIT
d.
UPDATE - ✔✔b
✔✔26. A(n) _____ is an alternate name given to a column or table in any SQL
statement.
