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

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Essay

Review LaterAdd Note

Describe the characteristics of an Oracle sequence.

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

A stored function is another name for a stored procedure.

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

The statement combines rows from two queries and excludes duplicates.

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?

The PL/SQL block starts with the section.

Stored procedures must have at least one argument.

Oracle recommends for creating audit logs.

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

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

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

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

An explicit cursor must return two or more rows.

The IN subquery uses a(n)operator.

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

The Oracle string concatenation function is .

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