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

In a subquery,the ____ query is executed first.

A) left
B) right
C) inner
D) outer

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

The Oracle equivalent to an MS Access AutoNumber is a(n) ____.

A) auto-number
B) sequence
C) TO_NUMBER function
D) trigger

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The syntax for a left outer join is ____.

The Oracle ____ function returns the current date.

The ____________________ clause is used to restrict the output of a GROUP BY query by applying a conditional criteria to the grouped rows.

Every PL/SQL block must be given a name.

A stored function is another name for a stored procedure.

The ____________________ 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.

A trigger is executed as part of the transaction that triggered it.

The ____ data type is considered compatible with VARCHAR(35) .

The syntax for the UNION query is ____.

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)____________________ join returns the Cartesian product JOIN of T1 and T2 and is sometimes called "old style".

Triggers are critical to proper database operation and management.What are some of the ways that triggers are used?

The ____________________ statement combines rows from two or more queries without including duplicate rows.

The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.

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

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

One of the disadvantages of stored procedures is that they increase network traffic.

Cursors are held in a reserved memory area in the client computer.