FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Procedural Language Sql and Advanced Sql

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

If the DBMS does not support the INTERSECT statement, you can use a(n) ____________________ subquery to achieve the same result.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

When using the Oracle TO_DATE function, the code ____ represents a three-letter month name.

The most useful feature of PL/SQL blocks is that they let you create code that can be named, stored, and executed by the DBMS.

An explicit cursor must return two or more rows.

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

Stored procedures must have at least one argument.

The IN subquery uses a(n) ____________________ operator.

A trigger is executed as part of the transaction that triggered it.

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

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

In Oracle, the ____ function converts a date to a character string.

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

The ANSI standard defines ____ type(s) of outer join(s)

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

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

A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.

UNION, INTERSECT, and MINUS work properly only if relations are union-compatible, which means that the names of the relation attributes and their data types must be different.

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.

Describe the characteristics of an Oracle sequence.