Exam 4: Introduction to PlSQL

PL/SQL is a(n)____________________ typed language,which means that you must write a command that explicitly declares each variable and specifies its data type before you use the variable.

To create a reference variable to a database field,use the %FIELD data type.

What happens if a condition in an IF statement evaluates to NULL?

The result of the expression 'Jane' || 'Doe' in PL/SQL would be 'Jane Doe'.

Every PL/SQL variable must be declared with a data type before it is used.

What keyword comes first in a PL/SQL program?

Why is it important to close an explicit cursor?

To remove trailing spaces,use the ____ function.

When you declare a variable with data type NUMBER,what is the value before you assign a value?

A(n)____________________ is a pointer to a memory location on the database server that the DBMS uses to process a SQL query.

What would be the value of variable str_length after executing the following: str_length := LENGTH('123345');

Given the character string 'I am a yellow dog" in variable c_str,what would be the expected value of the c_substr variable after the following commands are executed: yellow_pos := instr(c_str,'yellow'); C_substr := substr(c_str,1,yellow_pos);

To capitalize the first letter only of a character string,use the INITCAP function.

If a = TRUE and b = FALSE,which of the following statements is TRUE?

What is an implicit cursor? Be sure to explain how the DBMS processes queries,and what the context area is.

A(n)____________________ variable directly references a specific database column or row and assumes the data type of the associated column or row.

When you declare a variable in PL/SQL,the variable's default value is always ____________________.

To assign a value to a variable use the = operator.

The numeric FOR loop executes a predetermined number of times.

To find the position of one string in another,use the ____________________ function.