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 41

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 42

True/False

Review LaterAdd Note

Review Later

Each statement inside the PL/SQL code must end with a period (".").

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Short Answer

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.

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

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

Stored procedures must have at least one argument.

One of the disadvantages of stored procedures is that they increase network traffic.

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

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

Stored procedures are executed using the EXEC command.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

In MS Access,you can use the ____________________ data type to define a column in your table that will be automatically populated with unique numeric values.

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.

Every PL/SQL block must be given a name.

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

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 returns not only the matching rows but also the rows with unmatched attribute values for one or both tables to be joined.

Triggers can only be used to update table values.

____ is a relational set operator.

In a subquery,the ____ query is executed first.