Question 1

The error message "ORA-01422: exact fetch returns more than requested number of rows" indicates that the implicit cursor query tried to retrieve multiple records.

Accepted Answer

A) True 
 B)False

Question 2

In SQL*Plus,the command SET SERVEROUTPUT ____________________ SIZE 4000 is used to increase the buffer size to 4000.

Accepted Answer

The answer of In SQL*Plus,the command SET SERVEROUTPUT ____________________ SIZE...

Question 3

What section of a PL/SQL program is used for exception handling?

Accepted Answer

A) BEGIN 
B) DECLARE 
C) EXCEPTION 
D) ERROR 
A) BEGIN 
B) DECLARE 
C) EXCEPTION 
D) ERROR

Question 4

To parse a character string it is best to use the LENGTH and RTRIM functions.

Accepted Answer

A) True 
 B)False

Question 5

____________________ statements are lines of text that explain or document a program step or series of steps.

Accepted Answer

The answer of ____________________ statements are lines of text that...

Question 6

What predefined error indicates that a primary key constraint was violated?

Accepted Answer

A) DUP_VAL_ON_INDEX 
B) NO_DATA_FOUND 
C) INVALID_NUMBER 
D) VALUE_ERROR 
A) DUP_VAL_ON_INDEX 
B) NO_DATA_FOUND 
C) INVALID_NUMBER 
D) VALUE_ERROR

Question 7

PL/SQL is a procedural programming language.Explain what this statement means.Be sure to include at least three features of a procedural programming language.What makes PL/SQL the best language to use when programming applications for the Oracle 10g database?

Accepted Answer

A procedural programming language is a p

Question 8

Choose the composite variable.

Accepted Answer

A) VARRAY 
B) BINARY_INTEGER 
C) VARCHAR2 
D) DATE 
A) VARRAY 
B) BINARY_INTEGER 
C) VARCHAR2 
D) DATE

Question 9

A(n)____________________ FOR loop can be used to process a cursor without explicitly opening the cursor.

Accepted Answer

The answer of A(n)____________________ FOR loop can be used to...

Question 10

What are some common causes of syntax errors? How does a programmer detect and resolve syntax errors?

Accepted Answer

Syntax errors often involve misspelling

Question 11

What is a pointer to the context area?

Accepted Answer

A) explicit cursor 
B) implicit cursor 
C) declared cursor 
D) context cursor 
A) explicit cursor 
B) implicit cursor 
C) declared cursor 
D) context cursor

Question 12

What section of an exception handler handles unanticipated errors?

Accepted Answer

A) ELSE 
B) OTHER 
C) WHEN OTHERS 
D) ELSE OTHERS 
A) ELSE 
B) OTHER 
C) WHEN OTHERS 
D) ELSE OTHERS

Question 13

A string literal is enclosed in "" (double quotes).

Accepted Answer

A) True 
 B)False

Question 14

____ are typically written in lower-case letters according to the PL/SQL command capitalization style.

Accepted Answer

A) Database objects 
B) Built-in functions 
C) Reserved words 
D) Predefined data types 
A) Database objects 
B) Built-in functions 
C) Reserved words 
D) Predefined data types

Question 15

Any text between the characters /* and */ is considered a comment.

Accepted Answer

A) True 
 B)False

Question 16

To use a SQL ____________________ query (INSERT,UPDATE,or DELETE)or transaction control command in a PL/SQL command,you simply put the query or command in the PL/SQL program.

Accepted Answer

The answer of To use a SQL ____________________ query (INSERT,UPDATE,or...

Question 17

When a program has a syntax error,it will not execute.

Accepted Answer

A) True 
 B)False

Question 18

Choose the scalar variable.

Accepted Answer

A) TABLE 
B) RECORD 
C) BOOLEAN 
D) VARRAY 
A) TABLE 
B) RECORD 
C) BOOLEAN 
D) VARRAY

Question 19

What command is used to associate an exception variable with an undefined Oracle error code?

Accepted Answer

A) EXCEPTION DECLARE 
B) PRAGMA EXCEPTION_INIT 
C) PRAGMA ERROR 
D) PRAGMA EX_INIT 
A) EXCEPTION DECLARE 
B) PRAGMA EXCEPTION_INIT 
C) PRAGMA ERROR 
D) PRAGMA EX_INIT

Question 20

To find the length of a string,use the ____________________ function.

Accepted Answer

The answer of To find the length of a string,use...

The error message "ORA-01422: exact fetch returns more than requested number of rows" indicates that the implicit cursor query tried to retrieve multiple records.

In SQL*Plus,the command SET SERVEROUTPUT ____________________ SIZE 4000 is used to increase the buffer size to 4000.

What section of a PL/SQL program is used for exception handling?

To parse a character string it is best to use the LENGTH and RTRIM functions.

____________________ statements are lines of text that explain or document a program step or series of steps.

What predefined error indicates that a primary key constraint was violated?

PL/SQL is a procedural programming language.Explain what this statement means.Be sure to include at least three features of a procedural programming language.What makes PL/SQL the best language to use when programming applications for the Oracle 10g database?

Choose the composite variable.

A(n)____________________ FOR loop can be used to process a cursor without explicitly opening the cursor.

What are some common causes of syntax errors? How does a programmer detect and resolve syntax errors?

What is a pointer to the context area?

What section of an exception handler handles unanticipated errors?

A string literal is enclosed in "" (double quotes).

____ are typically written in lower-case letters according to the PL/SQL command capitalization style.

Any text between the characters /* and */ is considered a comment.

To use a SQL ____________________ query (INSERT,UPDATE,or DELETE)or transaction control command in a PL/SQL command,you simply put the query or command in the PL/SQL program.

When a program has a syntax error,it will not execute.

Choose the scalar variable.

What command is used to associate an exception variable with an undefined Oracle error code?

To find the length of a string,use the ____________________ function.

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

The error message "ORA-01422: exact fetch returns more than requested number of rows" indicates that the implicit cursor query tried to retrieve multiple records.

In SQL*Plus,the command SET SERVEROUTPUT ____________________ SIZE 4000 is used to increase the buffer size to 4000.

What section of a PL/SQL program is used for exception handling?

To parse a character string it is best to use the LENGTH and RTRIM functions.

____________________ statements are lines of text that explain or document a program step or series of steps.

What predefined error indicates that a primary key constraint was violated?

PL/SQL is a procedural programming language.Explain what this statement means.Be sure to include at least three features of a procedural programming language.What makes PL/SQL the best language to use when programming applications for the Oracle 10g database?

Choose the composite variable.

A(n)____________________ FOR loop can be used to process a cursor without explicitly opening the cursor.

What are some common causes of syntax errors? How does a programmer detect and resolve syntax errors?

What is a pointer to the context area?

What section of an exception handler handles unanticipated errors?

A string literal is enclosed in "" (double quotes).

____ are typically written in lower-case letters according to the PL/SQL command capitalization style.

Any text between the characters /* and */ is considered a comment.

To use a SQL ____________________ query (INSERT,UPDATE,or DELETE)or transaction control command in a PL/SQL command,you simply put the query or command in the PL/SQL program.

When a program has a syntax error,it will not execute.

Choose the scalar variable.

What command is used to associate an exception variable with an undefined Oracle error code?

To find the length of a string,use the ____________________ function.

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