Exam 6: Procedural Language Sql and Advanced Sql

The ____ data type is considered compatible with VARCHAR(35).

A(n) ____________________ view is a view that can be used to update attributes in the base table(s) that are used in the view.

SQL supports the conditional execution of procedures (if...then...else statements) that are typically supported by a programming language.

____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

A(n) ____________________ query can be used to produce a relation that retains the duplicate rows.

A stored function is another name for a stored procedure.

A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

In subquery terminology, the first query in the SQL statement is known as the ____ query.

When using a subquery, the output of a(n) ____________________ query is used as the input for the outer query.

A row-level trigger requires use of the ____________________ keywords. This type of trigger is executed once for each row affected by the triggering statement.

Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator?

The PL/SQL block starts with the ____ clause.

A stored function uses the ____ statement to return a value.

The ____________________ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

In an Oracle sequence, the ____________________ pseudo-column retrieves the current value of a sequence.

A(n) ____________________ join performs a relational product (also known as the Cartesian product) of two tables.

Stored procedures are executed using the EXEC command.

The ____________________ outer join returns not only the rows matching the join condition (that is, rows with matching values in the common column), but also the rows in the left-side table with unmatched values in the right-side table.

Cursors are held in a reserved memory area in the client computer.