Exam 8: Advanced SQL

You can declare variables inside a stored procedure.

When using the Oracle TO_NUMBER function to convert a character string into a number,____ represents a digit.

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.

A(n)____________________ pools multiple transactions into a single batch to update a master table field in a single operation.

A(n)____________________ join returns all rows with matching values in the matching columns and eliminates duplicate columns.

The statement SELECT * FROM T1,T2 produces a(n)____ join.

In MS Access,you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

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

____ is a relational set operator.

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

The ____ pseudo-column is used to select the next value from a sequence.

In Oracle,____ make(s)it possible to merge SQL and traditional programming constructs,such as variables,conditional processing (IF-THEN-ELSE),basic loops (FOR and WHILE loops,)and error trapping.

The ____ query combines rows from two queries and excludes duplicates.

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.

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

The ____________________ join is the traditional join in which only rows that meet a given criteria are selected.

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?

A ____ is a query (SELECT statement)inside a query.

A statement-level trigger is assumed if you omit the FOR EACH ROW keywords.

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.