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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) CONVERT()
B) TO_DATE
C) TO_CHAR()
D) TO_STRING()

E) All of the above
F) A) and C)

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

The IN subquery uses a(n) ____________________ operator.

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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

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.

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

Describe the characteristics of an Oracle sequence.

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

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.

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.

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

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

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

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.

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.

An explicit cursor must return two or more rows.

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

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

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