FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Procedural Language Sql and Advanced Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

A stored function is another name for a stored procedure.

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

Stored procedures are executed using the EXEC command.

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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 row-level trigger requires use of the ____________________ keywords. This type of trigger is executed once for each row affected by the triggering statement.

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

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

When using a subquery, the output of a(n) ____________________ query is used as the input for the outer query.

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

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

____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.

Cursors are held in a reserved memory area in the client computer.

A stored function uses the ____ statement to return a value.

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.

The ____________________ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

In an Oracle sequence, the ____________________ pseudo-column retrieves the current value of a sequence.

The PL/SQL block starts with the ____ clause.

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.

A(n) ____________________ join performs a relational product (also known as the Cartesian product) of two tables.

A(n) ____________________ view is a view that can be used to update attributes in the base table(s) that are used in the view.

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