1|Page
CIT 225 FINAL EXAM LATEST 2025/2026 ACTUAL EXAM WITH
COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS (100%
VERIFIED ANSWERS) |ALREADY GRADED A+| ||PROFESSOR
VERIFIED|| ||BRANDNEW!!!||
You use DDL statements to create, modify, and delete the
___________________________ of a database. - ANSWER-
Tables
A constraint that limits the values that can be stored in a column is
called a/an ______________________________ constraint. -
ANSWER-Check
A constraint that enforces referential integrity between tables is
called a/an ______________________________ constraint. -
ANSWER-Foreign Key
Oracle automatically creates indexes for primary key constraints
and for _______________ constraints. - ANSWER-unique
,2|Page
If you want to create an index that doesn't allow duplicate values,
you use the ____________________________ keyword in the
CREATE INDEX statement. - ANSWER-Unique
To modify the structure of an existing table, you use the
_______________________ statement. - ANSWER-Alter
When you create a script for creating a database,
- you can create the tables in whatever sequence you prefer
- you need to create the referred to tables before you create the
tables that refer to them
- you need to create the indexes before you create the tables that
they apply to
- you need to code the primary key column first in each table -
ANSWER-you need to create the referred to tables before you
create the tables that refer to them
To use a sequence in an INSERT statement, you
- use the NEXTVAL pseudo column for the sequence in the
VALUES list for a row
, 3|Page
- use the CURRVAL + 1 expression for the sequence in the
VALUES list for a row
- code the sequence name in the VALUES list for a row
- code the sequence name + 1 in the VALUES list for a row -
ANSWER-use the NEXTVAL pseudo column for the sequence in
the VALUES list for a row
All of the aggregate functions ignore null values, except for the
______________________________ function. - ANSWER-
Count(*)
By default, all duplicate values are included in the aggregate
calculation, unless you specify the
___________________________ keyword. - ANSWER-distinct
Write an aggregate expression to find the oldest date in the
invoice_date column: - ANSWER-min(invoice_date)
Write an aggregate expression for the number of entries in the
vendor_name column: - ANSWER-count(vendor_name)
CIT 225 FINAL EXAM LATEST 2025/2026 ACTUAL EXAM WITH
COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS (100%
VERIFIED ANSWERS) |ALREADY GRADED A+| ||PROFESSOR
VERIFIED|| ||BRANDNEW!!!||
You use DDL statements to create, modify, and delete the
___________________________ of a database. - ANSWER-
Tables
A constraint that limits the values that can be stored in a column is
called a/an ______________________________ constraint. -
ANSWER-Check
A constraint that enforces referential integrity between tables is
called a/an ______________________________ constraint. -
ANSWER-Foreign Key
Oracle automatically creates indexes for primary key constraints
and for _______________ constraints. - ANSWER-unique
,2|Page
If you want to create an index that doesn't allow duplicate values,
you use the ____________________________ keyword in the
CREATE INDEX statement. - ANSWER-Unique
To modify the structure of an existing table, you use the
_______________________ statement. - ANSWER-Alter
When you create a script for creating a database,
- you can create the tables in whatever sequence you prefer
- you need to create the referred to tables before you create the
tables that refer to them
- you need to create the indexes before you create the tables that
they apply to
- you need to code the primary key column first in each table -
ANSWER-you need to create the referred to tables before you
create the tables that refer to them
To use a sequence in an INSERT statement, you
- use the NEXTVAL pseudo column for the sequence in the
VALUES list for a row
, 3|Page
- use the CURRVAL + 1 expression for the sequence in the
VALUES list for a row
- code the sequence name in the VALUES list for a row
- code the sequence name + 1 in the VALUES list for a row -
ANSWER-use the NEXTVAL pseudo column for the sequence in
the VALUES list for a row
All of the aggregate functions ignore null values, except for the
______________________________ function. - ANSWER-
Count(*)
By default, all duplicate values are included in the aggregate
calculation, unless you specify the
___________________________ keyword. - ANSWER-distinct
Write an aggregate expression to find the oldest date in the
invoice_date column: - ANSWER-min(invoice_date)
Write an aggregate expression for the number of entries in the
vendor_name column: - ANSWER-count(vendor_name)
