CIT 225 FINAL EXAM STUDY GUIDE | WITH COMPLETE QUESTIONS
AND ANSWERS | 2025/206 LATEST UPDATED | 100 % RATED AND
VERIFIED SOLUTIONS | GET AN A+
A subquery can return a result set, a column of one or more rows, or a single
______________________. - (ANSWER)cell
In many cases, a subquery can be restated as a/an _____________ - (ANSWER)join
A correlated subquery is a subquery that is executed once for each ______________________ in
the outer query. - (ANSWER)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. - (ANSWER)inline
If introduced as follows, the subquery can return which of the values listed below?
WHERE vendor_id NOT IN (subquery) - (ANSWER)a column of one or more rows
If introduced as follows, the subquery can return which of the values listed below?
WHERE 2 < (subquery) - (ANSWER)A Single Value
,If introduced as follows, the subquery can return which of the values listed below?
FROM (subquery) - (ANSWER)A Table
What does the function that follows return?
TO_CHAR(1234, '$99,999.99') - (ANSWER)$1,234.00
To store an integer with an Oracle data type (not one of the ANSI standard synonyms), you use
the ____________________ data type. - (ANSWER)Number
The DATE data type includes not only the date, but also a ________________________. -
(ANSWER)Time
To convert numeric values to formatted numbers, you can use the ______________________
function. - (ANSWER)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 - (ANSWER)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) - (ANSWER)They all use the same amount of
storage
Which uses the least amount of storage?
- 'ex' stored in a column of type VARCHAR2(20)
- 'exam' stored in a column of type VARCHAR2(20)
- 'example' stored in a column of type VARCHAR2(20)
- they all use the same amount of storage - (ANSWER)'ex' stored in a column of type
VARCHAR2(20)
, The COALESCE function provides one way to substitute other values for
__________________________ values. - (ANSWER)Null
To model a database on a real-world system, you typically represent each real-world entity as
a/an ____________________________. - (ANSWER)Table
If two tables have a one-to-many relationship, you need to add a _______________________
column to the table on the "many" side. - (ANSWER)Foreign Key
Each table in a database should have a _____________________________ that uniquely
identifies each row. - (ANSWER)Primary Key
Typically, most database designers consider a database structure normalized if it's in the
________________________ normal form. - (ANSWER)Third
Which of the following is not a good guideline for deciding when to create an index for a
column?
- The column is a foreign key.
- The column is frequently updated.
- The column is frequently used in search conditions or joins.
AND ANSWERS | 2025/206 LATEST UPDATED | 100 % RATED AND
VERIFIED SOLUTIONS | GET AN A+
A subquery can return a result set, a column of one or more rows, or a single
______________________. - (ANSWER)cell
In many cases, a subquery can be restated as a/an _____________ - (ANSWER)join
A correlated subquery is a subquery that is executed once for each ______________________ in
the outer query. - (ANSWER)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. - (ANSWER)inline
If introduced as follows, the subquery can return which of the values listed below?
WHERE vendor_id NOT IN (subquery) - (ANSWER)a column of one or more rows
If introduced as follows, the subquery can return which of the values listed below?
WHERE 2 < (subquery) - (ANSWER)A Single Value
,If introduced as follows, the subquery can return which of the values listed below?
FROM (subquery) - (ANSWER)A Table
What does the function that follows return?
TO_CHAR(1234, '$99,999.99') - (ANSWER)$1,234.00
To store an integer with an Oracle data type (not one of the ANSI standard synonyms), you use
the ____________________ data type. - (ANSWER)Number
The DATE data type includes not only the date, but also a ________________________. -
(ANSWER)Time
To convert numeric values to formatted numbers, you can use the ______________________
function. - (ANSWER)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 - (ANSWER)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) - (ANSWER)They all use the same amount of
storage
Which uses the least amount of storage?
- 'ex' stored in a column of type VARCHAR2(20)
- 'exam' stored in a column of type VARCHAR2(20)
- 'example' stored in a column of type VARCHAR2(20)
- they all use the same amount of storage - (ANSWER)'ex' stored in a column of type
VARCHAR2(20)
, The COALESCE function provides one way to substitute other values for
__________________________ values. - (ANSWER)Null
To model a database on a real-world system, you typically represent each real-world entity as
a/an ____________________________. - (ANSWER)Table
If two tables have a one-to-many relationship, you need to add a _______________________
column to the table on the "many" side. - (ANSWER)Foreign Key
Each table in a database should have a _____________________________ that uniquely
identifies each row. - (ANSWER)Primary Key
Typically, most database designers consider a database structure normalized if it's in the
________________________ normal form. - (ANSWER)Third
Which of the following is not a good guideline for deciding when to create an index for a
column?
- The column is a foreign key.
- The column is frequently updated.
- The column is frequently used in search conditions or joins.
