Exam 8: Advanced SQL

Oracle recommends ____ for creating audit logs.

The use of the ____________________ operator allows you to compare a single value with a list of values returned by the first subquery (sqA)using a comparison operator other than EQUALS.

"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.

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.

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

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

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

PL/SQL functions are executed in the same way as functions such as MIN and AVG.

A(n)____________________ join returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.

Explain the different types of join operations.What are they and how do they work?

Procedural code is executed on the database client machine.

The ____________________ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

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.

The following SQL statement uses a(n)____. SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

A(n)____ join returns not only the rows matching the join condition (that is,rows with matching values in the common columns)but also the rows with unmatched values.

The Oracle string concatenation function is ____.

"Union-compatible" means that the ____.

Stored procedures are executed using the EXEC command.

A(n)____________________ subquery is a subquery that executes once for each row in the outer query.

The ____ function returns the current system date in MS Access.