Question 1

What is the default size,in characters,for the SQL*Plus buffer?

Accepted Answer

A) 1,000 
B) 2,000 
C) 3,000 
D) 4,000 
A) 1,000 
B) 2,000 
C) 3,000 
D) 4,000

Question 2

What type of program is helpful in finding logic errors?

Accepted Answer

A) interpreter 
B) sequential processor 
C) debugger 
D) executor 
A) interpreter 
B) sequential processor 
C) debugger 
D) executor

Question 3

When you execute a SELECT statement in a PL/SQL program that returns exactly one row,you must use an explicit cursor.

Accepted Answer

A) True 
 B)False

Question 4

What operator represents exponentiation in PL/SQL?

Accepted Answer

A) ^ 
B) # 
C) ** 
D) @ 
A) ^ 
B) # 
C) ** 
D) @

Question 5

The ____________________ data type assumes the data type of a database record.

Accepted Answer

The answer of The ____________________ data type assumes the data...

Question 6

To assign a value to a variable,use the ____ operator.

Accepted Answer

A) = 
B) := 
C) =: 
D) = = 
A) = 
B) := 
C) =: 
D) = =

Question 7

If NUMBER variable x has a value of NULL,and y has a value of 1,then the result of x * y is 1.

Accepted Answer

A) True 
 B)False

Question 8

What is the active set?

Accepted Answer

A) Set of data retrieved by a SELECT command 
B) Set of data inserted by an INSERT command 
C) Set of data deleted by a DELETE command 
D) Set of data updated by an UPDATE command 
A) Set of data retrieved by a SELECT command 
B) Set of data inserted by an INSERT command 
C) Set of data deleted by a DELETE command 
D) Set of data updated by an UPDATE command

Question 9

There are variable data types called INTEGER and REAL.

Accepted Answer

A) True 
 B)False

Question 10

What does the expression 1  5 evaluate to?

Accepted Answer

A) TRUE 
B) FALSE 
C) NULL 
D) Undefined 
A) TRUE 
B) FALSE 
C) NULL 
D) Undefined

Question 11

To concatenate two strings,use the ____ operator.

Accepted Answer

A) & 
B) && 
C) || 
D) + 
A) & 
B) && 
C) || 
D) +

Question 12

The ____________________ operator indicates greater than or equal to.

Accepted Answer

The answer of The ____________________ operator indicates greater than or...

Question 13

What is the prefix for error codes generated by PL/SQL?

Accepted Answer

A) ORA 
B) PLS 
C) PLA 
D) OSL 
A) ORA 
B) PLS 
C) PLA 
D) OSL

Question 14

In programming,decision control structures alter the order in which statements execute,based on the values of certain variables.

Accepted Answer

A) True 
 B)False

Question 15

In a PL/SQL program,2 ** 3 = 6.

Accepted Answer

A) True 
 B)False

Question 16

The end of each PL/SQL command is marked with a .(period).

Accepted Answer

A) True 
 B)False

Question 17

An undefined exception must be declared before it can be handled.

Accepted Answer

A) True 
 B)False

Question 18

To execute a PL/SQL program in SQL*Plus use the @ character after the last line of the program.

Accepted Answer

A) True 
 B)False

Question 19

The LOOP...EXIT Loop can be a pretest or posttest loop.

Accepted Answer

A) True 
 B)False

Question 20

A(n)____________________ error occurs when a command does not follow the guidelines of the programming language.

Accepted Answer

The answer of A(n)____________________ error occurs when a command does...

What is the default size,in characters,for the SQL*Plus buffer?

What type of program is helpful in finding logic errors?

When you execute a SELECT statement in a PL/SQL program that returns exactly one row,you must use an explicit cursor.

What operator represents exponentiation in PL/SQL?

The ____________________ data type assumes the data type of a database record.

To assign a value to a variable,use the ____ operator.

If NUMBER variable x has a value of NULL,and y has a value of 1,then the result of x * y is 1.

What is the active set?

There are variable data types called INTEGER and REAL.

What does the expression 1 <> 5 evaluate to?

To concatenate two strings,use the ____ operator.

The ____________________ operator indicates greater than or equal to.

What is the prefix for error codes generated by PL/SQL?

In programming,decision control structures alter the order in which statements execute,based on the values of certain variables.

In a PL/SQL program,2 ** 3 = 6.

The end of each PL/SQL command is marked with a .(period).

An undefined exception must be declared before it can be handled.

To execute a PL/SQL program in SQL*Plus use the @ character after the last line of the program.

The LOOP...EXIT Loop can be a pretest or posttest loop.

A(n)____________________ error occurs when a command does not follow the guidelines of the programming language.

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

What is the default size,in characters,for the SQL*Plus buffer?

What type of program is helpful in finding logic errors?

When you execute a SELECT statement in a PL/SQL program that returns exactly one row,you must use an explicit cursor.

What operator represents exponentiation in PL/SQL?

The ____________________ data type assumes the data type of a database record.

To assign a value to a variable,use the ____ operator.

If NUMBER variable x has a value of NULL,and y has a value of 1,then the result of x * y is 1.

What is the active set?

There are variable data types called INTEGER and REAL.

What does the expression 1 <> 5 evaluate to?

To concatenate two strings,use the ____ operator.

The ____________________ operator indicates greater than or equal to.

What is the prefix for error codes generated by PL/SQL?

In programming,decision control structures alter the order in which statements execute,based on the values of certain variables.

In a PL/SQL program,2 ** 3 = 6.

The end of each PL/SQL command is marked with a .(period).

An undefined exception must be declared before it can be handled.

To execute a PL/SQL program in SQL*Plus use the @ character after the last line of the program.

The LOOP...EXIT Loop can be a pretest or posttest loop.

A(n)____________________ error occurs when a command does not follow the guidelines of the programming language.

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