Exam 8: Advanced SQL

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.

Numeric functions take one numeric parameter and return one value.

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

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

In the context of SELECT subquery types,a is returned when an UPDATE subquery is used.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL,C++,ASP,Java,or ColdFusion.

is a relational set operator.

Variables can be declared inside a stored procedure.

The operator could be used in place of INTERSECT if the DBMS does not support it.

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

Which of the following is a feature of oracle sequences?

is the term used to describe an environment in which the SQL statement is not known in advance and is generated at run time.

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

The syntax of the MINUS statement in Oracle is .

is a cursor attribute that returns TRUE if the last FETCH returned a row,and FALSE if not.

Every PL/SQL block must be given a name.

The operator could be used in place of MINUS if the DBMS does not support it.

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

The statement can be used to combine rows from two queries,returning only the rows that appear in both sets.

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