Incorrect answers a deptree displaysthe indirect

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: gle indent indicates a direct dependency, a double indent represents an indirect dependency. Incorrect Answers A. DEPTREE displaysthe indirect dependencies without indentation. This view uses a nested_level column with a value of 0,1 or 2 to indicate the nesting level. C & D are not valid dictionary views QUESTION 51: The OLD and NEW qualifiers can be used in which type of trigger? Actualtests.com - The Power of Knowing 1Z0-147 A. Row level DML trigger B. Row level system trigger C. Statement level DML trigger D. Row level application trigger E. Statement level system trigger F. Statement level application trigger Answer: A Explanation: The qualifiers :OLD and :NEW can only be used with row level DML triggers. Incorrect Answers B, C, D, E & F. ROW level triggers do not apply to application or system triggers. The :OLD & :NEW Qualifiers only apply to DML ROW level Triggers. QUESTION 52: Which statement is true? A. Stored functions can be called from the SELECT and WHERE clauses only. B. Stored functions do not permit calculations that involve database links in a distributed environment. C. Stored functions cannot manipulate new types of data, such as longitude and latitude. D. Stored functions can increase the efficiency of queries by performing functions in the query rather than in the application. Answer: D Explanation: User-defined functions increase the efficiency of queries by applying the functions in the query itself. This drastically improves the performance because the query is designed to use the function instead of using the query and functions separately from client-side tools when enforcing application logic. Incorrect Answers A. Functions can be invoked as part of SELECT statements (in the column list, WHERE, GROUP BY, HAVING and ORDER BY clauses), in the UPDATE statement (in the SET and WHERE clause), in the DELETE statement (in the WHERE clause), and in the INSERT statement (in the VALUES clause). B. Functions allow calculations on data across a database link. C. Functions can be used to manipulate these data types. Actualtests.com - The Power of Knowing 1Z0-147 QUESTION 53: Examine the trigger: CREATE OR REPLACE TRIGGER Emp_count AFTER DELETE O...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online