D you need to create a sql plus environment variable

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: e command :X := CALCTAX(1000);. D. You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALCTAX; E. You need to create a SQL *Plus environment variable X and issue the command EXECUTE :X := CALCTAX(1000); Answer: E When you call a function from SQL*PLUS you need to assign the returned value a bind variable, and you need the EXECUTE command to execute the function. QUESTION 16: What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations? A. The rows are selected and ordered. B. The validity of the SQL statement is established. C. An area of memory is established to process the SQL statement. Actualtests.com - The Power of Knowing 1Z0-147 D. The SQL statement is run and the number of rows processed is returned. E. The area of memory established to process the SQL statement is released. Answer: D All SQL statements have to go through various stages. Some stages may be skipped. 1. Parse Every SQL statement must be parsed. Parsing the statement includes checking the statement's syntax and validating the statement, ensuring that all references to objects are correct, and ensuring that the relevant privileges to those objects exist. 2. Bind After parsing, the Oracle server knows the meaning of the Oracle statement but still may not have enough information to execute the statement. The Oracle server may need values for any bind variable in the statement. The process of obtaining these values is called binding variables. 3. Execute At this point, the Oracle server has all necessary information and resources, and the statement is executed. 4. Fetch In the fetch stage, rows are selected and ordered (if requested by the query), and each successive fetch retrieves another row of the result, until the last row has been fetched. You can fetch queries, but not the DML statements. QUESTION 17: What part of a database trigger determines the number of times the trigger body executes? A. Trigger type B. Trigger body C. Trigger event D. Trigger timing Answer: A QUESTION 18: Examine this code: CREATE OR REPLACE FUNCTION gen_email_name (p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER) RETURN VARCHAR2 is v_email_name VARCHAR2(19); BEGIN v_email_home := SUBSTR(p_first_...
View Full Document

Ask a homework question - tutors are online