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 persistent stored module is stored and executed on the database client machine.

The syntax of the MINUS statement in Oracle is .

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

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

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

The data type is considered compatible with VARCHAR(35).

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

In a subquery, the query is executed first.

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

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.

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

The PL/SQL block starts with the section.

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

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

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.

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

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

What are the four different types of results that can be returned from a subquery?

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