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

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

While the steps required to create and e...

View Answer

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.

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

A relational join operation merges rows from two tables.

Stored procedures must have at least one argument.

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

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

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.

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

The statement combines rows from two queries and excludes duplicates.

"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.

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

How are triggers critical to proper database operation and management?

is a relational set operator.

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

The syntax of the DECODE function starts with .

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.

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

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

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?