CIT 111 COMPUTER SCIENCE FINAL EXAM ACTUAL EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) | GRADED A+ | LATEST EXAM |TEST BANK EXAM

5/22/25, 8:35 AM CIT 111 FINAL EXAM ACTUAL EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) | GRADED A+…




CIT 111 COMPUTER SCIENCE FINAL EXAM ACTUAL
EXAM 2025 | ALL QUESTIONS AND CORRECT
ANSWERS (VERIFIED ANSWERS) |
GRADED A+ | LATEST EXAM |TEST BANK EXAM




You can use the AS SELECT
keyword with the CREATE
TABLE statement to create
a copy of a table from a
__________________ statem
ent.
When you code a column NULL
list in an INSERT
statement, you can omit
columns with default
values and columns that
allow
_ __________ values.
If you code a column list DEFAULT
in an INSERT statement
that includes a column
that's defined with a default
value, you can insert the
default value for that column
by coding the
__________ keyword in the
VALUES
clause of the INSERT
statement.
By default, MySQL DELETE
automatically commits
changes to the database

-r… 1/62

,5/22/25, 8:35 AM CIT 111 FINAL EXAM ACTUAL EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) | GRADED A+…

immediately after each INSERT,
UPDATE, and ______________
statement that you issue
Which uses the least amount 'ex' stored in a column of type VARCHAR2(20)
of storage?

'example' stored in a
column of type
VARCHAR2(20)
'exam' stored in a
column of type
VARCHAR2(20)
'ex' stored in a column of
type VARCHAR2(20)
they all use the same amount
of storage
The ________ function is an CAST
ANSI-
standard function that you
can use to perform an
explicit conversion.
In MySQL 5.6 the CHAR and B) UTF-8
VARCHAR2
data types use which
character set?
A) Latin1

B) UTF-8

C) ASCII

D) ISO 8859

E) UTF-16

If you want to store a False
decimal number you must
use the FLOAT data type.
Tr
ue
Fal
se




-r… 2/62

,5/22/25, 8:35 AM CIT 111 FINAL EXAM ACTUAL EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) | GRADED A+…

The best data type for a C) CHAR(5)
standard zip code (e.g.
83440) is:
A) INT

B) NUMBER(5, 0)

C) CHAR(5)

D) CHAR(25)

E) VARCHAR(5)

F) VARCHAR(25)

This expression returns what: A) 'o World' start at position 5

SUBSTRING('Hello World', 5)
A) 'o World'

B) 'Hello'

C) Error Msg: Too few
arguments
D) 'World'

E) NULL

The EXTRACT function can True
be used to parse a date?
Tr
ue
Fal
se
Which of the following A) IFNULL
functions are useful when C) COALESCE
dealing with nulls? (Select
all that apply)
A) IFNULL

B) NVL

C) COALESCE

D) ISNULL

E) NVL2

The default date format for A) '2014-08-19'
MySQL is:
A) '2014-08-19'

B) '8/19/14'

C) 'August 19, 2014'

D) '19-AUG-14'




-r… 3/62

, 5/22/25, 8:35 AM CIT 111 FINAL EXAM ACTUAL EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (VERIFIED ANSWERS) | GRADED A+…

DECIMAL(5,2) can hold C) 50.78
which of the following E) 730.00

values: F) -730.00

A) 23500.78

B) -23500.78

C) 50.78

D) 50.783

E) 730.00

F) -730.00

The DATE data type can False
store time as well as date
information?
Tr
ue
Fal
se
Which uses the least amount they all use the same amount of storage
of storage?

'example' stored in a
column of type CHAR2(20)
'exam' stored in a
column of type
CHAR2(20)
'ex' stored in a column of
type CHAR2(20) they all
use the same amount of
storage
Numbers that include a real numbers
decimal point are knows as
_____________ _.
When searching for floating approximate
point numbers such as the
DOUBLE and FLOAT
types, you'll want to
search for
____________________ valu
es.

-r… 4/62