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 31

Essay

Review LaterAdd Note

Review Later

Explain the different basic types of join operations. What are they and how do they work?

Correct Answer

verified

Join operations can be classified as inn...

View Answer

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

MySQL allows multiple triggering conditions per trigger.

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

UNION, INTERSECT, and MINUS work properly only if relations are intersect-compatible, which means that the names of the relation attributes and their data types must be different.

Describe the important features and applications of SQL functions

Oracle uses the function to extract the various parts of a date.

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

is a cursor attribute that returns True if the last FETCH returned a row, and FALSE if not.

The syntax for a left outer join is .

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

The Oracle string concatenation function is .

The statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

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

The Oracle equivalent to an MS Access AutoNumber is a(n) .

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

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

The Oracle 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.

The clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

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

A(n) join will select only the rows with matching values in the common attribute(s) .

Oracle recommends for creating audit logs.