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 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) full
B) inner
C) outer
D) set

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

A(n) view is a view that can be used to update attributes in the base table(s) that are used in the view.

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion.

Summarize the hierarchy of steps involved in creating and running an executable program with embedded SQL statements.

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

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

How are triggers critical to proper database operation and management?

Assume you are using the UNION ALL 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 UNION ALL operator?

The statement combines rows from two queries and excludes duplicates.

In MS Access, a designer can use the data type to define a column in his table that will be automatically populated with unique numeric values.

Stored procedures must have at least one argument.

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

All join conditions are connected through a(n) logical operator.

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

The syntax of the DECODE function starts with .

A relational join operation merges rows from two tables.

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

When using the Oracle TO_NUMBER function to convert a character string into a number, represents a digit.

is a relational set operator.