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

is a relational set operator.

A) MINUS
B) PLUS
C) ALL
D) EXISTS

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

Stored procedures must have at least one argument.

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

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

A relational join operation merges rows from two tables.

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.

The syntax of the DECODE function starts with .

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.

The statement combines rows from two queries and excludes duplicates.

How are triggers critical to proper database operation and management?

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

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.

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

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

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

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?

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

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