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

Multiple Choice

Review LaterAdd Note

Review Later

The statement combines rows from two queries and excludes duplicates.

A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS

Correct Answer

verified

Show Answer

Question 42

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements)that are typically supported by a programming language.

The Oracle string concatenation function is .

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

The PL/SQL block starts with the section.

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

An explicit cursor must return two or more rows.

Which of the following is a feature of a correlated subquery?

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

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?

Stored procedures must have at least one argument.

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

Describe the characteristics of an Oracle sequence.

A sequence is not associated with a table and can be dropped from a database with a DROP SEQUENCE command.

The IN subquery uses a(n)operator.

A stored function is another name for a stored procedure.

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

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

Oracle recommends for creating audit logs.