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

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) DATE
B) INT
C) TINYINT
D) CHAR(15)

Correct Answer

verified

D

Question 3

True/False

Review LaterAdd Note

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

The PL/SQL block starts with the ____ clause.

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(n) ____________________ join performs a relational product (also known as the Cartesian product) of two tables.

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

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.

Stored procedures are executed using the EXEC command.

A row-level trigger requires use of the ____________________ keywords. This type of trigger is executed once for each row affected by the triggering statement.

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

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

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

A stored function is another name for a stored procedure.

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

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 subquery terminology, the first query in the SQL statement is known as the ____ query.

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

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.