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 51

True/False

Review LaterAdd Note

Review Later

Triggers can only be used to update table values.

A) True
B) False

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

A) True
B) False

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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?

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

Stored procedures must have at least one argument.

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

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

PL/SQL blocks have a section used to declare variables.

What are the four different result types that can be returned from a subquery? For each type,explain what it is and when it is used.

Stored procedures help reduce code duplication by means of code isolation and code sharing.

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

Using Oracle ____________________,you can write a PL/SQL code block by enclosing the commands inside BEGIN and END clauses.

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Describe the characteristics of an Oracle sequence.

The IN subquery uses a(n)____________________ operator.

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

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

If you wish to create an inner join,but the two tables do not have a commonly named attribute,you can use a(n) ____ clause.

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Cursor-style processing involves retrieving data from the cursor,one row at a time.