CIT 225 Final Exam Questions and Answers

1 | Page



CIT 225 Final Exam Questions and Answers

A subquery can return a result set, a column of one or more rows,
or a single ______________________.
Ans: cell

In many cases, a subquery can be restated as a/an _____________
Ans: join

A correlated subquery is a subquery that is executed once for
each ______________________ in the outer query.
Ans: row, row processed

When you code a subquery in a FROM clause, it returns a result
set that can be referred to as an _____________________________
view.
Ans: inline

If introduced as follows, the subquery can return which of the
values listed below?
WHERE vendor_id NOT IN (subquery)
Ans: a column of one or more rows

If introduced as follows, the subquery can return which of the
values listed below?
WHERE 2 < (subquery)
Ans: A Single Value

If introduced as follows, the subquery can return which of the
values listed below?
FROM (subquery)

© 2025 All rights reserved

, 2 | Page

Ans: A Table

What does the function that follows return?
TO_CHAR(1234, '$99,999.99')
Ans: $1,234.00

To store an integer with an Oracle data type (not one of the ANSI
standard synonyms), you use the ____________________ data type.
Ans: Number

The DATE data type includes not only the date, but also a
________________________.
Ans: Time

To convert numeric values to formatted numbers, you can use the
______________________ function.
Ans: TO_CHAR

Which of the Following values can be stored in a column that's
defined as NUMBER(6,2), except:
- -246.29
-0
- 2479.95
- 32492.05
Ans: 32492.05

Which uses the least amount of storage?
- 'example' stored in a column of type CHAR(20)
- 'ex' stored in a column of type CHAR(20)
- they all use the same amount of storage
- 'exam' stored in a column of type CHAR(20)
Ans: They all use the same amount of storage

Which uses the least amount of storage?
- 'ex' stored in a column of type VARCHAR2(20)
© 2025 All rights reserved