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 21

Multiple Choice

Review LaterAdd Note

Review Later

The operator could be used in place of INTERSECT if the DBMS does not support it.

A) IN
B) OF
C) AND
D) UNION

E) A) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

The Oracle function returns the current date.

A) DATE
B) SYSDATE
C) CURRENT_DATE
D) TO_DATE

E) B) and C)
F) C) and D)

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

A(n) routine pools multiple transactions into a single batch to update a master table field in a single operation.

Each statement inside the PL/SQL code must end with a period (".").

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

The following SQL statement uses a(n) . SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

Just like database triggers, stored procedures are stored in the database.

A is a query inside a query.

Which of the following is a feature of oracle sequences?

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

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

"Union-compatible" means that the .

The function returns the current system date in MS Access.

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

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?

A trigger definition consists of the triggering timing, the triggering event, the triggering level, and the triggering action.

A stored function is another name for a stored procedure.

is a string function that returns the number of characters in a string value.

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