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 51

Multiple Choice

Review LaterAdd Note

Review Later

In Oracle,make(s) it possible to merge SQL and traditional programming constructs,such as variables,conditional processing (IF-THEN-ELSE) ,basic loops (FOR and WHILE loops,) and error trapping.

A) cursor-style processing
B) stored procedures
C) embedded SQL
D) Procedural Language SQL

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

The statement combines the output of two SELECT queries.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

How many rows would be returned from a cross join of tables A and B,if A contains 8 rows and B contains 18?

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

An inequality condition is also known as a natural join and an equality condition is also called a theta join.

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

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

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

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

The statement uses the attribute list to indicate what columns to project in the resulting set.

The pseudo-column is used to select the next value from a sequence.

A(n)query can be used to produce a relation that retains the duplicate rows.

When using a(n) join,only rows that meet the given criteria are returned.

In Oracle,you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks.

The determines the common attribute or attributes by looking for identically named attributes and compatible data types.