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 21

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

Describe the important features and applications of SQL functions

Correct Answer

verified

SQL functions are very useful tools.Func...

View Answer

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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.

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

The SELECT statement uses the attribute list to indicate what columns to project in the resulting set.

A relational join operation merges rows from two tables.

Triggers can only be used to update table values.

String manipulation functions are rarely used in programming.

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

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

How are triggers critical to proper database operation and management?

If a designer wishes to create an inner join,but the two tables do not have a commonly named attribute,he can use a(n) _____ clause.

"Union­compatible" means that the .

A persistent stored module is stored and executed on the database client machine.

A(n)subquery is a subquery that executes once for each row in the outer query.

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

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

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.

A view is a virtual table based on a SELECT query.

A(n) join returns not only the rows matching the join condition (that is,rows with matching values in the common columns) but also the rows with unmatched values.