Exam 4: Introduction to PlSQL

The ____________________ of a PL/SQL block starts with the BEGIN reserved word and consists of program statements,such as assignment statements,conditional structures,and looping structures.

In an IF/THEN/ELSE statement,the logic that comes after the ELSE is only executed if the condition is true.

The VARCHAR2 variable data type is exactly the same as the field data type.

If a cursor is named location_cursor,and you are using a LOOP ...EXIT WHEN loop to process the cursor,what is the exit condition for the loop?

What clause is added to the SELECT to retrieve values from an implicit cursor?

A data structure is a data object made up of multiple individual data elements.

What designates a one-line comment in PL/SQL?

What is the best way to debug a logic error in a PL/SQL program?

What command is used differently in PL/SQL from the way it is used when interacting directly with the database?

What are nested IF/THEN/ELSE structures?

The default buffer size in SQL*Plus is 2,000 characters.

What command is used to create a user-defined exception when an error condition occurs?

Use the function ____________________ to display a line of text.

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

What SQL statement could not be part of a PL/SQL program?

You must include a ____ at the end of a PL/SQL command.

In PL/SQL,the assignment operator is ____________________.

Oracle10g stores ____________________ data values internally in a binary format,which takes slightly less storage space than the NUMBER data type,so the system can perform calculations more quickly.

The ____________________ function converts either a number or a date value to a string using a specific format model.

Which string function is used to capitalize only the initial letter of a word?