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
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
