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 31

True/False

Review LaterAdd Note

Review Later

To test a trigger,you should use the EXECUTE TRIGGER command.

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

When using a subquery,the output of a(n)____________________ query is used as the input for the outer query.

In an Oracle sequence,the ____________________ pseudo-column retrieves the current value of a sequence.

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

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables.

A stored function uses the ____ statement to return a value.

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.

Each statement inside the PL/SQL code must end with a period (".").

A row-level trigger requires use of the ____________________ keywords.This type of trigger is executed once for each row affected by the triggering statement.

Assume you are 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 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 operator?

How many rows would be returned from a cross join of tables A and B,if A contains 8 rows and B contains 18?

The PL/SQL block starts with the ____ clause.

An explicit cursor must return two or more rows.

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

Just like database triggers,stored procedures are stored in the database.

The ____ data type is compatible with NUMBER.

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

A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.

____________________ functions allow you to take a value of a given data type and convert it to the equivalent value in another data type.