Exam 8: Advanced SQL

The PL/SQL block starts with the ____ clause.

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

A(n)____ is a block of code (containing standard SQL statements and procedural extensions)that is stored and executed at the DBMS server.

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

How many rows would be returned from a cross join of tables A and B,if A contains 8 rows and B contains 18?

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

Just like database triggers,stored procedures are stored in the database.

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

Each statement inside the PL/SQL code must end with a period (".").

If the DBMS does not support the INTERSECT statement,you can use a(n)____________________ subquery to achieve the same result.

Assume you are using the UNION 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 UNION operator?

An explicit cursor must return two or more rows.

The Oracle ____ 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.

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

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

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

To test a trigger,you should use the EXECUTE TRIGGER command.

When using a(n)____ join,only rows that meet the given criteria are returned.

The ____ data type is compatible with NUMBER.

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