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 1

True/False

Review LaterAdd Note

Review Later

Subqueries cannot be used in combinations with joins.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Short Answer

Review LaterAdd Note

Review Later

The syntax of the DECODE function starts with .

Correct Answer

verified

DECODE(e,x,y,d)

Question 3

Multiple Choice

Review LaterAdd Note

The following SQL statement uses a(n) . SELECT P_CODE,P_DESCRIPT,P_PRICE,V_NAME FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

The syntax for a left outer join is .

The statement SELECT * FROM T1,T2 produces a(n) join.

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.

The function returns the current system date in MS Access.

BEFORE means before the changes are made in memory but after the changes are permanently saved to disk.

The Oracle function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

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

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

MySQL allows multiple triggering conditions per trigger.

functions extract a value of a given data type and convert it to the equivalent value in another data type.

A(n) join will select only the rows with matching values in the common attribute(s) .

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?

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions.

Assume a designer is using the UNION 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 Jenna and Howard are included in the CUSTOMER table as well as in the CUSTOMER_2 table.How many records are returned when using the UNION operator?

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.

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