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);
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
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.
All SQL statements have to go through various stages. Some stages may be skipped.
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.
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.
At this point, the Oracle server has all necessary information and resources, and the
statement is executed.
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
QUESTION 18: Examine this code:
CREATE OR REPLACE FUNCTION gen_email_name
(p_first_name VARCHAR2, p_last_name VARCHAR2, p_id NUMBER)
v_email_home := SUBSTR(p_first_...
View Full Document
- Fall '09
- Stored procedure, Incorrect Answers