Exam 8: Advanced SQL

An inequality condition is also known as a natural join and an equality condition is also called a theta join.

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

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

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

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

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

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.

A(n)query can be used to produce a relation that retains the duplicate rows.

The statement uses the attribute list to indicate what columns to project in the resulting set.

is a string function that returns the number of characters in a string value.

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

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

The determines the common attribute or attributes by looking for identically named attributes and compatible data types.

The statement combines the output of two SELECT queries.

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.