Exam 6: Procedural Language Sql and Advanced Sql

The IN subquery uses a(n) ____________________ operator.

The ANSI standard defines ____ type(s) of outer join(s)

Triggers are critical to proper database operation and management. What are some of the ways that triggers are used?

The most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.

PL/SQL blocks have a section used to declare variables.

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

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

UNION, INTERSECT, and MINUS work properly only if relations are union-compatible, which means that the names of the relation attributes and their data types must be different.

Using Oracle ____________________, you can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

A trigger is executed as part of the transaction that triggered it.

In Oracle, the ____ function converts a date to a character string.

Describe the characteristics of an Oracle sequence.

An explicit cursor must return two or more rows.

Oracle uses the ____________________ function to extract the various parts of a date.

Cursor-style processing involves retrieving data from the cursor, one row at a time.

Stored procedures help reduce code duplication by means of code isolation and code sharing.

When using the Oracle TO_DATE function, the code ____ represents a three-letter month name.

What are the four different result types that can be returned from a subquery? For each type, explain what it is and when it is used.

Stored procedures must have at least one argument.

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