CIT 184 Final Exam 2026 | All Questions and Correct Answers | Graded A+ | Verified Answers | Just Released

CIT 325 Final Exam Actual Exam | All Questions
and Correct Answers | Already Graded A+ |
Verified Answers | Just Released

Which of the following are considered composite variables (choose all that
apply)? ---------CORRECT ANSWER-----------------Any array data type
Any structure data type
Any object data type
Any object data type




The declaration block starts with the DECLARE keyword and ends with the BEGIN
keyword for anonymous blocks. ---------CORRECT ANSWER-----------------True




Which of the following are the default date masks (choose all that apply)? ---------
CORRECT ANSWER-----------------DD-MON-RR
DD-MON-YYYY




Which of the following are considered scalar variables (choose all that apply)? -----
----CORRECT ANSWER-----------------The NUMBER data type
The TIMESTAMP data type
The VACHAR2 data type

,Procedures mimic methods that don't return a value. ---------CORRECT ANSWER----
-------------True




A declaration block does which of the following (choose all that apply)? ---------
CORRECT ANSWER-----------------Declare variables
Declare functions
Declare object types
Declare record types
Declare constants




PL/SQL supports two types of programs: anonymous (or unnamed) block
programs and named block programs. ---------CORRECT ANSWER-----------------True




Which of the following are data types that are dynamically sized strings (choose
all that apply)? ---------CORRECT ANSWER-----------------VARCHAR2
NVARCHAR2
VARCHAR




Schema-level subroutines can't access calling scope blocks because they are
independently defined blocks. ---------CORRECT ANSWER-----------------True

,Which of the following opens a multiple line comment (choose all that applies)? --
-------CORRECT ANSWER-----------------/*




The DATE data type is the base type for dates, times, and intervals. ---------
CORRECT ANSWER-----------------True




SQL collections can exist for scalar data types or SQL UDT elements. ---------
CORRECT ANSWER-----------------True




Which keywords are used in an anonymous block program (choose all that
apply)? ---------CORRECT ANSWER-----------------End
Quit
Declare




Functions return a value and may be used as the right operand in a right-to-left
variable assignments. ---------CORRECT ANSWER-----------------True




Which of the following are types of SQL statements (choose all that apply)? --------
-CORRECT ANSWER-----------------Data Control Language (DCL)
Data Manipulation Language (DML)

, Transaction Control Language (TCL)
Data Definition Language (DDL)




In the mid-1990s, developers described PL/SQL 2.x programming as a "black art". -
--------CORRECT ANSWER-----------------True




SQL stands for Structured Query Language. ---------CORRECT ANSWER-----------------
True




PL/SQL replaces SQL. ---------CORRECT ANSWER-----------------False




Which of the following are Data Definition Language (DDL) statements (choose all
that apply)? ---------CORRECT ANSWER-----------------ALTER
CREATE
DROP




PL/SQL was developed with which of the following modeling concepts (choose all
that apply)? ---------CORRECT ANSWER-----------------exception management
static data typing
modularity
parallel or concurrent processing