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

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

The statement combines the output of two SELECT queries.

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.

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

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

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

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

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

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

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

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

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

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

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