FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Advanced SQL

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Short Answer

Review LaterAdd Note

Review Later

The ____________________ statement can be used to combine rows from two queries,returning only the rows that appear in both sets.

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2 ____________________ (common-column).

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

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

The PL/SQL block starts with the ____ clause.

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

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

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.

An explicit cursor must return two or more rows.

The ____ data type is compatible with NUMBER.

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

What are SQL functions and when are they used? Provide a couple of examples of situations in which they are necessary.

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

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

The syntax for the UNION query is ____.

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

"Union-compatible" means that the ____.

Assume you are using the UNION 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 UNION operator?

If the DBMS does not support the INTERSECT statement,you can use a(n)____________________ subquery to achieve the same result.

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

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