Question 1

A(n)____________________ variable references a single value,such as a number,date,or character string.

Accepted Answer

scalar

Question 2

When you use the logical operator ____________________ in a complex expression,the combined expression will evaluate to TRUE if the expression on either side of the operator is true (both expressions do not need to be true).

Accepted Answer

OR

Question 3

What keyword is not used in a PL/SQL program?

Accepted Answer

A) UPDATE 
B) COMMIT 
C) ROLLBACK 
D) ALTER 
A) UPDATE 
B) COMMIT 
C) ROLLBACK 
D) ALTER D

Question 4

A(n)____________________ variable references a data structure that contains multiple scalar variables.

Accepted Answer

The answer of A(n)____________________ variable references a data structure that...

Question 5

A(n)____________________ exception must be declared and associated with an Oracle error code before it can be used.

Accepted Answer

The answer of A(n)____________________ exception must be declared and associated...

Question 6

When declaring a variable that has the same data type as a field,use the ____ type.

Accepted Answer

A) %FIELD 
B) %COLUMN 
C) %TYPE 
D) %ROWTYPE 
A) %FIELD 
B) %COLUMN 
C) %TYPE 
D) %ROWTYPE

Question 7

An IF statement is always followed by an ELSE statement.

Accepted Answer

A) True 
 B)False

Question 8

If the value of a conditional statement is NULL,it is evaluated as if it were false in a conditional statement.

Accepted Answer

A) True 
 B)False

Question 9

What is a disadvantage of using a Cursor FOR loop over processing a cursor with a LOOP ...EXIT WHEN loop?

Accepted Answer

A) It is slower 
B) It is more error-prone 
C) Cursor variables can not be used outside loop 
D) It is not supported in previous versions of Oracle 
A) It is slower 
B) It is more error-prone 
C) Cursor variables can not be used outside loop 
D) It is not supported in previous versions of Oracle

Question 10

A(n)____________________ loop evaluates the exit condition before any program commands execute.

Accepted Answer

The answer of A(n)____________________ loop evaluates the exit condition before...

Question 11

An explicit cursor must be opened before it can be processed.

Accepted Answer

A) True 
 B)False

Question 12

What loop is a pretest only loop?

Accepted Answer

A) Numeric FOR 
B) WHILE ...LOOP 
C) LOOP ...EXIT 
D) LOOP ...EXIT WHEN 
A) Numeric FOR 
B) WHILE ...LOOP 
C) LOOP ...EXIT 
D) LOOP ...EXIT WHEN

Question 13

To convert a string to all uppercase,use the ____________________ function.

Accepted Answer

The answer of To convert a string to all uppercase,use...

Question 14

What loop control structure uses an automatically incremented numeric counter?

Accepted Answer

A) Numeric FOR 
B) WHILE ...LOOP 
C) LOOP ...EXIT 
D) LOOP ...EXIT WHEN 
A) Numeric FOR 
B) WHILE ...LOOP 
C) LOOP ...EXIT 
D) LOOP ...EXIT WHEN

Question 15

When using logical operators,AND is always evaluated before OR.

Accepted Answer

A) True 
 B)False

Question 16

What are the three sections that make up a PL/SQL program block? Describe each one.

Accepted Answer

The program's declaration section begins

Question 17

A(n)____________________ is a program that enables software developers to pause program execution and examine current variable values.

Accepted Answer

The answer of A(n)____________________ is a program that enables software...

Question 18

DDL queries may be used in PL/SQL programs.

Accepted Answer

A) True 
 B)False

Question 19

A PL/SQL program usually begins with the keyword DECLARE.

Accepted Answer

A) True 
 B)False

Question 20

In a PL/SQL decision control structure the program code following the ____ statement executes when the condition is true.

Accepted Answer

A) DONE 
B) IF 
C) ELSE 
D) END IF 
A) DONE 
B) IF 
C) ELSE 
D) END IF

A(n)____________________ variable references a single value,such as a number,date,or character string.

When you use the logical operator ____________________ in a complex expression,the combined expression will evaluate to TRUE if the expression on either side of the operator is true (both expressions do not need to be true).

What keyword is not used in a PL/SQL program?

A(n)____________________ variable references a data structure that contains multiple scalar variables.

A(n)____________________ exception must be declared and associated with an Oracle error code before it can be used.

When declaring a variable that has the same data type as a field,use the ____ type.

An IF statement is always followed by an ELSE statement.

If the value of a conditional statement is NULL,it is evaluated as if it were false in a conditional statement.

What is a disadvantage of using a Cursor FOR loop over processing a cursor with a LOOP ...EXIT WHEN loop?

A(n)____________________ loop evaluates the exit condition before any program commands execute.

An explicit cursor must be opened before it can be processed.

What loop is a pretest only loop?

To convert a string to all uppercase,use the ____________________ function.

What loop control structure uses an automatically incremented numeric counter?

When using logical operators,AND is always evaluated before OR.

What are the three sections that make up a PL/SQL program block? Describe each one.

A(n)____________________ is a program that enables software developers to pause program execution and examine current variable values.

DDL queries may be used in PL/SQL programs.

A PL/SQL program usually begins with the keyword DECLARE.

In a PL/SQL decision control structure the program code following the ____ statement executes when the condition is true.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters

Exam 4: Introduction to PlSQL

A(n)____________________ variable references a single value,such as a number,date,or character string.

When you use the logical operator ____________________ in a complex expression,the combined expression will evaluate to TRUE if the expression on either side of the operator is true (both expressions do not need to be true).

What keyword is not used in a PL/SQL program?

A(n)____________________ variable references a data structure that contains multiple scalar variables.

A(n)____________________ exception must be declared and associated with an Oracle error code before it can be used.

When declaring a variable that has the same data type as a field,use the ____ type.

An IF statement is always followed by an ELSE statement.

If the value of a conditional statement is NULL,it is evaluated as if it were false in a conditional statement.

What is a disadvantage of using a Cursor FOR loop over processing a cursor with a LOOP ...EXIT WHEN loop?

A(n)____________________ loop evaluates the exit condition before any program commands execute.

An explicit cursor must be opened before it can be processed.

What loop is a pretest only loop?

To convert a string to all uppercase,use the ____________________ function.

What loop control structure uses an automatically incremented numeric counter?

When using logical operators,AND is always evaluated before OR.

What are the three sections that make up a PL/SQL program block? Describe each one.

A(n)____________________ is a program that enables software developers to pause program execution and examine current variable values.

DDL queries may be used in PL/SQL programs.

A PL/SQL program usually begins with the keyword DECLARE.

In a PL/SQL decision control structure the program code following the ____ statement executes when the condition is true.

Clientserver Databases and the Oracle10g Relational Database

Creating and Modifying Database Tables

Using SQL Queries to Insert, update, delete, and View Data

Introduction to Forms Builder

Creating Custom Forms

Creating Database Reports

Creating an Integrated Database Application

Advanced SQL and PlSQL Topics

Advanced Forms Builder Topics

Introduction to Oracle 10g Database Administration

Filters